James Tusini <[EMAIL PROTECTED]> wrote: > I was wondering if there's a way to set a field to be a pattern of another > field in the same table, ie: > > number file > 1 xyz_1.jpg > 2 xyz_2.jpg > 3 xyz_3.jpg > . > . > n xyz_n.jpg > > > I'm achieving this through php but was curious to know if you could do it > directly in MySQL as it would probably be much more efficient.
No. Default values must be constant. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]