Re: Auto_increment field size (was: Howto make a double LEFT JOIN)
| From: | Andrey Hristov | Date: | Fri, 05 Oct 2001 16:04:21 +0000 |
| Subject: | Re: Auto_increment field size (was: Howto make a double LEFT JOIN) | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-70106@lists.php.net to get a copy of this message | ||
select first.*,second.*,third.* from first left join second
using(for_key_first_second) left join third using(for_key_2_3);
On Friday 05 October 2001 18:50, you wrote:
> Hello,
>
> > you can always reset the auto_increment value (I think that is as simlple
>
> as
>
> > "set insert_id=1;" but you may want to double check as this is off the
> > top of my head).
>
> I don't think i can do so cause i never delete all rows.
> so will get something like:
> 1
> <- new insert her
> 10000000
> 10000001
> etc.