/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 vote117 views1 answer
How to change null display in psql
SQL
2 votes129 views2 answers
Create temporary table in mysql
SQL
2 votes147 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
5 votes127 views3 answers
Mysql update field from one table to another
SQL
3 votes123 views3 answers
Create a view postgres
SQL
0 vote129 views1 answer
Mysql count with two joins
SQL
1 vote121 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
2 votes132 views2 answers
Sql lag
SQL
8 votes121 views2 answers
Select table column name in sql
SQL
5 votes118 views2 answers
Postgres update with if condition query
SQL