/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 vote171 views1 answer
Mysql wsrep ls
SQL
3 votes138 views1 answer
Oracle list dates without weekends
SQL
3 votes146 views3 answers
Stop mysql ubuntu
SQL
0 vote261 views1 answer
Android sqlite add column if not exists
SQL
5 votes132 views2 answers
Oracle to_timestamp
SQL
0 vote186 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
18 votes136 views3 answers
Find column name in database
SQL
0 vote129 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote280 views2 answers
Create fulltext index mysql
SQL
0 vote141 views1 answer
Get substract count sql
SQL