Yes it could be but YOU DON'T NEED TRIGGERS. All you need is the
auto_increment extension for multiple-column primary keys, as described by
another post and demonstrated here:
http://dev.mysql.com/doc/refman/4.1/en/example-auto-increment.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Gleb Paharenko <gleb.paharenko@stripped> wrote on 12/28/2005 08:31:18
AM:
> Hello.
>
>
>
> This should be possible with triggers. See:
>
> http://dev.mysql.com/doc/refman/5.0/en/triggers.html
>
>
>
>
>
>
>
> "Salvatore Celsomino" <salvo.celsomino@stripped> wrote:
>
> >Hi,
>
> >it is possible to create a field autoincrement for year.
>
> >example:
>
> >1/2005
>
> >2/2005
>
> >...........
>
> >10500/2005
>
> >----new year------
>
> >1/2006
>
> >2/2006
>
> >............
>
>
>
> --
> For technical support contracts, goto
https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Gleb Paharenko
> / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
> <___/ www.mysql.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
