Running a row / multiple rows only in mySQL Query Browser

Question

I have already used Microsoft SQL Server 2005 and found it very simple to execute single / multiple sql query strings.

Example:

insert into tablea
($vala, $valb, $valc)
values
($vala, $valb, $valc);


insert into tableb
($vala, $valb, $valc)
values
($vala, $valb, $valc);

How to complete the second part? In MSSQL, I select the second insert tab and press F5. How to do it in mySQL?

Answer 1

The problem is that you should try to execute the query from the Query tab, not from the Script tab. Go to File → New Script tab and enter a few of your statements here. Then click the Run button ... what is it.

Hope this helps!

Machi

Answer 2

. MySQL, , :

select "hello world";
select "second query";

, . . , . , , , . , , (), .

Answer 3

MySQL, mysqli. : http://php.net/manual/en/mysqli.quickstart.multiple-statement.php

Answer 4

workbench , , , Ctrl + Enter.

Ctrl + Shift + Enter /.

, , Ctrl + Shift + Enter .

Answer 5

""? , , . , MySQL Workbench.

Answer 6

, , :

" "; " ";

and outputting it gives an error - when I select / select any of them and execute it, you get the same error - so I need to either delete one of the requests, or comment on this, or use a script editor that does not work for me and many others users who use MS SQL 2000,2005.

If there is a solution for this - ideally, he should fulfill the request that I choose. Just an opinion

Rohan