介绍mysql基本的增删查改语句的实践，没有难度，孰能生巧。 首先我们随便创建一张库和表 mysql create database test1;mysql create table disc_info ( id int(5) not null auto_increment, disc_name varchar(20) not null, disc_desc varchar(255), primar
介绍mysql基本的增删查改语句的实践，没有难度，孰能生巧。
首先我们随便创建一张库和表
mysql> create database test1;mysql> create table disc_info ( id int(5) not null auto_increment, disc_name varchar(20) not null, disc_desc varchar(255), primary key (`id`) );query ok, 0 rows affected (0.04 sec)
看看表结构
mysql> desc disc_info;+-----------+--------------+------+-----+---------+----------------+| field | type | null | key | default | extra |+-----------+--------------+------+-----+---------+----------------+| id | int(5) | no | pri | null | auto_increment || disc_name | varchar(20) | no | | null | || disc_desc | varchar(255) | yes | | null | |+-----------+--------------+------+-----+---------+----------------+3 rows in set (0.00 sec)
新增数据mysql> insert into disc_info (`disc_name`,`disc_desc`) values ('codebabe','welcome to codebabes.com');query ok, 1 row affected (0.00 sec)
查看数据查看所有数据
mysql> select * from disc_info;+----+-----------+--------------------------+| id | disc_name | disc_desc |+----+-----------+--------------------------+| 1 | codebabe | welcome to codebabes.com |+----+-----------+--------------------------+1 row in set (0.00 sec)
查看指定数据列
mysql> select disc_name,disc_desc from disc_info;+-----------+--------------------------+| disc_name | disc_desc |+-----------+--------------------------+| codebabe | welcome to codebabes.com |+-----------+--------------------------+1 row in set (0.00 sec)
多表查询
mysql> select discinfo2.disc_name,discinfo.disc_name from discinfo,discinfo2;+-----------+-----------+| disc_name | disc_name |+-----------+-----------+| letong | codeman |+-----------+-----------+1 row in set (0.00 sec)
join查询
mysql> select * from discinfo join discinfo2 on discinfo.id=0;+----+-----------+--------------------------+----+-----------+----------------------+| id | disc_name | disc_desc | id | disc_name | disc_desc |+----+-----------+--------------------------+----+-----------+----------------------+| 0 | codebabe | welcome to codebabes.com | 1 | letong | welcome to letong.me |+----+-----------+--------------------------+----+-----------+----------------------+1 row in set (0.00 sec)
修改数据修改指定数据
mysql> update disc_info set disc_name='codeman' where id=1;query ok, 1 row affected (0.00 sec)rows matched: 1 changed: 1 warnings: 0
更改表名
mysql> alter table disc_info rename discinfo;query ok, 0 rows affected (0.01 sec)mysql> show tables;+------------------+| tables_in_kaoshi |+------------------+| discinfo |+------------------+1 row in set (0.00 sec)
修改表字段
mysql> alter table discinfo change id id int(6) not null;query ok, 1 row affected (0.01 sec)records: 1 duplicates: 0 warnings: 0mysql> desc discinfo;+-----------+--------------+------+-----+---------+-------+| field | type | null | key | default | extra |+-----------+--------------+------+-----+---------+-------+| id | int(6) | no | pri | null | || disc_name | varchar(20) | no | | null | || disc_desc | varchar(255) | yes | | null | |+-----------+--------------+------+-----+---------+-------+3 rows in set (0.00 sec)
删除数据mysql> delete from discinfo where disc_name='codeman';query ok, 1 row affected (0.00 sec)mysql> select * from discinfo;empty set (0.00 sec)
本文出自：http://letong.me, 原文地址：http://letong.me/mysql_basics.html, 感谢原作者分享。