如何在 Mysql 中创建表

Question

我已经安装了 Mysql 程序和 Phpmyadmin 程序，并尝试创建一个包含表的数据库。这是我写的内容以及得到的结果

mysql> create table aziende(
-> ragione varchar (32) not null
-> email varchar (32) not null
-> telefono int (10) unsigned nut null
-> ); 

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 'email varchar (32) not null
telefono int (10) unsigned nut null
)' at line 3

Answer 1

您的语法不正确，而且您nut在某一处拼写不正确。

CREATE TABLE aziende(
   ragione VARCHAR(32) NOT NULL,
   email VARCHAR(32) NOT NULL,
   telefono INT(10) UNSIGNED NOT NULL,
);