/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

2 votes122 views1 answer
Sql count having
SQL
0 vote120 views1 answer
Providername system.data. mysql
SQL
0 vote120 views1 answer
Get relation data in mysql using query to excel
SQL
-1 vote105 views2 answers
Get day in sql
SQL
0 vote103 views1 answer
Postgresql alter column nullable
SQL
2 votes120 views1 answer
How to show the whole table in sql
SQL
1 vote108 views1 answer
Database Queries
SQL
5 votes100 views1 answer
Mysql get last day of month
SQL
6 votes109 views2 answers
If not exists insert sql
SQL
3 votes101 views3 answers
Print in pl sql
SQL