1)在数据库中创建一个数据表 样例: CREATE TABLE IF NOT EXISTS table_name ( field1 datatype, field2 datatype, field3 datatype )[CHARACTER SET 字符集 COLLATE 校对规则];
2)选择相应的数据库 eg: use databases_name; 3)查看当前数据库 SELECT DATABASE(); 4)创建表 mysql> CREATE TABLE IF NOT EXISTS user( -> id int, -> name varchar(20), -> password varchar(20), -> birthday date -> ); Query OK, 0 rows affected (0.01 sec) mysql> mysql> mysql> SHOW TABLES; +-----------------+ | Tables_in_mydb1 | +-----------------+ | user | +-----------------+ 1 row in set (0.00 sec) 5)查看数据库中的表 SHOW TABLES;
mysql> CREATE TABLE IF NOT EXISTS employee( -> id int, -> name varchar(20), -> gender varchar(20), -> birthday date, -> entry_date date, -> job varchar(20), -> salary float(8,2), -> resume text -> ); Query OK, 0 rows affected (0.02 sec) 6)查看数据库中已经创建好的表 mysql> SHOW TABLES; +-----------------+ | Tables_in_mydb1 | +-----------------+ | employee | | user | +-----------------+ 2 rows in set (0.00 sec) 7)查看新建表中的字段内容 mysql> SHOW CREATE TABLE USER; +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | USER | CREATE TABLE `user` ( `id` int(11) DEFAULT NULL, `name` varchar(20) DEFAULT NULL, `password` varchar(20) DEFAULT NULL, `birthday` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) |
|
来自: BIGDATA云 > 《MySQL关系型事务型》