From: Gerald Clark <[EMAIL PROTECTED]>
> Default values must be constants.
> Håkan Elmqvist wrote:
> > Now I want to register who changed it...
===> MY two cents worth:
With MySQL, this sort of thing usually gets handled in a piece of software. In Perl,
we might say something like:
$sth = $dbh->prepare(qq{INSERT INTO my_table (user, data) VALUES (?,?)});
$sth->execute(user(), $data);
I know that I'd like to be able to define internal divisiveness like:
CREATE TABLE my_table (
id int unsigned default my_sequence_routine(),
...
);
But I wouldn't be willing to have this in the engine if it meant a performance hit
during the times when I wasn't this functionality.
---
Rodney Broom
Programmer: Desert.Net
---------------------------------------------------------------------
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