grKumaran wrote:
Hello Folks,
It is great help. Thank you all and specially for Michael and Shawn. It
does work properly in 4.1.9-max. But I think, LAST_DAY function does not
availble in old MySQL version 4.0.??, so there I have problem, actually our
webserver is still in that version. So I
Dobromir Velev wrote:
Hi,
The following query will probably work but I think it will be easier to pass
the minimum date from your application.
SELECT * FROM t WHERE (year(dt)=year(Now()) and dt(year(dt)=year(Now())-1 and month(dt)>month(Now()))
Also you might want to check the other Date and
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote on 10/18/2005 12:01:50 PM:
- Original Message -
From: "grKumaran" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, October 18, 2005 16:08
Subject: query help
: Hello,
:
: CREATE TABLE t (
: dt datetime
: )
:
: Please assume this is the table st
: > : Hello,
: > :
: > : CREATE TABLE t (
: > : dt datetime
: > : )
: > :
: > : Please assume this is the table structure and contains thousands of
: > records.
: > : And I want to list them only last 12 months (that mean last 1 year)
: > records
: > : exactly.
: > :
: > : For that I tried using th
Hi,
The following query will probably work but I think it will be easier to pass
the minimum date from your application.
SELECT * FROM t WHERE (year(dt)=year(Now()) and dtmonth(Now()))
Also you might want to check the other Date and Time functions
http://dev.mysql.com/doc/refman/4.1/en/date-and
[EMAIL PROTECTED] wrote on 10/18/2005 12:01:50 PM:
> - Original Message -
> From: "grKumaran" <[EMAIL PROTECTED]>
> To:
> Sent: Tuesday, October 18, 2005 16:08
> Subject: query help
>
>
> : Hello,
> :
> : CREATE TABLE t (
> : dt datetime
> : )
> :
> : Please assume this is the table str
our example is using 2 table.
>
> ~Elle~
>
> -Original Message-
> From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 04, 2004 11:08 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: FW: query
>
> Oh, so what you're loo
I only have 1 table for this job. Your example is using 2 table.
~Elle~
-Original Message-
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 11:08 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: FW: query
Oh, so what you're looking for a a
Oh, so what you're looking for a a find duplicates query (as MS Access calls
it). That's something like this (I'm rusty, so you might have to debug).
SELECT fname, lname, etc FROM my_table as table1, my_table as table2
WHERE table1.fname = table2.fname
AND table1.lname = table2.lname
...etc...
A
> Hi all,
>
> I am writing an application that requires my application to possibly
> update the length of a char field while data is being imported into the
> db. First, can I update the size/type of a column using UPDATE? Would
> someone be willing to give me an example?
You will want to lo
EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, September 24, 2002 6:20 PM
Subject: Re: Fw: Query to update column length
> On Tue, Sep 24, 2002 at 05:56:23PM -0400, Shaun Bramley wrote:
> > Hi all,
> >
> > I am writing an application that requires my ap
On Tue, Sep 24, 2002 at 05:56:23PM -0400, Shaun Bramley wrote:
> Hi all,
>
> I am writing an application that requires my application to possibly update
> the length of a char field while data is being imported into the db. First,
> can I update the size/type of a column using UPDATE? Would so
12 matches
Mail list logo
