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
alr
Thanks Rick for your reply,
Here i am asking about logic to perpare query or whole query itself.
--Anupam
From: Rick James
To: Anupam Karmarkar ; "mysql@lists.mysql.com"
Sent: Wednesday, 20 June 2012 10:52 PM
Subject: RE: Need Query H
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:
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
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 t
I have a table named table1 structure is
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-+---+
| name | varchar(50) | NO | PRI | | |
| gender | enum('f','m')
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
-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:
SEL
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 a.m
10 matches
Mail list logo
