mysql数据库增删改查
mysql数据库增删改查
1.如何在数据库服务器中创建服务器
- create database 数据库名字;
2.如何在数据库中创建一个数据表
create table pet(
-> name varchar(20),
-> owner varchar(20),
-> species varchar(20),
-> sex char(1),
-> birth date,
-> death date);
3.查看数据表
- show tables;
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| pet |
+----------------+
1 row in set (0.03 sec)
4.查看数据表结构
- describe pet;
mysql> describe pet;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name | varchar(20) | YES | | NULL | |
| owner | varchar(20) | YES | | NULL | |
| species | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
| death | date | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
5.查看数据表中的记录
select * from pet;
6.向数据表里添加记录
insert into pet
-> values('Puffball','Diane','hamster','f','1999-03-10',NULL);
7.再一次查看数据表中的记录(手残,添加了两次)
select * from pet;
+----------+-------+---------+------+------------+-------+
| name | owner | species | sex | birth | death |
+----------+-------+---------+------+------------+-------+
| Puffball | Diane | hamster | f | 1999-03-10 | NULL |
| Puffball | Diane | hamster | f | 1999-03-10 | NULL |
+----------+-------+---------+------+------------+-------+
8.向数据表里删除记录
delete from pet where name='Puffball';
9.向数据表里修改记录
首先 看一下数据表的信息
select * from pet;
+--------+----------+---------+------+------------+------------+
| name | owner | species | sex | birth | death |
+--------+----------+---------+------+------------+------------+
| Douya | Feifei | jinmao | f | 2007-10-15 | NULL |
| Fluffy | Harold | cat | f | 1996-09-10 | NULL |
| claws | giv | cat | m | 1978-06-14 | NULL |
| nini | gary | dog | m | 1995-07-14 | 1999-04-08 |
| doubao | yangyang | dog | f | 2010-08-14 | NULL |
| BAOBAO | DQING | dog | m | 2014-04-28 | NULL |
+--------+----------+---------+------+------------+------------+
6 rows in set (0.00 sec)
接下来 update pet set name='NiNi' where owner='gary';
再来查看select * from pet;
+--------+----------+---------+------+------------+------------+
| name | owner | species | sex | birth | death |
+--------+----------+---------+------+------------+------------+
| Douya | Feifei | jinmao | f | 2007-10-15 | NULL |
| Fluffy | Harold | cat | f | 1996-09-10 | NULL |
| claws | giv | cat | m | 1978-06-14 | NULL |
| NiNi | gary | dog | m | 1995-07-14 | 1999-04-08 |
| doubao | yangyang | dog | f | 2010-08-14 | NULL |
| BAOBAO | DQING | dog | m | 2014-04-28 | NULL |
+--------+----------+---------+------+------------+------------+
总结自 [code158编程俱乐部]http://www.code158.com mysql编程系列教程