/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 vote196 views1 answer
Postgresql import a database of gzip
SQL
0 vote200 views1 answer
Mysql get only the field names in a table
SQL
17 votes212 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote197 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote190 views1 answer
Postgresql using reserved word as column name
SQL
0 vote189 views1 answer
Mysqldump don't drop table
SQL
6 votes250 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
3 votes299 views1 answer
Sql add two values together
SQL
2 votes187 views1 answer
Postgresql drop primary key constraint
SQL
1 vote194 views2 answers
Sql where is not number
SQL