/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 vote233 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote199 views1 answer
Postgresql where clause not working
SQL
0 vote225 views1 answer
Mysql range of dates overlap
SQL
-1 vote176 views1 answer
Mysql if example
SQL
0 vote236 views1 answer
Oracle cpu metric
SQL
8 votes198 views3 answers
Alter table auto_increment
SQL
0 vote217 views1 answer
Query to remove duplicate rows from a table
SQL
-2 votes205 views1 answer
Use of where in left join in mysql
SQL
62 votes507 views8 answers
Mysql add column
SQL
0 vote224 views1 answer
Sql log file inof
SQL