/SQL/Mysql import from sql file

Mysql import from sql file

Mysql import sql file

mysql -u username -p database_name < file.sql

10

Mysql load sql from file

 mysql> use db_name;
 mysql> source file_name.sql;

3

Source: stackoverflow.com

Mysql import from sql file

mysql -u username -p database_name < file.sql; OR  mysql> use db_name;
 mysql> source file_name.sql;

3

Import mysql'

LOAD DATA INFILE "name.csv" INTO TABLE "TableName"
FIELDS TERMINATED BY "sign"
LINES TERMINATED BY "sign"
IGNORE 1 LINES
(columns);

0

Source: youtube.com

Similar codes

0 vote141 views1 answer
Oracle gather table statistics
SQL
0 vote149 views1 answer
Populate db from command line postgres
SQL
0 vote136 views1 answer
Sql date between one week
SQL
9 votes168 views1 answer
Alter table column change data type to text mysql
SQL
0 vote149 views1 answer
Allow external access to mysql
SQL
0 vote156 views1 answer
Primary key multiple
SQL
13 votes153 views3 answers
Uninstall mysql centos 7
SQL
0 vote150 views1 answer
Const pool = mysql.createpool()
SQL
6 votes149 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote166 views1 answer
Count database access django
SQL

Share