Creating a new Column with a random INT

[nipponese]

Hi everyone,

 

I am wondering, how can I create a column with a unique auto-generated random integer in each row.

 

Obviously, something like this won't work:

ALTER TABLE contact ADD COLUMN invoice_id INT(SELECT FLOOR(1000 + (RAND() * 9000)));

 

But that's the idea...

 

[fenway]

You could use a trigger....

[gluck]

Hi everyone,

 

I am wondering, how can I create a column with a unique auto-generated random integer in each row.

 

Obviously, something like this won't work:

ALTER TABLE contact ADD COLUMN invoice_id INT(SELECT FLOOR(1000 + (RAND() * 9000)));

 

But that's the idea...

 

 

use a timestamp column for invoice id and default it to current_timestamp. You can convert it to string when using in php or whatever language you user.