Sorry for the vague title, I couldn't think of a way to summarize this.
Before submitting a ticket, I wanted to see if others are having this problem. I'm using PMA v. 4.0.4.2.
When I run a command with multiple queries and no SELECT, it brings me back to a page that shows the query, and it's editable. Like:
INSERT INTO table1 VALUES ('1', '2'); # 1 row affected
INSERT INTO table2 VALUES ('3', '4'); # 1 row affected
Which is what it has always done. But when I submit a second query in this textarea, after I click "Go" it wipes out my new query, and instead runs the first one that I submitted.
Meaning, I highlight the above text in the textarea, and type or paste a new query:
INSERT INTO table3 VALUES ('5', '6');
When I click "Go", my new "table3" query disappears and the first two "table1" and "table2" queries come back, then the query submits.
The only way around this has been to click "Show Query Box" in the upper left (which shows the same thing, but with line numbers, styled formatting, and without the # 1 row affected), then type the new query there. Or, of course, I can click "SQL" in the main navigation to start over.
I hope this is explained well. If others are experiencing this, please reply and I'll submit a ticket.
Before submitting a ticket, I wanted to see if others are having this problem. I'm using PMA v. 4.0.4.2.
When I run a command with multiple queries and no SELECT, it brings me back to a page that shows the query, and it's editable. Like:
INSERT INTO table1 VALUES ('1', '2'); # 1 row affected
INSERT INTO table2 VALUES ('3', '4'); # 1 row affected
Which is what it has always done. But when I submit a second query in this textarea, after I click "Go" it wipes out my new query, and instead runs the first one that I submitted.
Meaning, I highlight the above text in the textarea, and type or paste a new query:
INSERT INTO table3 VALUES ('5', '6');
When I click "Go", my new "table3" query disappears and the first two "table1" and "table2" queries come back, then the query submits.
The only way around this has been to click "Show Query Box" in the upper left (which shows the same thing, but with line numbers, styled formatting, and without the # 1 row affected), then type the new query there. Or, of course, I can click "SQL" in the main navigation to start over.
I hope this is explained well. If others are experiencing this, please reply and I'll submit a ticket.