MySQL创建数据库表

mysql> create table articles (ID int primary key auto_increment,title varchar(255),abstract text, content text,pubDate datetime ,status int);

Query OK, 0 rows affected

mysql> show tables;
+---------------+
| Tables_in_app |
+---------------+
| articles      |
| user          |
+---------------+
2 rows in set

mysql> describe ariticles
    -> ;
1146 - Table 'app.ariticles' doesn't exist
mysql> describe articles;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| ID       | int(11)      | NO   | PRI | NULL    | auto_increment |
| title    | varchar(255) | YES  |     | NULL    |                |
| abstract | text         | YES  |     | NULL    |                |
| content  | text         | YES  |     | NULL    |                |
| pubDate  | datetime     | YES  |     | NULL    |                |
| status   | int(11)      | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+
6 rows in set

mysql>