knrt.net
当前位置:首页 >> [Err] 1064 % You hAvE An Error in your SQL synt... >>

[Err] 1064 % You hAvE An Error in your SQL synt...

mysqldump -uroot -hlocalhost -B db1 -t tb1>/mysql/tb1.sql;

你好,你的语句是没有问题,很正确,根据错误提示应该是你的mysql版本是否支持DROP TABLE IF EXISTS d_product这个语法,不支持的话就是语法错误了。有问题再追问。

near 'creat database shiyun,create少写了字母。

你的SQL语法错误,仔细检查你的拼写

运行cmd,进入mysql安装目录,重新安装mysql server: mysql/bin>mysqld -removemysql/bin>mysqld -installmysql/bin>mysql_config_editor.exe set -u root -p

DROP TABLE IF EXISTS info;CREATE TABLE info ( `Id` INT(11) NOT NULL AUTO_INCREMENT, `timer` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', `temperature` INT(11) NOT NULL DEFAULT 0, `humidity` INT(11) NOT NULL DEFAULT 0, `typ...

'Order (orderNO, userID, submitTime, consignTime, totalPrice, remark, IPAdress, i' 是个字符串,不是i后面有单引 你要把sql贴出来才行

protected void Page_Load(object sender, EventArgs e) { SqlDataSource1.SelectCommand = "SELECT * FROM tel where ename='" + Request.QueryString["ID"] + "'"; }

语法错误,mysql里没int函数吧,int函数在access里的作用是取整数,你把 int(WS_Endip)改成 round(WS_Endip,0)就可以了,

[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...

网站首页 | 网站地图
All rights reserved Powered by www.knrt.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com