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 Quote Link to comment 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? Quote Link to comment 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.