an error in your SQL syntax

Question

MariaDB [stuInfo]> create table stuInfo(id int(4) primary key auto_increment,major varchar(10),
    ->              name  varchar(5),upimage  varchar(20),pid(18),phone int(11),
    ->              email varchar(25),fname  varchar(5),fphone int(11),
    ->              mname  varchar(5),mphone   int(11),nonename   varchar(5),nonephone  int(11));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(18),phone int(11),
             email varchar(25),fname  varchar(5),fphone int(' at line 2

请问，哪里有错呢？

Answer 1

发傻了。
检查出来了。

create table stuInfo(id int(4) primary key auto_increment,
                     major varchar(10),
                     name  varchar(5),
                     upimage  varchar(20),
                     pid      int(18),
                     phone int(11),
                     email varchar(25),
                     fname  varchar(5),
                     fphone int(11),
                     mname  varchar(5),
                     mphone   int(11),
                     nonename   varchar(5),
                     nonephone  int(11));