CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
);
CREATE TABLE Persons (
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);
<?php
require".....ادرس فایل کانکشن
$sql="CREATE TABLE Persons (
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);";
result=.........
?>
<?php
/**
* @function backupDatabaseTables
* @author Termijan
* @link http://netparadis.com
* @usage Backup database tables and save in SQL file
*/
function backupDatabaseTables($dbHost,$dbUsername,$dbPassword,$dbName,$tables = '*'){
//connect & select the database
$db = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);
//get all of the tables
if($tables == '*'){
$tables = array();
$result = $db->query("SHOW TABLES");
while($row = $result->fetch_row()){
$tables[] = $row[0];
}
}else{
$tables = is_array($tables)?$tables:explode(',',$tables);
}
//loop through the tables
foreach($tables as $table){
$result = $db->query("SELECT * FROM $table");
$numColumns = $result->field_count;
$return .= "DROP TABLE $table;";
$result2 = $db->query("SHOW CREATE TABLE $table");
$row2 = $result2->fetch_row();
$return .= "\n\n".$row2[1].";\n\n";
for($i = 0; $i < $numColumns; $i++){
while($row = $result->fetch_row()){
$return .= "INSERT INTO $table VALUES(";
for($j=0; $j < $numColumns; $j++){
$row[$j] = addslashes($row[$j]);
$row[$j] = ereg_replace("\n","\\n",$row[$j]);
if (isset($row[$j])) { $return .= '"'.$row[$j].'"' ; } else { $return .= '""'; }
if ($j < ($numColumns-1)) { $return.= ','; }
}
$return .= ");\n";
}
}
$return .= "\n\n\n";
}
//save file
$handle = fopen('db-backup-'.time().'.sql','w+');
fwrite($handle,$return);
fclose($handle);
}
<?php
// Database configuration
$host = "localhost";
$username = "root";
$password = "";
$database_name = "mydatabasename";
// Get connection object and set the charset
$conn = mysqli_connect($host, $username, $password, $database_name);
$conn->set_charset("utf8");
// Get All Table Names From the Database
$tables = array();
$sql = "SHOW TABLES";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_row($result)) {
$tables[] = $row[0];
}
$sqlScript = "";
foreach ($tables as $table) {
// Prepare SQLscript for creating table structure
$query = "SHOW CREATE TABLE $table";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_row($result);
$sqlScript .= "\n\n" . $row[1] . ";\n\n";
$query = "SELECT * FROM $table";
$result = mysqli_query($conn, $query);
$columnCount = mysqli_num_fields($result);
// Prepare SQLscript for dumping data for each table
for ($i = 0; $i < $columnCount; $i ++) {
while ($row = mysqli_fetch_row($result)) {
$sqlScript .= "INSERT INTO $table VALUES(";
for ($j = 0; $j < $columnCount; $j ++) {
$row[$j] = $row[$j];
if (isset($row[$j])) {
$sqlScript .= '"' . $row[$j] . '"';
} else {
$sqlScript .= '""';
}
if ($j < ($columnCount - 1)) {
$sqlScript .= ',';
}
}
$sqlScript .= ");\n";
}
}
$sqlScript .= "\n";
}
if(!empty($sqlScript))
{
// Save the SQL script to a backup file
$backup_file_name = $database_name . '_backup_' . time() . '.sql';
$fileHandler = fopen($backup_file_name, 'w+');
$number_of_lines = fwrite($fileHandler, $sqlScript);
fclose($fileHandler);
// Download the SQL backup file to the browser
header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename=' . basename($backup_file_name));
header('Content-Transfer-Encoding: binary');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
header('Content-Length: ' . filesize($backup_file_name));
ob_clean();
flush();
readfile($backup_file_name);
exec('rm ' . $backup_file_name);
}
?>
<?php
/**
* @function backupDatabaseTables
* @author Termijan
* @link http://netparadis.com
* @usage Backup database tables and save in SQL file
*/
function backupDatabaseTables($dbHost,$dbUsername,$dbPassword,$dbName,$tables = '*'){
//connect & select the database
$db = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);
//get all of the tables
if($tables == '*'){
$tables = array();
$result = $db->query("SHOW TABLES");
while($row = $result->fetch_row()){
$tables[] = $row[0];
}
}else{
$tables = is_array($tables)?$tables:explode(',',$tables);
}
//loop through the tables
foreach($tables as $table){
$result = $db->query("SELECT * FROM $table");
$numColumns = $result->field_count;
$return .= "DROP TABLE $table;";
$result2 = $db->query("SHOW CREATE TABLE $table");
$row2 = $result2->fetch_row();
$return .= "\n\n".$row2[1].";\n\n";
for($i = 0; $i < $numColumns; $i++){
while($row = $result->fetch_row()){
$return .= "INSERT INTO $table VALUES(";
for($j=0; $j < $numColumns; $j++){
$row[$j] = addslashes($row[$j]);
$row[$j] = ereg_replace("\n","\\n",$row[$j]);
if (isset($row[$j])) { $return .= '"'.$row[$j].'"' ; } else { $return .= '""'; }
if ($j < ($numColumns-1)) { $return.= ','; }
}
$return .= ");\n";
}
}
$return .= "\n\n\n";
}
//save file
$handle = fopen('db-backup-'.time().'.sql','w+');
fwrite($handle,$return);
fclose($handle);
}
<?php
// Database configuration
$host = "localhost";
$username = "root";
$password = "";
$database_name = "mydatabasename";
// Get connection object and set the charset
$conn = mysqli_connect($host, $username, $password, $database_name);
$conn->set_charset("utf8");
// Get All Table Names From the Database
$tables = array();
$sql = "SHOW TABLES";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_row($result)) {
$tables[] = $row[0];
}
$sqlScript = "";
foreach ($tables as $table) {
// Prepare SQLscript for creating table structure
$query = "SHOW CREATE TABLE $table";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_row($result);
$sqlScript .= "\n\n" . $row[1] . ";\n\n";
$query = "SELECT * FROM $table";
$result = mysqli_query($conn, $query);
$columnCount = mysqli_num_fields($result);
// Prepare SQLscript for dumping data for each table
for ($i = 0; $i < $columnCount; $i ++) {
while ($row = mysqli_fetch_row($result)) {
$sqlScript .= "INSERT INTO $table VALUES(";
for ($j = 0; $j < $columnCount; $j ++) {
$row[$j] = $row[$j];
if (isset($row[$j])) {
$sqlScript .= '"' . $row[$j] . '"';
} else {
$sqlScript .= '""';
}
if ($j < ($columnCount - 1)) {
$sqlScript .= ',';
}
}
$sqlScript .= ");\n";
}
}
$sqlScript .= "\n";
}
if(!empty($sqlScript))
{
// Save the SQL script to a backup file
$backup_file_name = $database_name . '_backup_' . time() . '.sql';
$fileHandler = fopen($backup_file_name, 'w+');
$number_of_lines = fwrite($fileHandler, $sqlScript);
fclose($fileHandler);
// Download the SQL backup file to the browser
header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename=' . basename($backup_file_name));
header('Content-Transfer-Encoding: binary');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
header('Content-Length: ' . filesize($backup_file_name));
ob_clean();
flush();
readfile($backup_file_name);
exec('rm ' . $backup_file_name);
}
?>
<?php
$db_name = "epiz_9999999_name";
$mysql_username = "epiz_999909";
$mysql_password ="pppppppppp";
$server_name = "sql313.epizy.com";
$ccoonn = mysqli_connect($server_name, $mysql_username, $mysql_password,$db_name);
if (!$ccoonn)
{
die("Connection error: " . mysqli_connect_error());
}
?>
<?php
$database = 'YOUR-DB-NAME';
$user = 'USERNAME';
$pass = 'PASSWORD';
$host = 'localhost';
$charset = "utf8mb4"; # utf8mb4_unicode_ci
$conn = new mysqli($host, $user, $pass, $database);
$conn->set_charset($charset);
# get all tables
$result = mysqli_query($conn, "SHOW TABLES");
$tables = array();
while ($row = mysqli_fetch_row($result)) {
$tables[] = $row[0];
}
# Get tables data
$sqlScript = "";
foreach ($tables as $table) {
$query = "SHOW CREATE TABLE $table";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_row($result);
$sqlScript .= "\n\n" . $row[1] . ";\n\n";
$query = "SELECT * FROM $table";
$result = mysqli_query($conn, $query);
$columnCount = mysqli_num_fields($result);
for ($i = 0; $i < $columnCount; $i ++) {
while ($row = mysqli_fetch_row($result)) {
$sqlScript .= "INSERT INTO $table VALUES(";
for ($j = 0; $j < $columnCount; $j ++) {
$row[$j] = $row[$j];
$sqlScript .= (isset($row[$j])) ? '"' . $row[$j] . '"' : '""';
if ($j < ($columnCount - 1)) {
$sqlScript .= ',';
}
}
$sqlScript .= ");\n";
}
}
$sqlScript .= "\n";
}
//save file
$mysql_file = fopen($database . '_backup_'.time() . '.sql', 'w+');
fwrite($mysql_file ,$sqlScript );
fclose($mysql_file );
<?php
require"ccoonn.php";
$charset = "utf8mb4";// # utf8mb4_unicode_ci
//$conn = new mysqli($host, $user, $pass, $database);
$conn->set_charset($charset);
# get all tables
$result = mysqli_query($conn, "SHOW TABLES");
$tables = array();
while ($row = mysqli_fetch_row($result)) {
// echo "<br>".$row[0];
$tables[] = $row[0];
}
# Get tables data
$sqlScript = "";
foreach ($tables as $table) {
$query = "SHOW CREATE TABLE $table";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_row($result);
$sqlScript .= "\n\n" . $row[1] . ";\n\n";
// echo"\n\n" . $row[1] . ";\n\n";
$query = "SELECT * FROM $table";
$result = mysqli_query($conn, $query);
$columnCount = mysqli_num_fields($result);
for ($i = 0; $i < $columnCount; $i ++) {
while ($row = mysqli_fetch_row($result)) {
$sqlScript .= "INSERT INTO $table VALUES(";
echo"INSERT INTO $table VALUES(";
for ($j = 0; $j < $columnCount; $j ++) {
$row[$j] = $row[$j];
$sqlScript .= (isset($row[$j])) ? '"' . $row[$j] . '"' : '""';
if (isset($row[$j])) echo'"'.$row[$j].'"';
if (!isset($row[$j])) echo'""';
if ($j < ($columnCount - 1)) {
$sqlScript .= ',';
echo',';
}
}
$sqlScript .= ");\n";
echo ");<br>";
}
}
$sqlScript .= "\n";
echo "<br>";
}
?>
INSERT INTO counters VALUES("1","28");
INSERT INTO name_email VALUES("2","Saalek110","[email protected]");
INSERT INTO name_email VALUES("2","Amir","Amir email");
INSERT INTO name_email VALUES("2","Amir2","Amir2 email");
INSERT INTO name_email VALUES("2","Saman","Saman@");
INSERT INTO name_email VALUES("2","Saalek110","[email protected]");
INSERT INTO name_email VALUES("2","Amir","Amir email");
INSERT INTO name_email VALUES("2","Amir2","Amir2 email");
INSERT INTO name_email VALUES("2","Saman","Saman@");
INSERT INTO posts VALUES("1","بسم الله الرحمن الرحیم","","","");
INSERT INTO posts VALUES("2","من تعدادی جدول ساختم. دو جدول در بالا و یک جدول در میانه سایت. جدول میانه ۳ ستون دارد و در هر ستون خودش حاوی یک جدول است. ستون میانه پست ها است. ستون سمت راست لینک ها. و ستون سمت چپ ، فعلا خالی.","","","");
INSERT INTO posts VALUES("3","پست ۳","","","");
INSERT INTO posts VALUES("4","پست ۴","","","");
INSERT INTO posts VALUES("5","پست ۵","","","");
INSERT INTO posts VALUES("6","پست ۶","","","");
INSERT INTO posts VALUES("7","پست ۷","","","");
INSERT INTO texts VALUES("1","In the name of god","---");
INSERT INTO texts VALUES("2","welcome","خوش آمدید");
INSERT INTO texts VALUES("3","Start","شروع");
INSERT INTO texts VALUES("4","Create new statment","عبارت جدید بسازید");
INSERT INTO texts VALUES("5","New post","پست جدید");
INSERT INTO texts VALUES("6","Review","بازدید");
INSERT INTO texts VALUES("7","Test","تست");
INSERT INTO texts VALUES("8","Dasti dar myadmin vared kardam","نوشته فارسی دستی در ادمین نوشتم");
INSERT INTO texts VALUES("9","Welcome","خوش آمدید");
INSERT INTO texts VALUES("10","Create new statment","عبارت جدید بسازید");
INSERT INTO texts VALUES("11","New post","پست جدید");
INSERT INTO texts VALUES("12","Review","بازدید");
<?php
require"ccoonn.php";
$charset = "utf8";
$conn->set_charset($charset);
$sqlScript = "";
$table="name_email";
//foreach ($tables as $table) {
$query = "SELECT * FROM $table";
$result = mysqli_query($conn, $query);
$columnCount = mysqli_num_fields($result);
for ($i = 0; $i < $columnCount; $i ++) {
while ($row = mysqli_fetch_row($result)) {
$sqlScript .= "INSERT INTO $table VALUES(";
echo"INSERT INTO $table VALUES(";
for ($j = 0; $j < $columnCount; $j ++) {
$row[$j] = $row[$j];
$sqlScript .= (isset($row[$j])) ? '"' . $row[$j] . '"' : '""';
if (isset($row[$j])) echo'"'.$row[$j].'"';
if (!isset($row[$j])) echo'""';
if ($j < ($columnCount - 1)) {
$sqlScript .= ',';
echo',';
}
}
$sqlScript .= ");\n";
echo ");<br>";
}
}
$sqlScript .= "\n";
echo "<br>";
//} foreach
?>
INSERT INTO name_email VALUES("2","Saalek110","[email protected]");
INSERT INTO name_email VALUES("2","Amir","Amir email");
INSERT INTO name_email VALUES("2","Amir2","Amir2 email");
INSERT INTO name_email VALUES("2","Saman","Saman@");
<?php
<?php
require"ccoonn.php";
$charset = "utf8";
$conn->set_charset($charset);
$sqlScript = "";
//-------------
$table="test";
$table2="test2";
$start=3;
$end=9;
$max_soton=3;
//-------------
for ($i = $start; $i <=$end; $i ++) {
$query = "SELECT * FROM $table WHERE number=$i";
$result = mysqli_query($conn, $query);
echo"INSERT INTO $table2 (`a1`,`a2`,`a3`) VALUES(";
while ($row = mysqli_fetch_row($result)) {
for ($p = 1; $p <=$max_soton; $p ++) {
if (isset($row[$p])) echo"'".$row[$p]."'";
if (!isset($row[$p])) echo"''";
if ($p <= ($max_soton - 1)) { echo','; }
}//second for loop
}// while fetch
echo ");<br>";
} // for loop
echo "<br>";
?>
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A1','B1','C1');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A2','B2','C2');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A3','B3','C3');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A4','B4','C4');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A5','B5','C5');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A6','B6','C6');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A7','B7','C7');
//-------------
$table="test";
$table2="test";
$start=3;
$end=9;
$max_soton=3;
//-------------
<?php
require"ccoonn.php";
$charset = "utf8";
$conn->set_charset($charset);
?>
<br><br>
<form id='myform' action="<?php echo $_SERVER['PHP_SELF']; ?>" method = 'POST'>
<center>
start: <input type="text" style=" font-size:35px; height:55px; width:120px" name="start">
end: <input type="text" style=" font-size:35px; height:55px; width:120px" name="end"><br><br>
<input type="submit" style=" font-size:35px; height:55px; width:120px"name='action_2' value="Submit">
</center>
</form>
<?php
if(isset($_POST['action_2']))
{
echo"<br>";
$start=test_input($_POST["start"]);
$end=test_input($_POST["end"]);
echo "<br>start= ".$start;
echo "<br>end= ".$end;
echo"<br><br>";
$sqlScript = "";
//-------------
$table="test";
$table2="test2";
$max_soton=3;
//-------------
for ($i = $start; $i <=$end; $i ++) {
$query = "SELECT * FROM $table WHERE number=$i";
$result = mysqli_query($conn, $query);
echo"INSERT INTO $table2 (`a1`,`a2`,`a3`) VALUES(";
while ($row = mysqli_fetch_row($result)) {
for ($p = 1; $p <=$max_soton; $p ++) {
if (isset($row[$p])) echo"'".$row[$p]."'";
if (!isset($row[$p])) echo"''";
if ($p <= ($max_soton - 1)) { echo','; }
}//second for loop
}// while fetch
echo ");<br>";
} // for loop
echo "<br>";
}// if action
function test_input($data) {
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data; }
?>
<?php
require"ccoonn.php";
$charset = "utf8";
$conn->set_charset($charset);
if(!isset($_POST['action_2']))
{
?>
<br><br>
<form id='myform' action="<?php echo $_SERVER['PHP_SELF']; ?>" method = 'POST'>
<center>
start: <input type="text" style=" font-size:35px; height:55px; width:120px" name="start">
end: <input type="text" style=" font-size:35px; height:55px; width:120px" name="end"><br><br>
<input type="submit" style=" font-size:35px; height:55px; width:120px"name='action_2' value="Submit">
</center>
</form>
<?php
}// form badan namayesh peyda nakonad
if(isset($_POST['action_2']))
{
echo"<br>";
$start=test_input($_POST["start"]);
$end=test_input($_POST["end"]);
echo "<br>start= ".$start;
echo "<br>end= ".$end;
echo"<br><br>";
$sqlScript = "";
//-------------
$table="test";
$table2="test2";
$max_soton=3;
//-------------
for ($i = $start; $i <=$end; $i ++) {
$query = "SELECT * FROM $table WHERE number=$i";
$result = mysqli_query($conn, $query);
echo"INSERT INTO $table2 (`a1`,`a2`,`a3`) VALUES(";
while ($row = mysqli_fetch_row($result)) {
for ($p = 1; $p <=$max_soton; $p ++) {
if (isset($row[$p])) echo"'".$row[$p]."'";
if (!isset($row[$p])) echo"''";
if ($p <= ($max_soton - 1)) { echo','; }
}//second for loop
}// while fetch
echo ");<br>";
} // for loop
echo "<br>";
}// if action
function test_input($data) {
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data; }
?>
<?php
require"ccoonn.php";
$charset = "utf8";
$conn->set_charset($charset);
if(!isset($_POST['action_2']))
{
?>
<br><br>
<form id='myform' action="<?php echo $_SERVER['PHP_SELF']; ?>" method = 'POST'>
<center>
start: <input type="text" style=" font-size:35px; height:55px; width:120px" name="start">
end: <input type="text" style=" font-size:35px; height:55px; width:120px" name="end"><br><br>
<input type="submit" style=" font-size:35px; height:55px; width:120px"name='action_2' value="Submit">
</center>
</form>
<?php
}// form badan namayesh peyda nakonad
if(isset($_POST['action_2']))
{
echo"<br>";
$start=test_input($_POST["start"]);
$end=test_input($_POST["end"]);
echo "<br>start= ".$start;
echo "<br>end= ".$end;
echo"<br><br>";
$sqlScript = "";
//-------------
$table="test";
$table2="test2";
$max_soton=3;
//-------------
for ($i = $start; $i <=$end; $i ++) {
$query = "SELECT * FROM $table WHERE number=$i";
$result = mysqli_query($conn, $query);
echo"INSERT INTO $table2 (`a1`,`a2`,`a3`) VALUES(";
$sqlScript .="INSERT INTO $table2 (`a1`,`a2`,`a3`) VALUES(";
while ($row = mysqli_fetch_row($result)) {
for ($p = 1; $p <=$max_soton; $p ++) {
if (isset($row[$p]))
{
echo"'".$row[$p]."'";
$sqlScript .= "'".$row[$p]."'";
}
if (!isset($row[$p]))
{
echo"''";
$sqlScript .= "''";
}
if ($p <= ($max_soton - 1)) { echo','; }
}//second for loop
}// while fetch
echo ");<br>";
$sqlScript .= ");\n";
} // for loop
echo "<br>";
$sqlScript .= "\n";
echo"<br> chaape sqlScrip: <br><br>";
echo $sqlScript;
if(!empty($sqlScript))
{
// Save the SQL script to a backup file
$backup_file_name = $database_name . '_backup_' . time() . '.sql';
$fileHandler = fopen($backup_file_name, 'w+');
$number_of_lines = fwrite($fileHandler, $sqlScript);
fclose($fileHandler);
// Download the SQL backup file to the browser
header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename=' . basename($backup_file_name));
header('Content-Transfer-Encoding: binary');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
header('Content-Length: ' . filesize($backup_file_name));
ob_clean();
flush();
readfile($backup_file_name);
exec('rm ' . $backup_file_name);
}
}// if action
function test_input($data) {
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data; }
?>
//if(!empty($sqlScript))
if (false)
start= 2
end= 10
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('Aaa1','Bbb1','Ccc1');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A1','B1','C1');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A2','B2','C2');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A3','B3','C3');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A4','B4','C4');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A5','B5','C5');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A6','B6','C6');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A7','B7','C7');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A8','B8','C8');
chaape sqlScrip:
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('Aaa1''Bbb1''Ccc1'); INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A1''B1''C1'); INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A2''B2''C2'); INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A3''B3''C3'); INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A4''B4''C4'); INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A5''B5''C5'); INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A6''B6''C6'); INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A7''B7''C7'); INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A8''B8''C8');
$sqlScript .= "\n";
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('Aaa1''Bbb1''Ccc1');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A1''B1''C1');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A2''B2''C2');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A3''B3''C3');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A4''B4''C4');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A5''B5''C5');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A6''B6''C6');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A7''B7''C7');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A8''B8''C8');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A9''B9''C9');
INSERT INTO test2 (`a1`,`a2`,`a3`) VALUES('A10''B10''C10');
.=
$table="test";
$table2="test2";