T() and HAVING to do the filtering.
> -Original Message-
> From: Daevid Vincent [mailto:dae...@daevid.com]
> Sent: Monday, July 08, 2013 7:57 PM
> To: mysql@lists.mysql.com
> Subject: RE: Need query to determine different column definitions across
> tables
>
>
> -Original Message-
> From: Daevid Vincent [mailto:dae...@daevid.com]
> Sent: Monday, July 08, 2013 2:11 PM
> To: mysql@lists.mysql.com
> Subject: Need query to determine different column definitions across
tables
>
> I'm noticing that across our several databases and hundreds of tables
See if you like this:
SELECT TABLE_SCHEMA as db, TABLE_NAME, COLUMN_NAME,
CHARACTER_SET_NAME, COLUMN_TYPE
FROM `COLUMNS`
ORDER BY 3,4,5;
You might be able to embellish on it to avoid consistent definitions, etc.
> -Original Message-
> From: Daevid Vincent [mailto:dae...
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: Need Query Help
>
> H
Yup! That's it!
Thanks Dan.
;)
The link is really helpful. I was looking for it on mysql but was able
to find. Looks like I didn't try hard. :)
-afan
Dan Buettner wrote:
Afan, you'll need to have a date and time column in the database storing a
"created at" value, that is set on INSERT and
Afan, you'll need to have a date and time column in the database storing a
"created at" value, that is set on INSERT and then not changed.
Assuming you have such a column - let's call it "created_at" - you can run
queries like this:
/* to get count of records created on Mondays */
SELECT COUNT(*)
Hi,
You need to self-join payhistory along the lines of
select p1.* from payhistory p1, payhistory.p2 where
p1.payid = p2.payid and p1.paydate = max(p2.paydate)
Something like that, anyway - I know I had to fiddle around a bit to get a
similar think going.
Hope this help
Quentin
-Origina
Some thing like this mite work?
delete from b
where id.a != id.b;
Simon
-Original Message-
From: Lyubomir Simich [mailto:[EMAIL PROTECTED]]
Sent: 18 September 2001 16:15
To: [EMAIL PROTECTED]
Subject: need query
Hello,
May I use a query like this?
DELETE FROM b WHERE id NOT IN (
10 matches
Mail list logo
