Unique text field in MySQL and php

Posted by Jonathan on Stack Overflow See other posts from Stack Overflow or by Jonathan
Published on 2010-04-07T16:50:36Z Indexed on 2010/04/07 16:53 UTC
Read the original article Hit count: 232

Filed under:

salt

|

unique

|

mysql

|

php

I've created a salt using; md5(rand(0,10000000)); (there is probably a better way?)

There doesn't seem to be possible to make a text field unique in MYSQL. So how do I check if the salt has already been used for a previous user?

Or should I generate the salt based on the current date/time? as it is impossible for 2 users to register at exactly the same time correct?

© Stack Overflow or respective owner

Related posts about salt

Why is a password salt called a "salt"?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a significance to the word "salt" for a password salt? >>> More
Salt question - using a "random salt"

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey everyone, Further to my question here, I have another question regarding salts. When someone says "use a random salt" to pre/append to a password, does this mean: Creating a static a 1 time randomly generated string of characters, or Creating a string of characters that changes at random… >>> More
Generating a salt in PHP

as seen on Stack Overflow - Search for 'Stack Overflow'
What's the best way to generate a cryptographically secure 32 bytes salt in PHP, without depending on libraries seldom included in typical PHP installations? After some googling I discovered that mt_rand is not considered secure enough, but I haven't found a suggestion for a replacement. One article… >>> More
Salt, passwords and security

as seen on Stack Overflow - Search for 'Stack Overflow'
I've read through many of the questions on SO about this, but many answers contradict each other or I don't understand. You should always store a password as a hash, never as plain text. But should you store the salt (unique for each user) next to the hashed password+salt in the database. This doesn't… >>> More
salt and rainbow table

as seen on Stack Overflow - Search for 'Stack Overflow'
what is "salt", also what is "rainbow table". >>> More

Related posts about unique

Hash of unique value = unique hash?

as seen on Stack Overflow - Search for 'Stack Overflow'
Theoretically does hashing a unique value yield a unique value? Let's say I have a DB table with 2 columns: id and code. id is an auto-incrementing int and code is a varchar. If I do ... $code = sha1($id); ... and then store $code into the same row as $id. Will my code column be unique as well… >>> More
Unique Business Value vs. Unique IT

as seen on Oracle Blogs - Search for 'Oracle Blogs'
When the age of computing started, technology was new, exciting, full of potential and had a long way to grow. Vendor architectures were proprietary, and limited in function at first, growing in capability and complexity over time. There were few if any "standards", let alone "open standards" and… >>> More
Creating a short unique string for each unique long string

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to create a url shortener system in c# and asp.net mvc. I know about hashtable and I know how to create a redirect system etc. The problem is indexing long urls in database. Some urls may have up to 4000 character length, and it seems it is a bad idea to index this kind of strings. The… >>> More
Return a Unique Bean Instance from a Spring Container

as seen on Internet.com - Search for 'Internet.com'
Define the bean as a prototype bean. >>> More
Return a Unique Bean Instance from a Spring Container

as seen on Internet.com - Search for 'Internet.com'
Define the bean as a prototype bean. >>> More