konnwat Posted August 28, 2007 Share Posted August 28, 2007 Well i have 2 tables. table1 has `datetime` `name` `language` `points` `group` `rank` table2 has `position` `name` `rank` `points` `group` I need to copy the first one over to the second one and the position is based on the points. I thought the best way was to use... INSERT INTO table2 (position, name, rank, points, group) SELECT (0, name, rank, points, group) ORDER BY DESC But table1 has some duplicates of `name`. I need to be able to copy the table with no duplicates so i thought about making the column Unique but i dont know how i would go about doing that for a text column. Also I thought the position could be done by Auto Increasement but then everytime the table updates i need to set the default position back to 1 and i dont know how to do that either. (I thought if i set the default to 1 and Truncate the table it might work but i havent tried) Can anyone help me? Thanks Link to comment https://forums.phpfreaks.com/topic/67059-complicated-copy-table/ Share on other sites More sharing options...
fenway Posted August 28, 2007 Share Posted August 28, 2007 Why are you actually trying to do this? Link to comment https://forums.phpfreaks.com/topic/67059-complicated-copy-table/#findComment-336587 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.