mysql数据库创建表

jmton

　　1.创建一个名称为employee的mysql默认类型MyISAM表
　　create table employee (id smallint(5) not null,depno int(5) not null,name varchar(20) not null,cardnumber int(15) not null,primary key (id,depno));
　　插入一条记录
　　insert into employee values(1,805,'jim',2010090101);
　　2.创建和employee的表结构一样的一个表employee1
　　create table employee1 like employee
　　3.创建带有employee表数据的表employee2
　　create table employee2 select * from employee
　　4.在mysql数据库中建立一个employee表
　　create table mysql.employee like employee;
　　5.显示创建表employee的表结构
mysql> desc mysql.employee;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id         | smallint(5) | NO   | PRI | NULL    |       |
| depno      | int(5)      | NO   | PRI | NULL    |       |
| name       | varchar(20) | NO   |     | NULL    |       |
| cardnumber | int(15)     | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
　　mysql> drop table mysql.employee;
Query OK, 0 rows affected (0.00 sec)
　　6.在mysql数据库中创建一个带有数据的employee表
mysql> create table mysql.employee select  * from employee;
Query OK, 1 row affected (0.02 sec)
Records: 1  Duplicates: 0  Warnings: 0
　　mysql> select * from mysql.employee;
+----+-------+--------+------------+
| id | depno | name   | cardnumber |
+----+-------+--------+------------+
|  1 |   805 | liming | 2010090101 |
+----+-------+--------+------------+
1 row in set (0.00 sec)