MySQL command-line operation

Use the show statement to find out what database currently exists on the server: show DATABASES;

Create a database abccs:create databases test12;

Select the database you created: Use test12

Creating a database table: CREATE table student ();

We want to establish a student information, the contents of the table contains students: Student number, name, training unit, enrollment date, professional, mentor.

Because column values such as name are variable, you choose varchar, whose length is not necessarily 20. You can choose any length from 1 to 255, and if you need to change its word size later, you can use the ALTER TABLE statement. The Entry date column uses the date data type.

Once we have created a table, we can look at the results we just made, and show tables which tables are in the database:

The structure of the display table: DESCRIBE mytable;

MySQL command-line operation