/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 vote302 views1 answer
Open postgresql.conf in centos
SQL
0 vote299 views2 answers
Android sqlite query join
SQL
0 vote311 views1 answer
Mysql query with sql to get the next row
SQL
1 vote307 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote283 views1 answer
Trigger in postgresql to change incoming entry
SQL
4 votes437 views6 answers
Laravel jwt
SQL
1 vote286 views1 answer
Loading local data is disabled mysql
SQL
0 vote295 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
2 votes294 views1 answer
Get first n letter of department name in sql
SQL
4 votes322 views1 answer
Sql select limit range
SQL