//php实现  
error_reporting(E_ALL ^ E_NOTICE);  
$conn = mysql_connect("localhost","123123","123456");  
mysql_select_db('datebase1');  
$link = 0;  
mysql_query('START TRANSACTION',$link);  
mysql_query("insert into table1(name) values('t1_name')",$link);  
$id = mysql_insert_id($link);  
mysql_query("insert into table2(t1id, name) values($id, 't2_name')",$link);  
mysql_query("insert into table3(t1id, name) values($id, 't3_name')",$link);  
mysql_query('COMMIT');  
 
//mysql 实现   
set @temp=0;  
insert into table1(name) values('t1_name');  
select mysql_insert_id() into @temp;  
insert into table2(t1id, name) values(@temp, 't2_name');  
insert into table3(t1id, name) values(@temp, 't3_name');  

菜菜鸟 大家帮忙指正