On 5/3/06, Richard Lynch <[EMAIL PROTECTED]> wrote:
On Tue, May 2, 2006 7:22 am, chris smith wrote:
> On 5/2/06, Ross <[EMAIL PROTECTED]> wrote:
>> This is my database now...I will use the item_id for the order but
>> what if I
>> want to change item_id 3 to item id 1? How can I push all the item
On Tue, May 2, 2006 7:22 am, chris smith wrote:
> On 5/2/06, Ross <[EMAIL PROTECTED]> wrote:
>> This is my database now...I will use the item_id for the order but
>> what if I
>> want to change item_id 3 to item id 1? How can I push all the items
>> down one
>> place? How can I delete any gaps when
On Tue, May 2, 2006 7:05 am, Ross wrote:
> This is my database now...I will use the item_id for the order but
> what if I
> want to change item_id 3 to item id 1? How can I push all the items
> down one
> place? How can I delete any gaps when items are deleted.
Change item_id 3 to 1.
... select i
Exactly - I don't think you really understand how a relational database
works. The ids are retained as they may relate to records in another table.
Internal sorting order is of no relevance at the application level. I think
you need to rethink your design a little.
On 02/05/06, T.Lensselink <[EMA
> This is my database now...I will use the item_id for the order but what if
> I
> want to change item_id 3 to item id 1? How can I push all the items down
> one
> place? How can I delete any gaps when items are deleted.
>
>
> CREATE TABLE `board_papers` (
> `id` int(4) NOT NULL auto_increment,
>
On 5/2/06, Ross <[EMAIL PROTECTED]> wrote:
This is my database now...I will use the item_id for the order but what if I
want to change item_id 3 to item id 1? How can I push all the items down one
place? How can I delete any gaps when items are deleted.
Why do you want to do that? There's no be
6 matches
Mail list logo
