Re: storing username
Posted by: Dimitris Papageorgiou
Date: September 26, 2014 01:15PM

Rick James Wrote:
-------------------------------------------------------
> You have found a reason why I rarely use FOREIGN
> KEYs.
Yes...it seems that in this occasion a foreign key will do more bad than good

> > `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.

The DATE datatype has a specific format,in my case the plugin I use(http://fullcalendar.io/) to build the calendar works only with UNIX timestamps...that is why I do not use DATE.

> > 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?

Can you elaborate further?
Yes I have seen that I have placed an INDEX there-which I see now does not make a lot of sense-but the point I am missing is this "just one field".

Can you elaborate please?

Options: ReplyQuote


Subject
Written By
Posted
September 23, 2014 10:19AM
September 25, 2014 04:13PM
Re: storing username
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.