mysql a way to do - copy, insert, select,

Mysql PHP Insert multiple data in 1(one) query

<?

$sql = ' INSERT INTO tablename ( fieldA , fieldB ) VALUES ( dataA1 , dataB1 ), ( dataA2 , dataB2)';
$result = mysql_query($sql);

?>

Insert/copy data from other to another table

<?

$sql = ' INSERT INTO tableA SELECT * FROM tableB ';
$result = mysql_query($sql);

?>

MySQL Manual

Mysql is a relational database management system (RDBMS) which has more than 6 million installations. MySQL stands for "My Structured Query Language".
To who are new in mysql, you can download by click the icon. "Learn then Share".




Thanks to who share this manual.
Thanks to 000webhost.com to sponsor the hosting.
Special thanks to http://www.mysql.com/