/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 vote112 views1 answer
Login phpmyadmin without password
SQL
22 votes232 views4 answers
Tsql rename table
SQL
53 votes314 views6 answers
How to install mysql ubuntu
SQL
0 vote124 views1 answer
Csv to sqlite python
SQL
0 vote133 views1 answer
Data types mysql vs postgresql
SQL
1 vote125 views1 answer
Sql update table remove spaces
SQL
0 vote149 views8 answers
Sql to c# linq converter online
SQL
0 vote126 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote137 views1 answer
Oracle query to find schema you are working on
SQL
11 votes163 views2 answers
Import sql file laravel cmd
SQL