如何解决用mysql创建表时的错误?

mqxuamgl  于 2021-07-24  发布在  Java
关注(0)|答案(5)|浏览(369)

你好,我是mysql的新手,我正在读ryan mitchell的书web scraping with python,我不明白为什么这个图表会出错

use book_test;
set names utf8;
set character_set_client = utf8mb4;
create table pages(id bigint(7) not null auto_increment,
title varchar(200),
content varchar(10000),
created timestamp default current_timestamp,
primary key(id));

在这之前一切都很好

describe pages;
+-------+------------+-----------+-----------------+--------+-----------------+
|field  |type         |null      |key               |default|    extra        |
+-------+------------+------------+-----------------+-------+-----------------+
|id     |bigint(7)    |no         |pri              |null   |auto_increment   |
|title  |varchar(200) |yes        |                 |null   |                 |
|content|varchar(1000)|yes        |                 |null   |                 | 
|created|timestamp    |no         |                 |       |current_timestamp|
+-------+-------------+-----------+------------------+----+-------------------+
4 rows in set(0.01sec)
insert into pages(title,content)values("test page title","this is some test content.");

我一直在图表上出错,我不知道为什么。请帮助!!!!
错误代码:1064。sql语法有错误;检查与您的mysql服务器版本对应的手册,以获取在第1行的'+

相关问题