On Tue, 2003-09-02 at 15:45, Sambit Nanda wrote:
> Hi Can any one aswer my question pls ?
>
>
>
> --- Sambit Nanda <[EMAIL PROTECTED]> wrote:
> > I want to keep Multi instance of DB and log in
> > different file system, I know i can keep or
> > configure
> > multi my.cnf but i am not sure how t
Hi,
I thought that they were in /var/lib/mysql if I am not wrong !
Cheers,
Aly.
On Tue, 2003-09-02 at 14:45, Sambit Nanda wrote:
> Hi Can any one aswer my question pls ?
>
>
>
> --- Sambit Nanda <[EMAIL PROTECTED]> wrote:
> > I want to keep Multi instance of DB and lo
Hi Can any one aswer my question pls ?
--- Sambit Nanda <[EMAIL PROTECTED]> wrote:
> I want to keep Multi instance of DB and log in
> different file system, I know i can keep or
> configure
> multi my.cnf but i am not sure how to configure
> that,
> and what should i define for different datadi
TED]>
Sent: Tuesday, February 12, 2002 11:25 AM
Subject: Re: MySQL Question
> Jake,
>
> On Tuesday 12 February 2002 11:00, you said something about:
> > Yes, I'm using PHP.
> >
> > I tried this, but then it doesn't display the way I want it to. How can
I
>
Jake,
On Tuesday 12 February 2002 11:00, you said something about:
> Yes, I'm using PHP.
>
> I tried this, but then it doesn't display the way I want it to. How can I
> break apart what mysql spits out back into the year, month, day, time
> variables?
>
In PHP you could try using the "split" or
AIL PROTECTED]>
Sent: Tuesday, February 12, 2002 8:11 AM
Subject: Re: MySQL Question
> > From: "Jake McHenry" <[EMAIL PROTECTED]>
> >
> > This is exactly what I'm doing! Here is my query ..
> >
> > select * from $dbtable where 1 and ye
On Mon, 2002-02-11 at 19:43, Brian Ashe wrote:
> David Talkington,
>
> On Monday 11 February 2002 08:35, you said something about:
> > Jake McHenry wrote:
> > >Where I'm running into a problem is on the output screen. I've tried
> > >sorting by day, time, and ampm, and all of these, but I'm still
-
From: Jake McHenry [mailto:[EMAIL PROTECTED]]
Sent: 12 February 2002 14:37
To: [EMAIL PROTECTED]
Subject: Re: MySQL Question
This is exactly what I'm doing! Here is my query ..
select * from $dbtable where 1 and year = '$inyear' and month like
'$inmonth' and day =
5:00 AM test
> 8:00 PM test
> 9:00 AM test
> 9:30 AM test
>
> Check All
> Password:
>
>
> Thanks,
> Jake
>
>
> - Original Message -
> From: "Pieter De Wit" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTE
> From: "Jake McHenry" <[EMAIL PROTECTED]>
>
> This is exactly what I'm doing! Here is my query ..
>
> select * from $dbtable where 1 and year = '$inyear' and month like
> '$inmonth' and day = '$inday' order by time, ampm
>
> And when I display the results, it is putting a event of 10:00 am or
Jake
- Original Message -
From: "Pieter De Wit" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 11, 2002 11:26 PM
Subject: Re: MySQL Question
> Hello Jake,
>
> 1) What is the query that you are using ?
> 2) Why don't you use a
On Lun 11 Feb 2002 23:18, you wrote:
>
> Why don't you use the SQL types for dates and times and then MySQL
> will give you the correct ordering of times when you do an "order by"
> clause.
I got to modify code that has a timestamp put in a varchar field, and the guy
does the order by on that fi
Hello Jake,
1) What is the query that you are using ?
2) Why don't you use a date/time field (can't remeber if mysql has one :) )
Your query should look something like this :
select * from order by time,ampm;
Cheers,
Pieter
- Original Message -
From: Jake McHenry
To: RedHat List
Sen
When using a date field the values are stored as 2002-02-11 you should be
able to query for a specific date (SELECT * FROM myTable WHERE myDate LIKE
"2002-02-%" ORDER BY myDate) or query for specific portions of the date
using operators like month(myDate) = 02.
HTH
> The way my calendar is set u
CTED]>
Sent: Monday, February 11, 2002 9:18 PM
Subject: Re: MySQL Question
> > From: "Jake McHenry" <[EMAIL PROTECTED]>
> >
> > I know this isn't the right place for this, but I'm hoping someone can =
> > help me out. I have created a database, b
> From: "Jake McHenry" <[EMAIL PROTECTED]>
>
> I know this isn't the right place for this, but I'm hoping someone can =
> help me out. I have created a database, basically an online calendar, =
> and I have the following fields in my table..
>
> id int(10) auto_increment
> year int(4)
> mont
Ok, sorry, type-o, 10:00 am or pm is coming before 2-9 am or pm, get it?
Jake
- Original Message -
From: "David Talkington" <[EMAIL PROTECTED]>
To: "RedHat List" <[EMAIL PROTECTED]>
Sent: Monday, February 11, 2002 8:35 PM
Subject: Re: MySQL Question
David Talkington,
On Monday 11 February 2002 08:35, you said something about:
> Jake McHenry wrote:
> >Where I'm running into a problem is on the output screen. I've tried
> >sorting by day, time, and ampm, and all of these, but I'm still
> >running into the same problem. The problem is that an e
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jake McHenry wrote:
>Where I'm running into a problem is on the output screen. I've tried
>sorting by day, time, and ampm, and all of these, but I'm still
>running into the same problem. The problem is that an entry of time
>10:00 am is coming before
19 matches
Mail list logo
