/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 vote175 views1 answer
Check if mysql db is used
SQL
0 vote150 views1 answer
Sql pad left 0
SQL
0 vote157 views1 answer
Can we rollback data that are deleted using DELETE
SQL
24 votes151 views6 answers
Sql change table name
SQL
0 vote179 views2 answers
Mysql show foreign keys
SQL
0 vote151 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
1 vote140 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote138 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote149 views1 answer
Postgres drop type
SQL
3 votes150 views1 answer
How to check schema privileges in oracle
SQL