| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Ralph Graulich | Date: | March 1 2000 9:22am |
| Subject: | Re: is there any way to AUTO_INCREMENT fields with non-zero DEFAULTs? | ||
| View as plain text | |||
Hi Skip, >I want to set a non-zero default for an unsigned integer field and also have >that field auto increment. Ideally, I'd like to use something like: The feature to set a DEFAULT value for an autoincrement is AFAIK implemented in some of the 3.23.x versions, which are now in their alpha state with the newest being 3.23.11-alpha. Can be found at www.tcx.se (use a mirror to download). :wq! Ralph Mit freundlichen Gruessen ... Ralph Graulich ... ----------------------------------------------------- reiff medien Technologiezentrum Ralph Graulich Marlener Str. 9 77656 Offenburg tel +49 781 5 04 - 40 03 fax +49 781 5 04 - 40 99 cel +49 172 6 47 48 20 email graulich@stripped ----------------------------------------------------- *** PGP public key on request *** -----------------------------------------------------
| Thread | ||
|---|---|---|
| • is there any way to AUTO_INCREMENT fields with non-zero DEFAULTs? | Skip Montanaro | 1 Mar |
| • RE: is there any way to AUTO_INCREMENT fields with non-zero DEFAULTs? | Josh Hartmann | 1 Mar |
| • Re: is there any way to AUTO_INCREMENT fields with non-zero DEFAULTs? | Thimble Smith | 1 Mar |
| • Re: is there any way to AUTO_INCREMENT fields with non-zero DEFAULTs? | Nem W Schlecht | 2 Mar |
| • Re: is there any way to AUTO_INCREMENT fields with non-zero DEFAULTs? | Thimble Smith | 2 Mar |
| • Re: is there any way to AUTO_INCREMENT fields with non-zero DEFAULTs? | Nem W Schlecht | 2 Mar |
| • Re: is there any way to AUTO_INCREMENT fields with non-zero DEFAULTs? | sasha | 3 Mar |
| • Re: is there any way to AUTO_INCREMENT fields with non-zeroDEFAULTs? | Ralph Graulich | 1 Mar |
