/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 vote206 views2 answers
Mysql switch case
SQL
0 vote213 views1 answer
Mysql drop trigger
SQL
0 vote230 views1 answer
Add column not null with default value postgres
SQL
1 vote216 views4 answers
Get week day from date in sql
SQL
0 vote267 views1 answer
Replace null value within column mysql
SQL
0 vote193 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
5 votes205 views2 answers
Oracle find all tables with column name
SQL
0 vote184 views1 answer
Sql right characters
SQL
0 vote202 views1 answer
Mysql multiple primary keys
SQL
3 votes235 views1 answer
Ms sql skip take
SQL