The SQL command SELECT does not work with ;

Why?

thank !!

In what context are you trying to use the SQL SELECT command with ; ?

Somewhere in PhpED? In your PHP code? Please tell us more

in PhpED the SQL SELECT command works without ;
ONLY

So you are using the DB Browser SQL panel?

As far as I am aware, that panel will execute all SQL statements including multiple statements that separated by ;

However, PhpED only displays the result of the last SQL statement. If the last SQL statement ends with a ; then it appears that PhpED counts that as an empty result set and displays nothing, which might well be construed as a bug although Nusphere might also argue that it is a deliberate feature to allow you to stop a result set being displayed.

For example, this update and select works and displays a result set:



This also works fine, but the last ; means PhpED displays an empty result set:



I guess it's also possible that MySQL is responsible for returning the empty result set. I haven't tested that.

Yes I use the DB Browser SQL panel

It really makes no sense and I think this is a bug

thank you anyway

If it causes problems for you, I recommend you report it at http://shop.nusphere.com/customer/support.php

Looks like a straight-forward bug for them to fix.

even if PhpED only displays the result of the last SQL statement you can put a ;
in the logic ...

thank you

semicolon separates different statements. It makes sense to run multiple insert/update/delete etc in one script. In this case phped runs in batch mode and no data is fetched -> so selects does not show the data.