tibberous Posted January 16, 2009 Share Posted January 16, 2009 I have two tables, a temporary table and a real one. When a person starts filling out a request, I want to store their data in the temporary table, and if they confirm it, move it to the real table. The real table has an auto incrementing id, the temporary one doesn't. If I do: insert into `test` select * from `temporyTest` I get a column count doesn't match error. Is there any way around this besides specifying all the fields except id? Should I just use one table and set a Status='Pending' option? Quote Link to comment https://forums.phpfreaks.com/topic/141084-auto-id-breaking-my-table-move/ Share on other sites More sharing options...
flyhoney Posted January 16, 2009 Share Posted January 16, 2009 Should I just use one table and set a Status='Pending' option? Yes. Quote Link to comment https://forums.phpfreaks.com/topic/141084-auto-id-breaking-my-table-move/#findComment-738398 Share on other sites More sharing options...
nadeemshafi9 Posted January 16, 2009 Share Posted January 16, 2009 Should I just use one table and set a Status='Pending' option? Yes. yes i do that if ur controler is well formed you can easily do this behind teh scenes Quote Link to comment https://forums.phpfreaks.com/topic/141084-auto-id-breaking-my-table-move/#findComment-738402 Share on other sites More sharing options...
sasa Posted January 16, 2009 Share Posted January 16, 2009 try insert into `test` select '', temporyTest.* from `temporyTest` Quote Link to comment https://forums.phpfreaks.com/topic/141084-auto-id-breaking-my-table-move/#findComment-738451 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.