/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

5 votes144 views3 answers
String concatenation sql server
SQL
1 vote159 views1 answer
How do you use sql in you company
SQL
0 vote103 views1 answer
Sqlalchemy existing database
SQL
0 vote139 views1 answer
Mysql DDL
SQL
6 votes169 views1 answer
How to get the size of the database in postgresql
SQL
3 votes160 views1 answer
Define REGEXP?
SQL
0 vote133 views1 answer
Oracle select invalid views
SQL
0 vote131 views1 answer
Sql delete where x or y or z
SQL
1 vote152 views1 answer
Mysql limit results to 10
SQL
0 vote96 views1 answer
Mysql find foreign key references
SQL