/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

11 votes181 views5 answers
Laravel db facade
SQL
1 vote167 views1 answer
Rails run native ssql query
SQL
31 votes233 views4 answers
Mysql grant execute
SQL
2 votes166 views1 answer
Sql as
SQL
2 votes193 views3 answers
Postgres json to string
SQL
0 vote179 views1 answer
Sql comand for removing data from table
SQL
0 vote180 views2 answers
Greater than sql server
SQL
8 votes124 views2 answers
Alter column name in mssql
SQL
0 vote161 views2 answers
Imageview setimageresource null
SQL
0 vote166 views1 answer
Exclude last comma separated string mysql
SQL