Mysql 简单控制台语句.doc

Mysql 简单的控制台语句 使用SHOW语句找出在服务器上当前存在什么数据库 mysql show databases; +--------------------+ | Database | +--------------------+ | information_schema | | edu | | mysql | | performance_schema | | sakila | | test | | webclass | | world | +--------------------+ 8 rows in set (0.00 sec) 选择你所创建的数据库 mysql use webclass; Database changed 查看现在的数据库中存在什么表 mysql show tables; +--------------------+ | Tables_in_webclass | +--------------------+ | stu | +--------------------+ 1 row in set (0.00 sec) 显示表的结构 mysql desc stu; +-------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+----------------+ | id | int(10) | NO | PRI | NULL | auto_increment | | sname | char(30) | NO | | NULL | | | sex | tinyint(1) | YES | | 0 | | | qq | varchar(255) | YES | | NULL | | +-------+--------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec)向表中添加一列 mysql alter table stu - add birthday date; Query OK, 0 rows affected (0.11 sec) Records: 0 Duplicates: 0 Warnings: 0 表中加入记录mysql insert into stu(sname,sex,qq,birthday) - values(张三,1,1126490093,1999-1-1); Query OK, 1 row affected (0.00 sec) mysql insert into stu(sname,sex,qq,birthday) - values(李四,0,1144490093,1958-8-1); Query OK, 1 row affected (0.00 sec) mysql insert into stu(sname,sex,qq,birthday) - values(王五,0,2225552093,1989-8-1); Query OK, 1 row affected (0.00 sec) mysql insert into stu(sname,sex,qq,birthday) - values(赵六,1,5555552093,1549-8-1); Query OK, 1 row affected (0.00 sec) mysql select * from stu; +----+-------+------+------------+------------+ | id | sname | sex | qq | birthday | +----+-------+------+------------+------------+ | 1 | 张三 | 1 | 1126490093 | 1999-01-01 | | 2 | 李四