/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

1 vote199 views1 answer
Sql update table remove spaces
SQL
-1 vote237 views3 answers
MySQL shutdown unexpectedly
SQL
0 vote247 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
1 vote183 views1 answer
Foreign key in oracle sql developer
SQL
4 votes215 views3 answers
Rename table column postgresql
SQL
1 vote226 views1 answer
Sql view where tables have same column name combine results
SQL
4 votes214 views1 answer
Wildcard in sql
SQL
49 votes224 views6 answers
Get duplicate records in sql
SQL
1 vote212 views1 answer
Mysql pretty date format
SQL
0 vote236 views1 answer
Sql use with to get value counts and percentages
SQL