|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
From: Jerry Schwartz (jschwartz
the-infoshop.com)
Date: Thu Feb 11 2010 - 10:24:24 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
>-----Original Message-----
>From: MuraliKrishna [mailto:murali_krishnaarthaoptions.com]
>Sent: Thursday, February 11, 2010 12:52 AM
>To: mysqllists.mysql.com
>Subject: help me out for this scenario
>
>I have a table like as follws
>
>
>
>Emp_id, first_login , second_login
>
[JS] I think you are asking for trouble doing things this way. If life has
taught me anything, it's that someday somebody is going to ask for a
third_login.
You'd be much better off in the long run using a second table for the login
times, even if it seems like overkill. In the second table, store the login
number and time for each occurrence for each user:
Emp_id, login_number, login_time
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]