/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 vote254 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote240 views1 answer
Sql server information_schema temp tables
SQL
0 vote238 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote198 views1 answer
Mysql find non alphanumeric characters
SQL
1 vote280 views1 answer
Find size of all DB's postgres
SQL
0 vote208 views1 answer
How to select a row in sql
SQL
1 vote202 views6 answers
In sql
SQL
0 vote254 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote192 views1 answer
Opensuse stop MySQL
SQL
0 vote191 views1 answer
Postgresql newline character
SQL