/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

4 votes228 views1 answer
Mysql biginteger size
SQL
1 vote243 views1 answer
Sql server insert into temp table
SQL
-1 vote216 views2 answers
Sql query examples
SQL
0 vote257 views1 answer
Hour differeence in mysql
SQL
1 vote245 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote222 views1 answer
Copied text from internet not inserting in mysql
SQL
1 vote238 views1 answer
Mysql batch insert
SQL
1 vote226 views1 answer
Postgres regex remove special characters
SQL
0 vote234 views1 answer
Postgresql delete multiple rows
SQL
0 vote235 views1 answer
Oracle merge insert if not exists
SQL