1. How to connect to MySQL
Use the command line.
My MySQL is installed in C:/MySQL
Enter: DOS environment.
C:/MySQL/bin> mysql-uroot-p-hlocalhost
Enter Password :******
If the connection is successful, you will see: Welcome to the MySQL monitor.
Common MySQL commands:
Create instance: Create Database test1; (create a folder named test1 under C:/MySQL/data)
View all instances: Show databases;
Use test1;
You can create tables, permission management, and other commands by referring to standard SQL.
2. How to import data tables
2.1 First prepare the DDL for creating the table. My DDL is script_mysql. SQL
2.2 import DDL.
C:/mysql> mysql-uroot-p-hlocalhost -- default-character-set = sjis database instance name <DDL file storage path (absolute path)/script_mysql. SQL
3. How to import data
3.1 first, prepare the data DDL. My DDL is masterdata. SQL.
3.3 import DDL
C:/mysql> mysql-uroot-p-hlocalhost -- default-character-set = sjis database instance name <DDL file storage path (absolute path)/script_mysql. SQL
(You can copy multiple DDL statements at a time to improve productivity)