Test Prerequisite Skills Series 1: Script data import via MySQL command

Lao Xu, share TestThe actual dry goods that can solve the problem in the project! Share today: How to pass MySQLcommand line, import MySQL script file data? ---solving practical problems: workProcess, often need to import MySQL script file Many students may say, directly through the MySQL client import, easy to fix; however, many servers, for security reasons, do not open third-party client login permissions (of course there are many other ways to deal with it today, not discussed); How do I import a script this time? ---Premise: You will already be operating MySQL know what MySQL is basic mysql command know what mysql-u root-p123456 mean----body start: The first step: Import the SQL script file into the current directory, Assume that the file is: Idomysqltest.sql Step two: Determine which to import to Database, assuming: Szmzcz step three: Start importing MySQL server input command: mysql–uroot–p123456-dszmzcz<idomysqltest.sql–Over , easy to handle! of course, there are other ways to import, interested in their own attempts, or Baidu search under;There are many ways to achieve any one thing;be good at thinking!   --Lao Xu Blog All articles , not labeled reproduced, are originalReprint Annotated Source http://www.51testing.com/?497177

Test Prerequisite Skills Series 1: Script data import via MySQL command