MySQL uses scripts to create databases in bulk and import data

CREATE TABLE IF not EXISTS subscribers (
SubscriberId int not NULL primary key,
Rateplan varchar (6) Not NULL,
Monthlyfee Float not NULL,
Market varchar (TEN) is not NULL,
Channel varchar (6) Not NULL,
StartDate Date Default NULL,
Stopdate Date Default NULL,
Stoptype char (1),
Tenure int default NULL,
IsActive int Default NULL
);

LOAD DATA INFILE "C:\Users\ZHUGANGGGANG\Desktop\WileyCompanion\data\Subscribers.txt" IGNORE into TABLE subscribers IGNORE 1 ROWS;

Saved in the Xxx.sql file, executed using source xxx.sql on the MySQL command line.

MySQL uses scripts to create databases in bulk and import data