mysql常用命令二(创建，查询，修改，删除)

3、显示数据表的结构：
格式:describe/desc 表名;
mysql> desc time_zone_name;
+--------------+------------------+------+-----+---------+------+
| Field | Type | Null | Key | Default | Extra|
+--------------+------------------+------+-----+---------+------+
| Name | char(64) | NO | PRI | | |
| Time_zone_id | int(10) unsigned | NO | | | |
+--------------+------------------+------+-----+---------+------+
2 rows in set (0.01 sec)

4、建库：
格式:create database 库名;
mysql> create database testdb;
Query OK, 1 row affected (0.09 sec)

5、建表：
格式:use 库名;create table 表名 (字段设定列表);
mysql> use testdb;
Database changed
mysql> create table user
-> (
-> userid int not null,
-> username varchar(20) not null,
-> password varchar(50) not null,
-> email varchar(50),
-> primary key (userid)
-> );
Query OK, 0 rows affected (0.25 sec)

相关资讯