› 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
wzaqqq
V2EX  ›  MySQL

insert 遇到关键词字段

  •  
  •   wzaqqq · Jul 9, 2018 · 4265 views
    This topic created in 3049 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 试了加单引号双引号都不行。

    5 replies  •  2018-08-12 12:20:59 +08:00
    BBCCBB
    BBCCBB
    Jul 9, 2018
    1
    `` , 1 左边那个按键, 不是单引号 /双引号
    nu11001
    nu11001
    Jul 9, 2018
    2
    明显不是 value 的问题
    saulshao
    saulshao
    Jul 10, 2018
    3
    所有的字段名字都用单引号试试看。
    lamCJ
    lamCJ
    Jul 10, 2018 via iPhone
    4
    `value`
    wzaqqq
    wzaqqq
    OP
    Aug 12, 2018
    5
    注释里面有特殊字符 feff 造成的,和 insert 无关
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2130 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 35ms · UTC 12:41 · PVG 20:41 · LAX 04:41 · JFK 07:41
    ♥ Do have faith in what you're doing.