- set_time_limit(0);
- $link = mysql_connect('localhost', 'ngjc', 'ohFt6yhHYvt5')
- or die('Could not connect: ' . mysql_error());
- echo 'Connected successfully';
- mysql_select_db('ngjc') or die('Could not select database');
- require "sql.php";//此处换成导出的sql文件
- $arrayerr=array();
- $oknum=0;
- $errnum=0;
- mysql_query("SET NAMES utf8");
- foreach($sqlarr as $sql)
- {
- if(!mysql_query($sql))
- {
- $arrayerr[]=$sql;$errnum++;
- }
- else
- {
- $oknum++;
- }
- }
- echo "<pre>OK:$oknum <br>errornum:$errnum <br> error:<br>";
- print_r($arrayerr);
- mysql_close($link);
- //该片段来自于http://www.codesnippet.cn/detail/190820135197.html
来源: http://www.codesnippet.cn/detail/190820135197.html