重新导入后又报错 #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 '><span style=\"font-size: x-large\"><span style=\"font-family: 宋体; mso-bidi-' at line 6
用命令行导入吧 注意sql文件路径要写对 mysql -u root -pmysql>use 数据库然后使用source命令,后面参数为脚本文件(如这里用到的.sql)mysql>source d:aa.sql或者 mysql -uroot -p database1<d:\aa.sql;
含义是如果名为 yhc_admin_user 的表存在则删除之如果出错的话,应该是你没有打开数据库
#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 '><span style=\"font-size: x-large\"><span style=\"font-family: 宋体; mso-bidi-' at line 6
mysql -u root -pmysql>use 数据库然后使用source命令,后面参数为脚本文件(如这里用到的.sql)mysql>source d:aa.sql或者
mysql -uroot -p database1<d:\aa.sql;
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `yihaichao`.`yhc_sessions` (sesskey, expiry, ip, data) VALUES ('ff2ded9a23e759a6711123de6415e782', '1352704821', '127.0.0.1', 'a:0:{}') ) [2] => Array ( [error] => Table 'yihaichao.yhc_sessions' doesn't exist ) [3] => Array ( [errno] => 1146 ) )
表 yhc_sessions 不存在