Sometimes you need to import multiple text data to the database, each time waiting for a very waste of time, so write your own SQL script, so that the program automatically executes, there is no need to wait.
Command:
Mysql-u ROOT-PROOTP Testt <a.sql
650) this.width=650; "src=" http://s5.51cto.com/wyfs02/M02/83/6C/wKioL1dzOB2wxuWxAAAOoyF2eVE888.jpg "title=" 1.jpg " alt= "Wkiol1dzob2wxuwxaaaooyf2eve888.jpg"/>
-U followed by database user name
-P followed by the database password
TESTT is a database
A.sql is the SQL script I want to execute.
I want to test the content:
650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M02/83/6C/wKioL1dzOMehoyY2AADQDWAP90E739.jpg-wh_500x0-wm_3 -wmp_4-s_953461883.jpg "title=" 2.jpg "alt=" Wkiol1dzomehoyy2aadqdwap90e739.jpg-wh_50 "/>
Test results:
650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/83/6D/wKiom1dzORLB-woWAAArgkGiVTI694.jpg-wh_500x0-wm_3 -wmp_4-s_189930931.jpg "title=" 3.jpg "alt=" Wkiom1dzorlb-wowaaargkgivti694.jpg-wh_50 "/>
Reference Links:
Http://www.oschina.net/question/227902_163001 for Dead Water Fox
This article is from the "Enlightened Grocery store" blog, please be sure to keep this source http://wutou.blog.51cto.com/615096/1793901
MySQL Imports multiple statements