/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 vote137 views1 answer
Sqlalchemy case insensitive like
SQL
1 vote74 views1 answer
Flask-sqlalchemy filter_by contains
SQL
5 votes113 views5 answers
Find max number in sql
SQL
0 vote120 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
19 votes117 views3 answers
Grant mysql
SQL
0 vote137 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote119 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote83 views2 answers
Sql update from two different database
SQL
1 vote129 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
10 votes125 views2 answers
Forgot my mysql password mac
SQL