V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
This topic created in 2850 days ago, the information mentioned may be changed or developed.
INSERT IGNORE INTO config (config_id, VALUE, mark) VALUES ( 'class_url', NULL, '班级' );
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 ' -- INSERT IGNORE INTO config (config_id,VALUE, mark) VALUES ('class' at line 1 各位大大，这个哪里不对了呢，我把 value 试了加单引号双引号都不行。
 |
1
BBCCBB Jul 9, 2018
`` , 1 左边那个按键, 不是单引号 /双引号
|
 |
2
nu11001 Jul 9, 2018
明显不是 value 的问题
|
 |
3
saulshao Jul 10, 2018
所有的字段名字都用单引号试试看。
|
 |
4
lamCJ Jul 10, 2018 via iPhone
`value`
|
 |
5
wzaqqq OP 注释里面有特殊字符 feff 造成的，和 insert 无关
|
Select Language