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
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
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
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 have a table named table1 structure is
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-+---+
| name | varchar(50) | NO | PRI | | |
| gender |
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
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
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
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
-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
10 matches
Mail list logo