当我做mysql dump恢复数据的时候遇到这样的问题ERROR at line 1976: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1064 (42000) at line 1978: 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 'delete from CMSContent_Price
where serviceid = OLD.serviceid' at line 4数据是从Mysql ersion 5.0.22恢复到5.0.27
ERROR 1064 (42000) at line 1978: 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 'delete from CMSContent_Price
where serviceid = OLD.serviceid' at line 4数据是从Mysql ersion 5.0.22恢复到5.0.27
DELIMITER 后面必须得要附加一个分隔符号,例如:
delimiter ||
delimiter $$
...