Open MySQL 5.7 Command line Client in CMD.
1.cmd Display Enter password Enter your password when you log in to the database. Then here are some important instructions for creating databases and tables.
(1). Create DATABASE: creat table database name;
(2). Show the database you created (you have chosen the database you want to use): show databases;
(3). Delete database (use this directive with caution): Drop database name;
(4). Create Empty table: Create TABLE table name (
->id Int (3),
->name varchar (8),
->pasword varchar);(There will be no output and save as long as you do not end with a semicolon)
(5). The contents of the Display table: show tables;
(6). Rename table name: ALTER TABLE name rename to new table name;
(8). Add Field: ALTER TABLE name add email varchar (255) not NULL;
(9). Modify field Name: Alter TABLE field name change new field name;
(10). Delete field: ALTER TABLE name drop field name;
(11). Delete Table name: drop table name;
CMD build a database to build a table of some instructions.