/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

1 vote158 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote160 views1 answer
Oracle last connexion
SQL
4 votes137 views3 answers
Create database in mySQL
SQL
1 vote154 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote214 views1 answer
Import sql dump into postgresql database
SQL
0 vote103 views4 answers
Sql limit 1 offset 1
SQL
0 vote145 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote167 views1 answer
Replace \n sql
SQL
10 votes160 views4 answers
Join multiple tables in sql
SQL
10 votes141 views5 answers
Mysql create user
SQL