dt_gry Posted October 13, 2008 Share Posted October 13, 2008 I am trying to copy a record from table_1 to table_2 adding endtime to table_2 in the same db and then delete the record from table_1 I have googled till I am blue in the face and I am getting no where. Here are my table fields table_1 'Uname' 'CurDate' 'StartTm' 'IPadd' table_2 'Uname' 'CurDate' 'StartTm' 'EndTm' 'IPadd' Thanks Guys, dt_gry Link to comment https://forums.phpfreaks.com/topic/128213-solved-mysql-copying-record/ Share on other sites More sharing options...
fenway Posted October 13, 2008 Share Posted October 13, 2008 Like with INSERT INTO ... SELECT WHERE? Link to comment https://forums.phpfreaks.com/topic/128213-solved-mysql-copying-record/#findComment-664237 Share on other sites More sharing options...
dt_gry Posted October 13, 2008 Author Share Posted October 13, 2008 Yup, one more detail is that EndTm is held in a variable. any ideas. thanks! Link to comment https://forums.phpfreaks.com/topic/128213-solved-mysql-copying-record/#findComment-664250 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.