El Jue 28 Ago 2003 17:20, Ignatius Reilly escribió:
> Well, you're certainly right (except I didn't get the meaning of 'FS' -
> anything obscene?). However:
File System.
> 1. The job of this ML is to help people get things done
> 2. For criticisms concerning the design of MySQL, you may get bette
Beckman"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 9:37 PM
Subject: Re: [PHP-DB] MySQL, PHP or ghost?
El Jue 28 Ago 2003 11:25, Ignatius Reilly escribió:
> Well, it IS logical provided one is aware of the rules of the game,
> meaning, as you rig
El Jue 28 Ago 2003 11:25, Ignatius Reilly escribió:
> Well, it IS logical provided one is aware of the rules of the game,
> meaning, as you rightly point out, that MySQL does not reject SQL
> statements for incorrect values, but attempts at converting them "at any
> price". I have no clue whether i
kman"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 2:36 PM
Subject: Re: [PHP-DB] MySQL, PHP or ghost?
El Mié 27 Ago 2003 11:34, Ignatius Reilly escribió:
> Hmmm...
>
> You have a point; the doc is not quite clear.
>
> "Illegal YEAR
El Mié 27 Ago 2003 11:34, Ignatius Reilly escribió:
> Hmmm...
>
> You have a point; the doc is not quite clear.
>
> "Illegal YEAR values are converted to "
>
> My understanding is that any illegal value will be first converted into
> '', then into the corresponding year inside the 1901-2155
e logical. I have no quarrel with this behaviour.
Ignatius
_
- Original Message -
From: "Peter Beckman" <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 27, 2003 4:13 PM
hing in the way of an
explanation.
I'm just as puzzled by this as Peter is/was and I'm just interested in the
explanation. I'm not trying to start an argument here.
Rich
> -----Original Message-
> From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August
On Wed, 27 Aug 2003, Ruprecht Helms wrote:
> you have chosen a wrong format. The format for year is . With string
> the field years don't know what to do.
Right -- and if it doesn't know what to do, why would it insert a value
that isn't correct and not give me an error? It does give a war
er Beckman [mailto:[EMAIL PROTECTED]
Sent: 27 August 2003 15:29
To: Griffiths, Daniel
Subject: RE: [PHP-DB] MySQL, PHP or ghost?
On Wed, 27 Aug 2003, Griffiths, Daniel wrote:
> mysql will default to 2000 for a year value if you pass it "" as an entry
> because it will accept short
Hi Peter Beckman,
> Seems that either I don't understand mysql, or something.
>
> My table, with the non-important things removed...
>
> mysql> explain plate;
>
> +-+---+--+-+-++
> | Field | Type
Peter, et al --
...and then Peter Beckman said...
%
% On Wed, 27 Aug 2003, David T-G wrote:
%
% > Looks like it, though I admit that the manual doesn't adequately explain
% > your results. Check out section 6.2.2.4 for details.
%
% I did; see my previous (moments ago) email on my read on that
On Wed, 27 Aug 2003, David T-G wrote:
> Looks like it, though I admit that the manual doesn't adequately explain
> your results. Check out section 6.2.2.4 for details.
I did; see my previous (moments ago) email on my read on that manual
section.
> % So my assumption is that if I insert with y
its nothing to do with php as your working from the shell in your eg.
mysql will default to 2000 for a year value if you pass it "" as an entry because it
will accept short values for the years this century, eg pass it "1" and it'll give you
2001, so it thinks "" is nothing. if you want to defau
On Wed, 27 Aug 2003, Ignatius Reilly wrote:
> Read the MySQL manual.
Hmmm, I thought I did. 6.2.2.4:
Illegal YEAR values are converted to .
> "0" value is interpreted as 2000.
> Your empty string is converted to an integer, thus 0.
What confuses me (what I can't find) is why a quoted emp
Peter --
...and then Peter Beckman said...
%
% Seems that either I don't understand mysql, or something.
Looks like it, though I admit that the manual doesn't adequately explain
your results. Check out section 6.2.2.4 for details.
%
% My table, with the non-important things removed...
...
%
Read the MySQL manual.
"0" value is interpreted as 2000.
Your empty string is converted to an integer, thus 0.
HTH
Ignatius
_
- Original Message -
From: "Peter Beckman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 27, 2003 3:39 AM
Subject: [P
16 matches
Mail list logo