import data in mysql without using any other software

Solutions on MaxInterview for import data in mysql without using any other software by the best coders in the world

Search
showing results for - "import data in mysql without using any other software"
Brogan
13 May 2020
1Convert file in .csv
2CREATE TABLE (name of the table you insert data in)(
3columns
4);
5
6LOAD DATA INFILE "path\\name.csv" INTO TABLE (name of the table you insert data in)
7FIELDS TERMINATED BY "fields terminated by"
8LINES TERMINATED BY "lines terminated by"
9IGNORE (how many lines to ignore) LINES
10(columns)
source
similar questions
sql query to import data from excel to mysqlhow to import database in mysql by cmdimport dump mysqlimport database mysql command linemysql export and importimport in mysql without a softwareimport local sql into remote mysqlimport sql file mysql commadn linedatagrip import sql fileimport db through mysql consoleimport mysql dbimport file mysql terminalcommand line mysql importimport mysql command line without databaseimport big data to mysqlhow to export only procedures mysqlmysql import command windowsmysql import from sql fileimport all databases mysqlmysql import sql fileimport mysql 27mysql load sql from file
queries leading to this page
mysql import without dataimport data in mysql without using any softwarehow to import data in mysql without using any softwareimport data in mysql without softwareimport data in mysql without using any other softwareimport data in mysql without using any other software