How can you import tables from a sql file into a database by using the mysql client?



How can you import tables from a sql file into a database by using the mysql client?..

Answer / Puneet Awasthi

You can use the `mysql` command followed by the `< sql_file_name.sql >` to import data from an SQL file. For example, `mysql db_name < sql_file_name.sql;`

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is the function of mysqldump?

1 Answers  


Why does mysql have so many connections?

1 Answers  


What is the difference between mysql_fetch_array and mysql_fetch_object?

4 Answers   CTS,


How to check if a record exists in a mysql database php?

1 Answers  


What are the mysql database files stored in system ?

1 Answers  


What is identity in mysql?

1 Answers  


How to enter binary numbers in sql statements?

1 Answers  


Is microsoft sql same as mysql?

1 Answers  


Is mysql a distributed database?

1 Answers  


How does mysql clustering work?

1 Answers  


please give me the answer for this: query which generates the second highest integer in the table?

8 Answers  


Explain % and _ inside like statement?

1 Answers  


Categories