/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 vote340 views1 answer
Mysql update table from select on another table
SQL
15 votes387 views3 answers
Mysql update add to existing value
SQL
3 votes334 views2 answers
WhereIn SQL
SQL
0 vote402 views1 answer
Pagination with row_number
SQL
0 vote340 views1 answer
Sql select max value for each group
SQL
3 votes345 views2 answers
Current year sql
SQL
-1 vote395 views1 answer
Get month and year from date in mysql sequelize
SQL
4 votes321 views1 answer
Mysql insert from local csv
SQL
2 votes319 views1 answer
Insert from table tsql
SQL
0 vote355 views1 answer
Psql show db
SQL