Help with table structure and function
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.
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.