Friday, April 23, 2010
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);
?>
<?
$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);
?>
Subscribe to:
Post Comments
0 comments:
Post a Comment