Thank you for the idea. It fixed my date problem, but my numeric column is
still 0 and NOT "NULL." Here's what I did:
create table a (
d date default null,
e smallint default null );
CREATE TEMPORARY TABLE tmp (
d TEXT not NULL,
e TEXT not NULL );
LOAD DATA LOCAL INFILE "c:\
> Stupid filter fodder: sql,query,queries,smallint
> > -Original Message-
> > From: Dean Householder [mailto:[EMAIL PROTECTED]]
>
> > The problem is with the new glibc-2.2.5-40 package released
> > on October 3,
> > 2002. Apparently its a known issue, and people are aware of
> > it. T
David,
Wednesday, November 06, 2002, 10:00:45 PM, you wrote:
DAF> - Original Message -
DAF> From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
DAF> To: <[EMAIL PROTECTED]>
DAF> Sent: Wednesday, November 06, 2002 11:47 AM
DAF> Subject: re: Problem creating InnoDB tables.
>> David,
>> Tuesda
Hello Lance,
Wednesday, October 23, 2002, 4:16:16 PM, you wrote:
>>LU> I have /tmp symlinked to /var/tmp, and /var is a writable partition,
>>while /
>>LU> is readonly. When / is readonly mysqld is not able to run.
>>
>>LU> I've tracked down the problem to the safe_mysqld script. The problem is
At 03:29 PM 10/23/02 +0300, Egor Egorov wrote:
Lance,
Wednesday, October 23, 2002, 3:23:10 AM, you wrote:
LU> I have /tmp symlinked to /var/tmp, and /var is a writable partition,
while /
LU> is readonly. When / is readonly mysqld is not able to run.
LU> I've tracked down the problem to the saf
Lance,
Wednesday, October 23, 2002, 3:23:10 AM, you wrote:
LU> I have /tmp symlinked to /var/tmp, and /var is a writable partition, while /
LU> is readonly. When / is readonly mysqld is not able to run.
LU> I've tracked down the problem to the safe_mysqld script. The problem is it
LU> does:
LU>
Tam,
Thursday, July 25, 2002, 7:35:20 PM, you wrote:
T> Hi Victoria,
T> Thanks. Does this mean in the future the -max version would be merged into
T> one release or just for the 4.0.2a??
Most likely yes.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This ema
PROTECTED]
Subject: Re: RE: Problem downloading MySQL4.0.2a for windows
Tam,
Tuesday, July 23, 2002, 9:38:17 PM, you wrote:
T> Hi Victoria,
T>Do you know when the 4.0.2a-MAX would be available for download then?
T> Thank you.
Use mysql-win-4.0.2-alpha.zip instead. It the same as
Tam,
Tuesday, July 23, 2002, 9:38:17 PM, you wrote:
T> Hi Victoria,
T>Do you know when the 4.0.2a-MAX would be available for download then?
T> Thank you.
Use mysql-win-4.0.2-alpha.zip instead. It the same as with -max.
--
For technical support contracts, goto https://order.mysql.com/?r
Neville,
Tuesday, May 28, 2002, 11:23:06 AM, you wrote:
NL> this is the error message I get
NL> "Can't connect to local MySQL server through socket
NL> '/var/lib/mysql/mysql.sock' (2)"
NL> Why is this ?
Check permissions on the MySQL datadir. Look also into the .err file
in the MySQL data dir
At 23:34 -0500 4/20/02, Darren Vollmer wrote:
> > >Both files are world readable.
>>
>> How do you know this?
>
>Because FTP tells me they are.
>
>>
>> Also, when you say "client machine", what do you mean? In particular,
>> are the web server and the MySQL servers running on the same machine
> >Both files are world readable.
>
> How do you know this?
Because FTP tells me they are.
>
> Also, when you say "client machine", what do you mean? In particular,
> are the web server and the MySQL servers running on the same machine?
>
Client machine is the machine running the webserver and
Subject: Fw: Re: problem with load data local infile
>
> - Original Message -
> From: "Fiasco" <[EMAIL PROTECTED]>
> To: "Paul DuBois" <[EMAIL PROTECTED]>
> Sent: Saturday, April 20, 2002 7:28 PM
> Subject: Re: Re: problem with load data local infile
>
&g
Message -
>From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Saturday, April 20, 2002 6:14 AM
>Subject: Re: Re: problem with load data local infile
>
>
>> Darren,
>> Saturday, April 20, 2002, 1:23:54 PM, you wrote:
>
Darren,
Saturday, April 20, 2002, 2:34:06 PM, you wrote:
DV> The file is in a world readable directory tree.
DV> Shouldn't the LOCAL qualifier make mysql read the file from the client
DV> running and not the host?
DV> I tried to LOAD DATA LOCAL INFILE on using the name (and no path) of a mysql
server?
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 20, 2002 6:14 AM
Subject: Re: Re: problem with load data local infile
> Darren,
> Saturday, April 20, 2002, 1:23:54 PM, you wrote:
>
Darren,
Saturday, April 20, 2002, 1:23:54 PM, you wrote:
DV> The file does exist. The file and its directory are 0777 permission.
Such permissions are setting on all dirs, that contain path to your
dir?
Don't forget that you should have permissions to go through dirs ...
DV> Darren
--
For
12, 2002 11:19 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Re: Problem with MySQL, ODBC, MS Access
>
>
>
>
> Hi,
>
> Can anyone help me please? I´m writing my diploma and this database is my
> project. I´m running out of time and when this problem doesn´
t; To: [EMAIL PROTECTED]; muyuan; [EMAIL PROTECTED]
> Subject: Re: Re: Problem with MySQL, ODBC, MS Access
>
>
>
>
> Sorry I´ve tried it but I didn´t succeed. When writing: update
> tPruefBesch set fdatetime = fTimestamp, datetime and timestamp wont have
> the same value. I don´t
Sorry I´ve tried it but I didn´t succeed. When writing: update
tPruefBesch set fdatetime = fTimestamp, datetime and timestamp wont have
the same value. I don´t know why, but there is the same fault.
I´ve created a small database to show my problem.
That´s my table in MySQL 3.23.41.
create tabl
> "Arjen" == Arjen G Lentz <[EMAIL PROTECTED]> writes:
Arjen> Hi,
Arjen> - Original Message -
Arjen> From: "AJ" <[EMAIL PROTECTED]>
>> > > Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686)
>> > > The problem that has cropped up I have is that in all GROUP BY column
>> > > DESC
>>
Hi,
- Original Message -
From: "AJ" <[EMAIL PROTECTED]>
> > > Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686)
> > > The problem that has cropped up I have is that in all GROUP BY column
DESC
> > > statements, the DESC is now not being recognized, and the query is being
> > > returned
Can you please elaborate on how can I correct this problem. I have windows nt on my
machine. OR is there and problem with the installation of my sql
bye
p
- Original Message --
"indrek siitan" <[EMAIL PROTECTED]> wrote:
To:"Prachi Nadgouda" <[EMAIL PROTECTED]>, <[EMAIL
Hi,
> Tried doing isamchk on the .ISM files and got that following error
> The Exception Integer division by zero
> (0xc094) occured in the application at the location 0x0040224a.
getting such errors usually means you've got hardware (bad memory?)
or some serious software installation probl
Tried doing isamchk on the .ISM files and got that following error
The Exception Integer division by zero
(0xc094) occured in the application at the location 0x0040224a.
thanks
- Original Message --
"indrek siitan" <[EMAIL PROTECTED]> wrote:
To:"Prachi Nadgouda" <[E
25 matches
Mail list logo
