Yum installs mysql and some basic operations

Yum install mariadb-server mariadb- ysystemctl start mariadb enable service mysql_secure_installation security settings password y-password-y-n-y-ymysql-uroot-p12 password note-u user-p the password just set show databases; view the database use database name; use the database select database (); view the current database create database database name charset=utf8 Create database drop database database name; delete database show tables; to view all table desc table names in the current database; view table structure to create table create table user_info (× × × int (18), name varchar (20), gender varchar (20), user ID number int (20), tariff int (48); desc user_info View the user_ info table +-+-+ | Field | Type | Null | Key | Default | Extra | +- +-+ | × × | int (18) | YES | | NULL | | name | varchar (20) | YES | | NULL | | gender | varchar (20) | YES | | NULL | | user ID number | int (20) | YES | | NULL | | | tariff | int (48) | YES | | NULL | | +-+-+ add content insert into user_info values ('000000001') to the user_info table | 'Sun Kongwu', 'male', '011', '011') Insert into user_info values ('000000002', 'Lanling', 'female', '012'); insert into user_info values ('Jiang Wen', 'female', '013'); insert into user_info values ('000000004', 'Guanyuan', 'male', '014'); insert into user_info values ('000000005', 'Luo Zhongkun', 'male', '015Zhong Ji 39'); select * from user_info View all the content added in the user_info table +-+ | × × | name | gender | user ID number | tariff | +-+- -+ | 1 | Sun Kongwu | male | 11 | 100 | 2 | Lanling | female | 12 | 98 | | 3 | Jiang Wen | female | 13 | 12 | | 4 | Guanyuan | male | 14 | 38 | | 5 | Luo Zhongkun | male | 15 | 39 | +-+