Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Random number as Default Value

Status
Not open for further replies.
crjo

crjo

Programmer
Jul 3, 2001
15
US
Converting Access 2K db to MySQL, have field with default value set to display 4-digit random number:
=Int(Rnd()*9999)
How can I convert this to MySQL?
 
Sort by date Sort by votes
You can't. Mysql does only allow constants as default values.

Generate the random value in your application before insertion.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
function argument value, type or count is invalid
Replies
3
Views
332
bharons
bharons
BobThornton
  • Locked
  • Question
Drop/Truncate tables based on a stored procedures value 1
Replies
6
Views
528
BobThornton
BobThornton
Arun Mahajan
  • Locked
  • Question
How to catch SQL Exception Error number in MySQL 5.6
Replies
0
Views
101
Arun Mahajan
Arun Mahajan
Marclem
  • Locked
  • Question
Hour difference based on priority value
Replies
8
Views
92
Marclem
Marclem
kernal
  • Locked
  • Question
Oracle NVL Look for Certain Value else blank Equivalent in Mysql
Replies
0
Views
78
kernal
kernal

Part and Inventory Search

Sponsor

Back
Top