HELP
HELP

Reputation: 14575

MySQL data storage question

How would I store the following code below its output in my Mysql table? How would the field be made?

md5(uniqid(microtime(),1))

example.

field CHAR(128) NOT NULL

Upvotes: 0

Views: 72

Answers (1)

Waleed Eissa
Waleed Eissa

Reputation: 10513

field CHAR(32) NOT NULL

The output of MD5() will always be 32 characters long

But of course you can save it in a binary format, in this case you should use:

field BINARY(16) NOT NULL

Upvotes: 1

Related Questions