/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 vote146 views1 answer
Change redo log file size in mysql 5.6
SQL
3 votes134 views1 answer
Mysql set field unique
SQL
-1 vote136 views3 answers
Update mongodb version ubuntu
SQL
0 vote89 views1 answer
Check id exist or not in sql
SQL
0 vote147 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote138 views1 answer
Sql decode
SQL
0 vote133 views1 answer
Hibernate show sql xml property
SQL
4 votes123 views1 answer
Oracle table statistics last analyzed
SQL
0 vote138 views1 answer
Add super privilege mysql
SQL
2 votes155 views1 answer
Cannot return non-composite value from function that returns composite type
SQL