MySQL ANSI Mode
Posted: Fri Feb 23, 2007 5:13 am
According to this page in the MySQL you can execute these two commandsto run your server in ANSI mode. This I did. Then I restarted the server. And yet I didn't the result I expected.
I thought with ANSI mode you use single quotes instead of backticks for indentifier names. So......would work and......wouldn't and yet I get this...
Have I done something wrong / got the wrong end of the stick?
Code: Select all
SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET GLOBAL sql_mode = 'ANSI';I thought with ANSI mode you use single quotes instead of backticks for indentifier names. So...
Code: Select all
DROP DATABASE IF EXISTS 'Example';Code: Select all
DROP DATABASE IF EXISTS `Example`;Code: Select all
mysql> DROP DATABASE IF EXISTS 'Example';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Example'' at line 1
mysql>