>-----Original Message----- >From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com] >Sent: Thursday, February 11, 2010 12:52 AM >To: mysql@lists.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 To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
