MySQL Forums
Forum List  »  Newbie

Help with table structure and function
Posted by: Ciprian Cirstea
Date: April 16, 2014 03:27AM

I'm not sure how to structure something like this:

myTable
id name
1 reddit
2 google
3 yahoo

If I would do a regular select * from myTable, and order them by id I can get
reddit google yahoo

I would like to add other names somewhere between those three. Like youtube for example:
reddit youtube google yahoo

Since the id is going to autoincrement, i ll end up with something like this:
reddit google yahoo youtube

But I want youtube to be after "reddit" and before "google" and I m not really sure how to do the insert when adding a new name.

Options: ReplyQuote


Subject
Written By
Posted
Help with table structure and function
April 16, 2014 03:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.