Yeah, for example the last statement ALTER...., ..., ... is the only way sometimes to make things working. anyway, it's worth knowing it.
2005/8/13, Chris Elsworth <[EMAIL PROTECTED]>: > On Sat, Aug 13, 2005 at 05:37:56PM +0100, Pooly wrote: > > Damnit ! > > Thanks for pointing it, I forgot these things. > > But it's a bit more subtle : > > [snip] > > Bah, should have waited another 5 minutes before I bothered posting my > last long-winded ramble ;) > > > ALTER TABLE sessions MODIFY id char(32) NOT NULL DEFAULT '', MODIFY ip > > char(8) NOT NULL DEFAULT '0'; > > Cool, I didn't know you could do this though. Ta :) > > -- > Chris > -- Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]