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 INTO room VALUES(DEFAULT,‘豪华间’,‘300’,‘好’,‘2’)
INSERT INTO room VA’ at line 2
INSERT INTO room VALUES(DEFAULT,'标准间','200','好','1')
INSERT INTO room VALUES(DEFAULT,'豪华间','300','好','2')
INSERT INTO room VALUES(DEFAULT,'总统套间','600','好','3')
报错:插入不进数据
原因:一次性执行多条语句没有加分号隔开
正确写法:
INSERT INTO room VALUES(DEFAULT,'标准间','200','好','1');
INSERT INTO room VALUES(DEFAULT,'豪华间','300','好','2');
INSERT INTO room VALUES(DEFAULT,'总统套间','600','好','3');