/SQL/Import Data in MySQL without using any other software

Import Data in MySQL without using any other software

Convert file in .csv
CREATE TABLE (name of the table you insert data in)(
columns
);

LOAD DATA INFILE "path\\name.csv" INTO TABLE (name of the table you insert data in)
FIELDS TERMINATED BY "fields terminated by"
LINES TERMINATED BY "lines terminated by"
IGNORE (how many lines to ignore) LINES
(columns)

Source: youtube.com

Similar codes

6 votes149 views4 answers
Sqlite drop table
SQL
1 vote161 views1 answer
Psql lst trigger
SQL
5 votes166 views2 answers
Sql constraint check value in list
SQL
3 votes159 views2 answers
Sql get month name
SQL
9 votes161 views2 answers
Sql server check table exists
SQL
0 vote160 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote151 views2 answers
Functions with parameters SQL
SQL
2 votes158 views1 answer
Get hour from date sql
SQL
6 votes148 views1 answer
Oracle trigger after logon on database
SQL
1 vote483 views1 answer
Mysql event last execution
SQL