/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 vote265 views1 answer
Oracle list user locked
SQL
3 votes295 views1 answer
Start mysql server linux terminal
SQL
11 votes260 views3 answers
Sqlite3 create table from another table
SQL
0 vote301 views1 answer
Array aggre distinct postgres
SQL
6 votes286 views2 answers
Mysql concatenate two columns into one
SQL
1 vote259 views1 answer
Mariadb alter user host
SQL
18 votes252 views3 answers
Mysql add column with default value
SQL
0 vote293 views1 answer
Mysql 3 months ago
SQL
11 votes272 views1 answer
Oracle view ddl
SQL
0 vote265 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL