Hi Boyd, Can I ask why it really matters? :-) I would assume the DEFAULT value is stored at creation time; but the end result would be the same either way.
BTW, I hate how MySQL's SHOW CREATE TABLE quotes DEFAULT INT-family values. :-( It shouldn't do that. Matt ----- Original Message ----- From: "Boyd E. Hemphill" Sent: Friday, April 09, 2004 9:49 PM Subject: Question regarding defaults > Hello: > > I have need to declare a column as type integer then default is at '0' > (that is a string with a zero in it). > > An example may be: > Create table foo ( > foo_id int not null default '0' > ) > > My question centers on the notion of implicit type conversion. Is the > server converting the type at the time the ddl (not really too big a > deal) or is it doing the conversion at run time (i.e. each time a row is > inserted in the DB). > > Thanks for your time and expertise! > > Best Regards, > Boyd E. Hemphill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]