Re: storing username
Posted by:
Rick James
Date: September 25, 2014 04:13PM
You have found a reason why I rarely use FOREIGN KEYs.
> `startDate` int(50) NOT NULL,
INT? (50)?
There is a DATE datatype; might you use it?
(50) has no meaning. An INT is a 32-bit number between about -2 billion and +2 billion.
> KEY `fk_users_usertype1_idx` (`usertype`)
ENUMs rarely benefit from an INDEX on just the one field. What query do you think would benefit from it?
Subject
Written By
Posted
September 23, 2014 10:19AM
Re: storing username
September 25, 2014 04:13PM
September 26, 2014 01:15PM
September 27, 2014 12:50AM
September 29, 2014 11:51AM
September 29, 2014 12:06PM
September 29, 2014 12:11PM
September 29, 2014 12:13PM
September 29, 2014 03:21PM
September 29, 2014 12:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.