526互联

DBeaver中使用MySQL在建表时使用DROP TABLE IF EXISTS `tbl_book`;报错

发布时间 2023-09-22 20:38:07作者: Jnkdog
点击查看代码 
DROP TABLE IF EXISTS `tbl_book`;
CREATE TABLE `tbl_book` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

报错：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 'CREATE TABLE tbl_book ( id int(11) NOT NULL AUTO_INCREMENT, type var' at line 2 Error position: line: 1
解决方法：删除DROP TABLE IF EXISTS tbl_book;