/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 vote302 views1 answer
How to create notes in mysql
SQL
0 vote264 views1 answer
Get who is hired in january in sql
SQL
0 vote284 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
1 vote263 views1 answer
Psql connect to another database
SQL
0 vote286 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote296 views1 answer
Rows, INSERT INTO, Returning
SQL
1 vote268 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote245 views1 answer
Postgres create database if not exists
SQL
25 votes268 views1 answer
Mysql grant all privileges to a user
SQL
0 vote259 views1 answer
Sql server update top n records
SQL