command line for load the data file of 100 table's data at one time.

Question

yeah,
think you have a database and you want to insert 100 tables and tables' data through coding . but here it will take lot of time to insert data copy and past. but i do not want that mechanism, i really need a answer to load data file which consists creation table and data values for that . just write coding for load data file to mysql .

Answer 1

You can import data from a CSV file into MySQL and the syntax is

LOAD DATA INFILE 'abc.csv' INTO TABLE abc

Answer 2

Hope this helps you.