安装完成mysql数据库后,可以通过如下命令查看数据库列表;
//查询数据库的命令:
SHOW DATABASES;
查询数据库中的数据表;
//查询数据库中的数据表;
mysql> USE mysql;
Database changed
mysql> SHOW TABLES;
数据库的创建和删除;
//数据库的创建和删除;
mysql> CREATE DATABASE beyond;
Query OK, 1 row affected (0.00 sec)
mysql> SHOW DATABASES;
删除数据库;
mysql> DROP DATABASE taotao;
Query OK, 0 rows affected (0.00 sec)
mysql> DROP TABLE user;//删除表
Query OK, 0 rows affected (0.00 sec)
创建和删除数据表;
mysql> CREATE TABLE songs (songs_name CHAR(30) NOT NULL, songs_passwd CHAR(20) NOT NULL DEFAULT '123.com',PRIMARY KEY (songs_name));
Query OK, 0 rows affected (0.02 sec)
相关数据记录操作;
//插入新的数据记录;
mysql> INSERT INTO auth.users(user_name,user_passwd) VALUES('huangjiajv',ENCRYPT('123456'));
Query OK, 1 row affected (0.01 sec)
mysql> INSERT INTO auth.users(user_name,user_passwd) VALUES('huangguanzhong',ENCRYPT('com.123'));
Query OK, 1 row affected (0.00 sec)
//修改数据表信息;
mysql> UPDATE auth.users SET user_passwd=ENCRYPT('123.com') WHERE user_name='taotao';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
数据库的备份和恢复;
//数据库的备份和恢复;
mysqldump -u root -p auth > mysql-auth.sql
Enter password:
ll mysql-auth.sql
-rw-r--r-- 1 root root 1863 Dec 30 01:01 mysql-auth.sql //备份数据库;
删除数据库auth;
mysql> USE mysql;
Database changed
mysql> DROP DATABASE auth;
Query OK, 1 row affected (0.01 sec)
备份某个数据库中的某个表;
mysqldump -u root -p mysql host user > mysql.host-user.sql