/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

13 votes260 views4 answers
Mysql remove foreign key constraint
SQL
1 vote184 views1 answer
Convert rows to string sql server
SQL
0 vote267 views1 answer
Postgresql powershell query
SQL
5 votes145 views1 answer
Copy table from one database to another mysql
SQL
6 votes2.2K views1 answer
Sql select second max
SQL
11 votes188 views1 answer
Mysql text type max length
SQL
0 vote184 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote183 views1 answer
Starting mysql shell lampp ubuntu
SQL
4 votes194 views2 answers
Oracle sql group by date year
SQL
11 votes189 views2 answers
Having in sql
SQL