/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 vote262 views1 answer
Sql server select value large text
SQL
4 votes246 views1 answer
Check database name postgresql
SQL
1 vote262 views1 answer
Mysql current time
SQL
1 vote271 views1 answer
Oracle truncate partition
SQL
0 vote254 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote252 views1 answer
Get records in sql according to month name and count
SQL
0 vote257 views1 answer
Sql server bool select
SQL
0 vote205 views1 answer
Check if due date is less than todays date sql
SQL
2 votes258 views2 answers
Sql query to list all tables in a database sql server
SQL
-1 vote263 views1 answer
Concat two columns in sql server
SQL