Re: Need Query Help

2012-06-22 Thread Shawn Green
On 6/22/2012 12:18 AM, Anupam Karmarkar wrote: Thanks Rick for your reply, Here i am asking about logic to perpare query or whole query itself. A set-based approach to doing the basic task is to convert your set of start/stop times into duration values. The timediff() function mentioned

Re: Need Query Help

2012-06-21 Thread Anupam Karmarkar
June 2012 10:52 PM Subject: RE: Need Query Help http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff and SEC_TO_TIME()/3600 -Original Message- From: Anupam Karmarkar [mailto:sb_akarmar...@yahoo.com] Sent: Wednesday, June 20, 2012 2:39 AM To: mysql

Need Query Help

2012-06-20 Thread Anupam Karmarkar
Hi All, I need query help for following table struture, where we need to calculate login duration of that employee for give period. Example table EmployeeID     LoginTime   LogoutTIme 101            2012-05-01 10:00:00     2012-05-01 12:30:00 102            2012

RE: Need Query Help

2012-06-20 Thread Rick James
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff and SEC_TO_TIME()/3600 -Original Message- From: Anupam Karmarkar [mailto:sb_akarmar...@yahoo.com] Sent: Wednesday, June 20, 2012 2:39 AM To: mysql@lists.mysql.com Subject: Need Query Help Hi All

I need Query Help

2006-02-10 Thread Veerabhadrarao Narra
I have a table named table1 structure is ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | name | varchar(50) | NO | PRI | | | | gender |

Re: I need Query Help

2006-02-10 Thread Gabriel PREDA
UPDATE `table1` SET `gender` = IF('f'=`gender`, 'm', 'f'); If you have NULL columns you might want to make another sublevel in IF to leave it NULL ! I believe this should do it... you might also take into consideraion removing the possibility of a NULL in the `gender` column... because it allows

FW: need query help

2001-11-28 Thread Kenny
I am currently running an online golf tournament on an NT server with an Access database and asp pages. I have access to a Unix server that supports asp script and mySQL database and I'd like to move my tour site (for several reasons) but the SQL statements don't all work. The following statement

FW: need query help

2001-11-28 Thread Kenny
I am currently running an online golf tournament on an NT server with an Access database and asp pages. I have access to a Unix server that supports asp script and mySQL database and I'd like to move my tour site (for several reasons) but the SQL statements don't all work. The following statement

Need query help

2001-10-31 Thread mickalo
Hello all, I have 3 tables I need to join to extract certain data base on the acct_days in the active table '6' days. QUERY: SELECT CONCAT(m.fname,' ',m.lname) AS name, m.email,m.zip,p.paytype,p.event,p.paydate FROM members m LEFT JOIN payhistory p ON p.memid = m.memid LEFT JOIN active a ON

RE: Need query help

2001-10-31 Thread Quentin Bennett
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 4:22 p.m. To: [EMAIL PROTECTED] Subject: Need query help Hello all, I have 3 tables I need to join to extract certain data base on the acct_days in the active table '6' days. QUERY: SELECT CONCAT