search

Home  >  Q&A  >  body text

php - Entering SQL statements to create a table prompts the error Unknown column

The mysql software used: Navicat

The complete sql statement is as follows:

INSERT INTO `xz_user` ( `id`, `username`, `age`, `address`, `sex`) VALUES (00000000001, '张三', 20, 'shanghai', '男');
INSERT INTO `xz_user` ( `id`, `username`, `age`, `address`, `sex`) VALUES (00000000002, '李四', 18, 'beijing', '女');
INSERT INTO `xz_user` ( `id`, `username`, `age`, `address`, `sex`) VALUES (00000000003, '王二', 24, 'shenzhen', '男');
巴扎黑巴扎黑2720 days ago884

reply all(2)I'll reply

  • 仅有的幸福

    仅有的幸福2017-06-19 09:09:07

    Try
    DESCRIBE xz_user to see if there is this class column.

    reply
    0
  • 巴扎黑

    巴扎黑2017-06-19 09:09:07

    Unknown fieldclassThe prompt is very obvious

    reply
    0
  • Cancelreply