INSERT INTO SELECT php statement is used to insert new records into a database table from php scripts.
INSERT INTO SELECT Syntax
insert into table (col1, col2) select 1, field.id from table 2
In PHP, you just have to insert the above statement into mysql_query command just like below:
<?php $con = mysql_connect("localhost","peter","abc123"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("my_db", $con); mysql_query("insert into i1(pin,dist2uc, dist2hw) select e.pin, d.dist2uc,d.dist2hw from d1 e, dist2unh d where e.pin = d.pin;"); mysql_close($con); ?>
Hope it helps.
Posts Related to Insert Into Select PHP:
- How to Create Multiple Tables in One Statement with MySQL & PHP
If you are working on a project that force you... - Setup Vista Drivers on Windows 7
Just for your information, Vista drivers may work on Windows... - Connect Nokia E71 Bluetooth Phone to Toshiba Laptop Computer
This tutorial will guide you step-by-step how to connect Nokia... - Wireless Connection Not Working On Laptop Dell Inspiron 1525
In case your wireless connection not working on your laptop,...
