Test essential skills Series 1: script data import using mysql commands, essential skills mysql

Test essential skills Series 1: script data import using mysql commands, essential skills mysql

 

Sharing TestWhat's the problem solved in the project! Today's sharing: How to pass MysqlHow can I import mysql script file data through the command line? ----- Solve the actual problem: WorkDuring the process, it is often necessary to import mysql script files. Many people may say that it is easy to import them directly through the mysql client. However, for the sake of security, many servers, third-party Client Login permissions will not be opened (of course there are many other ways to handle them, and we will not discuss them today). How can we import scripts at this time? ----- Premise: You know what mysql is and what the basic mysql Command knows about mysql-u root-p123456 ----- body start: Step 1: import the SQL script file to the current directory. Assume that the file is: idomysqltest. step 2 of SQL: determine which one to import DatabaseAssume that step 3 of szmzcz is to import the mysql server and enter the command: mysql-uroot-p123456-Dszmzcz <idomysqltest. SQL ---- over, which is easy to do! Of course, there are other ways to import. If you are interested, try it yourself, or BaiduSearch; there are many implementation methods for one thing; be good at thinking! -- Old Xu blog all Article, Not labeled reproduced, are original reproduced indicated source http://www.51testing.com /? 497177