/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 vote187 views1 answer
How to reset the database value in SQL server
SQL
0 vote183 views2 answers
Sql server Insert Into table
SQL
1 vote202 views1 answer
Sql headers delphi
SQL
2 votes175 views1 answer
When matched in sql server
SQL
0 vote187 views1 answer
Mysql milliseconds
SQL
0 vote248 views1 answer
Fetching data from mysqldb
SQL
8 votes187 views1 answer
Sql remove leading spaces
SQL
13 votes209 views3 answers
List all the tables in sql
SQL
0 vote198 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
7 votes211 views1 answer
Sql pagination oracle
SQL