MySQL console executes the. SQL script file

Write a. sql script file with notepad++:

1 Drop Database if exists library;2 Create DatabaseLibrarydefault character SetUTF8;3  UseLibrary;4 5 Create Table User(6Idint( One) not NULLAuto_increment,7Namevarchar(255)default NULL,8Passwordvarchar(255)default NULL,9     Primary Key(ID)Ten) engine=InnoDBdefaultCharSet=UTF8;

Save to the F drive in the SQL folder named Createtable.sql

Open the console that comes with MySQL, enter the password for the root account, and execute the command after the login is successful:

1 Source F:\Sql\createTable.sql //Note that absolute paths are used here, and at last no semicolon is added

, execution succeeds and can be viewed by executing the following command

1 Show tables;

MySQL console executes the. SQL script file