MySQL数据库简单操作(二)
password:
mysql> select database();
+------------+
| database() |
+------------+
| cnfo |
+------------+
1 row in set (0.01 sec)
--在当前库创建表
mysql> create table tb_tmp(name varchar(20),
-> sex char(1),birth date);
Query OK, 0 rows affected (0.09 sec)
--显示当前库所有的表
mysql> show tables;
+----------------+
| Tables_in_cnfo |
+----------------+
| tb_tmp |
+----------------+
1 row in set (0.00 sec)
--查看表的定义信息
mysql> desc tb_tmp
-> ;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.02 sec)
-- Author : Leshami
-- Blog : http://blog.csdn.net/leshami
--为表插入记录
mysql>
insert into tb_tmp values('Jcack','F','20140428');
Query OK, 1 row affected (0.08 sec)
mysql> insert into tb_tmp values('John','M','20130428');
Query OK, 1 row affected (0.02 sec)
--查看表上的记录
mysql> select * from tb_tmp;
+-------+------+------------+
| name | sex | birth |
+-------+------+------------+
| Jcack | F | 2014-04-28 |
| John | M | 2013-04-28 |
+-------+------+------------+
2 rows in set (0.00 sec)
--更新表上的记录
mysql> update tb_tmp set name='Jack' where name='Jcack';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
--过滤查询
mysql> select * from tb_tmp where sex='F';
+------+------+------------+
| name | sex | birth |
+------+------+------------+
| Jack | F | 2014-04-28 |
+------+------+------------+
1 row in set (0.00 sec)