1.如何扽两个数据库服务器?
mysql -uroot -p数据库密码
2.如何查询数据库服务器中所有的数据库?
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test_01 |
+--------------------+
4 rows in set (0.01 sec)
3.如何选中某一个数据库进行操作
mysql> use mysql;
4.退出数据库
mysql> exit
Bye
+--------------------+--------------------++--------------------++--------------------++--------------------++--------------------++--------------------++--------------------++--------------------++、
创建数据库
create database 数据库名;
查询数据库表
show tables;
创建数据表
create table 数据表(
name varchar(20){数据类型}
ownaer varchar(20){数据类型}
species varchar(20){数据类型}
sex char(1){字符串类型}
birth date{日期类型}
death date{日期类型} );
查询数据库表
show tables;
查看数据表的结构
mysql> describe test; (简写 desc 数据表)
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name | varchar(20) | YES | | NULL | |
| ownaer | varchar(20) | YES | | NULL | |
| species | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
| death | date | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
如何查看数据表中的记录
mysql> select * from test;
Empty set (0.00 sec)
数据表中添加数据记录
mysql> INSERT INTO test
-> values(‘puffball‘,‘diane‘,‘namster‘,‘f‘,‘1999-09-09‘,null);
Query OK, 1 row affected (0.00 sec)
再一次查询
mysql> select * from test;
+----------+--------+---------+------+------------+-------+
| name | ownaer | species | sex | birth | death |
+----------+--------+---------+------+------------+-------+
| puffball | diane | namster | f | 1999-09-09 | NULL |
+----------+--------+---------+------+------------+-------+
原文:https://www.cnblogs.com/kai0438/p/12146140.html