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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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 > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED] >
