你好,我是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行的'+
5条答案
按热度按时间i86rm4rw1#
--+
628mspwn2#
--+
e3bfsja23#
--+
5cg8jx4n4#
--+
xytpbqjk5#
--+'附近使用的正确语法