mysql - 如何制作数据库表？

Question

我想做 JDBC 所以我试试

mysql> use video_db;
Database changed
mysql> create table videos(
    -> code varchar(10) not null,
    -> title varchar(30),
    -> ganre varchar(30),
    -> releaseDay varchar(10),
    -> isRental char(1),
    -> rentalPrice int(11),
    -> primarykey(code)
    -> );
ERROR 1064 (42000): 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 '(code)
)' at line 8

我该如何解决？请帮帮我

标签： mysqldatabase

Answer 1

您在“主要”和“关键”之间缺少一个空格：

mysql> create table videos(
    -> code varchar(10) not null,
    -> title varchar(30),
    -> ganre varchar(30),
    -> releaseDay varchar(10),
    -> isRental char(1),
    -> rentalPrice int(11),
    -> primary key(code) -- Here!
    -> );