且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SQL语法错误1064

更新时间:2021-10-16 22:14:56

不要在列名前后使用单引号.单引号表示字符串,列名称不使用字符串.

Don't use single quotes around the column names. Single quotes means strings, you don't use strings for column names.

尝试将脚本更改为此:

USE books;

INSERT INTO book (isbn10, isbn13, title, edition, author_f_name,
    author_m_name, author_l_name, cond, price, genre)
VALUES ('0136061699', '978-0136061694',
    'Software Engineering: Theory and Practice','4th Edition',
    'Shari','Lawrence','Pfleeger','very good','50','Computing');