mysql数据库创建表

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)