insert into html_data (cat,content,posted,title,link,description,images1,images2,images3,pubdate) values ('中文','中文','now()','中文','','中文','','','','2007-02-05 16:46:19')Error Code : 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 ''2007-02-05 16:' at line 1
(0 ms taken)是个语法错误,奇怪了
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 ''2007-02-05 16:' at line 1
(0 ms taken)是个语法错误,奇怪了
解决方案 »
- 如何查看 mysql 表中最近更新的记录
- 查询修改过的字段(第一次正常查询)
- mssql 表结构以及视图如何导入mysql?
- vc中怎么样调用mysql的存储过程
- 进入MySql
- 请教:如何写一个自动建库并导入大量oracle数据的mysql数据库脚本?
- Connexion to mySQL failure : error 10060 (肯定也有人碰到过,我搞不定,SOS!)
- 为什么我的mysql不能启动?
- 求教:MyOdbc和Access的转换问题。
- 帮我看看怎么优化,谢谢了
- 如何高效地实现SELECT的同时更新某个字段?
- 请问:table1表中的number记录了table2中的记录数,当table2加删记录时, 怎样用SQL语句更新这个number
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 ''2007-02-05 16:' at line 1
(0 ms taken)
----------- ------------ ------ ------ ------- -------------- -------------------------------
id int(11) PRI (NULL) auto_increment select,insert,update,references
cat varchar(100) select,insert,update,references
content text YES (NULL) select,insert,update,references
posted varchar(50) YES (NULL) select,insert,update,references
title varchar(200) YES (NULL) select,insert,update,references
link varchar(200) YES (NULL) select,insert,update,references
description text YES (NULL) select,insert,update,references
images1 varchar(200) YES (NULL) select,insert,update,references
images2 varchar(200) YES (NULL) select,insert,update,references
images3 varchar(200) YES (NULL) select,insert,update,references
pubdate datetime YES (NULL) select,insert,update,references