/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

5 votes346 views3 answers
Mysql extract month from date
SQL
-2 votes373 views4 answers
How to get max salary in each department in sql
SQL
2 votes336 views1 answer
Sql like variable
SQL
4 votes353 views2 answers
Sql select except null
SQL
0 vote352 views1 answer
Sub query in linq
SQL
6 votes383 views2 answers
Mysql convert timestamp to date
SQL
0 vote408 views1 answer
Query for backup a database at another location in file system
SQL
0 vote355 views1 answer
Sql get number of days between two dates
SQL
7 votes361 views1 answer
Alter sequence set current value oracle
SQL
0 vote363 views1 answer
Cannot start database server xampp mac os
SQL

Share