一、如何使用终端操作数据库?
1、如何登陆数据库服务器
mysql -u root -p 123456
2、如何查询数据库服务器中所有的数据库?
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_mo |
| mysql |
| performance_schema |
| plesson |
+--------------------+
5 rows in set (0.22 sec)
3、如何选中某一个数据库进行操作?
mysql> use db_mo
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
4、如何退出数据库?
mysql>exit
5、如何在数据库服务器中创建我们的数据库?
mysql>create database xxx;
6、如何查看某个数据库中所有的数据表?
mysql> show tables;
+------------------------------+
| Tables_in_plesson |
+------------------------------+
| auth_group |
| auth_group_permissions |
| auth_permission |
| common_user |
| common_user_groups |
| common_user_user_permissions |
| django_admin_log |
7、如何创建数据表?
mysql> CREATE TABLE pet (
-> name VARCHAR(20),
-> owner VAR
-> owner VARCHAR(20),
-> species VARCHAR(20),
-> sex CHAR(1),
-> birth DATE,
-> death DATE);
Query OK, 0 rows affected (0.34 sec)
8、查看某表的属性详情?
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 | |
+---------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
9、如何查看数据表中的记录?
mysql> SELECT * FROM pet;
Empty set (0.02 sec)
10、如何往数据包中添加数据记录呢?
mysql> insert into pet
-> values('Puffball','Diane','hamster','f','1996-03-23',NULL);
Query OK, 1 row affected (0.13 sec)
11、mysql常用的数据类型有哪些?
mysql支持多种类型,大致可以分为三类:数值,日期/时间和字符串(字符)类型
1、数值
2、日期/时间
3、字符串
总结:日期选择按照格式,数值和字符按照大小
12、如何删除数据?
mysql> DELETE from pet where name='aaaa';
Query OK, 1 row affected (0.10 sec)
13、如何修改数据?
mysql> update pet set name='wangcaiyyy' where owner ='zhoguxingchi';
Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0
总结一下:数据记录常见操作?
1、增加-----insert
2、删除-----delete
3、修改-----update
4、查询-----select