/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

0 vote297 views2 answers
List all constraints in postgres
SQL
2 votes278 views1 answer
Mysql virtual column
SQL
3 votes282 views1 answer
Export postgres database linux
SQL
0 vote316 views1 answer
Get total and distict row diff in sql
SQL
6 votes320 views3 answers
Psql show columns of table
SQL
0 vote325 views1 answer
Select new table sql
SQL
24 votes285 views6 answers
Rename a column in sql server
SQL
3 votes310 views1 answer
Where id is in list sql
SQL
0 vote269 views1 answer
How to check default value of column in sql server
SQL
15 votes276 views2 answers
Select Options
SQL