1. Start MySql
/etc/init.d/mysql start
Run successfully:
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
2. Operation
mysql -u root -p
Start successful:
[ ok ] Starting mysql (via systemctl): mysql.service.
3. Create database firstDb
mysql->create database firstDb;
4. Display the created data table
mysql->show database;
Display:
+--------------------+ | Database | +--------------------+ | information_schema | | firstDatabase | | firstDb | | firstdb | | mysql | | performance_schema | | sys | +--------------------+ 7 rows in set (0.08 sec)
5. Use the created database, that is, the later operations are based on this database
mysql->use firstDb
6. Create a table and add content. Pay attention to the use of brackets. You can input one line at a time, with a clear structure. Finally, enter the semicolon ";" press enter to complete the creation of the class table. The MySql keyword is not case sensitive.
create table class( -> teacher_num INT, -> teacher_name VARCHAR(8), -> student_num INT, -> student_name VARCHAR(20), -> GoodStudent TINYINT);
7. Use show tables to list all the tables in the database
mysql->show tables;+-------------------+ | Tables_in_firstDb | +-------------------+ | class | +-------------------+ class is the previously created table.
8. Checklist structure
mysql> describe class;
9. Add data to the table
(1)You do not need to enter in order: mysql> insert into class(teacher_num,teacher_name,student_num,student_name,GoodStudent)VALUES(1,'Peter',20,'finee',14); (2)It needs to be input in sequence, that is VALUES The following values are in the same order as the fields in the table: mysql> insert into class VALUES(1,'Peter',20,'finee',14); (3)Enter multiple sets of data: mysql> insert into class VALUES(1,'Peter1',20,'finee1',14)， VALUES(1,'Peter2',20,'finee2',14)， VALUES(1,'Peter3',20,'finee3',14);