今天的学习内容主要是mariadb数据库,以及数据库、表单的理解
应用程序:mariadb mariadb-server
初始化数据库:mysql_secure_installation
创建数据库:create database haixin;
使用数据库:use haixin;
查看数据库:show database;
查看表单:show table;
查看内容:describe mybook;或者select * from mybook;
判断条件命令:where
查看数据库中表单的内容,使用where判断命令:
MariaDB [linuxprobe]> SELECT * FROM mybook WHERE price>75; +-------------+-------+-------+ | name | price | pages | +-------------+-------+-------+ | linuxprobe3 | 80 | 518 | | linuxprobe4 | 100 | 518 | +-------------+-------+-------+ 2 rows in set (0.06 sec) MariaDB [linuxprobe]> SELECT * FROM mybook WHERE price!=80; +-------------+-------+-------+ | name | price | pages | +-------------+-------+-------+ | linuxprobe1 | 30 | 518 | | linuxprobe2 | 50 | 518 | | linuxprobe4 | 100 | 518 | +-------------+-------+-------+ 3 rows in set (0.01 sec) MariaDB [mysql]> exit Bye
数据库的备份:mysqldump -u root -p haixin > /root/haixin.dump
数据库的删除:drop haixin;
数据库的恢复:mysql -u root -p haixin < /root/haixin.dump