MYSQL 5.5 语法错误

SELECT * from information_schema.`COLUMNS`  WHERE (table_schema = SELECT DATABASE())


[Err] 1064 - 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 'SELECT DATABASE())' at line 1
请问这句话有错吗？错在哪？怎么都执行错误

答案：where后面那个“(”位置搞错了。
1、SELECT * from information_schema.COLUMNS  WHERE table_schema = (SELECT DATABASE());
2、SELECT * from information_schema.COLUMNS  WHERE table_schema IN (SELECT DATABASE());

其他：CREATE PROCEDURE proc_test()

BEGIN
 select * from tbCity; 
END;
去掉 DELIMITER // ，END// 改成END;
 

上一个：mysql 与Oracle数据同步
下一个：Mysql 排序问题