Mysql基本操作
1、数据库基本操作
mysql> show databases; #登陆情况下查询
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.08 sec
mysql> show databases\G;
*************************** 1. row ***************************
Database: information_schema
*************************** 2. row ***************************
Database: mysql
*************************** 3. row ***************************
Database: performance_schema
*************************** 4. row ***************************
Database: test
4 rows in set (0.00 sec)
[root@server ~]# mysql -uroot -p[密码] -h IP -e "show databases"
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
information_schema:中保存了MySQL服务器所有数据库的信息。如数据库名,数据库表,表栏的数据类型与访问权限等。
mysql库:里面存有账户信息,权限信息等。
mysql> CREATE DATABASE student;
Query OK, 1 row affected (0.00 sec)
mysql> show CREATE DATABASE student;
+----------+--------------------------------------------------------------------+
| Database | Create Database |
+----------+--------------------------------------------------------------------+
| student | CREATE DATABASE `student` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+----------+--------------------------------------------------------------------+
1 row in set (0.00 sec)
[root@server ~]# ll -d /var/lib/mysql/student #再/var/lib/mysql下会生成同名目录
drwx------ 2 mysql mysql 19 7月 26 16:06 /var/lib/mysql/student
[root@ser