/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 votes101 views3 answers
How to get last row of table in sql
SQL
14 votes105 views5 answers
Sql oracle limit
SQL
0 vote106 views1 answer
Connect postgresql using a connection string
SQL
1 vote99 views1 answer
Mysql batch insert
SQL
4 votes108 views1 answer
Postgresql create table with index
SQL
0 vote98 views1 answer
Select from column mysql
SQL
1 vote110 views1 answer
Sql server epoch to datetime
SQL
0 vote122 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote123 views1 answer
Ubuntu connect to mssql database
SQL
5 votes102 views1 answer
Oracle scan source ddl
SQL