3.23.43 It would be handy to be able to call a mysql built-in as a column default. The reason this would be handy is that I could then go to my umpteen tables and just add one column and suddenly I could know who is changing each record. Otherwise, I have to go to my umpteen x umpteen insert & update queries and change each one to store one more column.
I don't think it works, because I can't get the table to create...but if you know how, please let me know. create table test ( a int(10) not null auto_increment primary key, revision_date timestamp(14), revision_user varchar(10) not null default USER() ); The above errors out at USER(). Of course, if I surround USER() in quotes, it is inserted as a literal, and not evaluated. Regards, Rich --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php