>I installed 5.0 and 5.1-beta on three different system (all are Fedora Core
>4), and each time when I use the command-line client, I can not use the
>familiar up-arrow feature that normally lets you scroll through queries issued
>during previous command-line sessions. My history is completely
+---+
What is wrong?
Additional Info:
If I change the comparison in the where clause, the SQL errors
disappear. But, of course, the query delivers a (logically) wrong result.
Mysql is 5.0.1alpha-snapshot on Windows XP.
I do not remember this problem in 5.0.0alpha
Regards
Helmut
--
MySQL Genera
The server (our development test server) is running Red Hat 8.0 and Mysql
4.1. The remote test server to which we're trying to transfer data is
running Red Hat 7.3 and Mysql 4.013.
David Christensen
Brokers International, Ltd.
1200 E Main St
PO Box 160
Panora, IA 50216
(800) 362-1097 or (641) 75
#x27;$
> state2','$agency','$bmothername','$mage','$monthmdob','$daymdob','$yearm
> dob','$bfathername','$fage','$monthfdob','$dayfdob','$yearfdob','$commen
> ts'
27;$fage','$monthfdob','$dayfdob','$yearfdob','$commen
ts','$signupdate')";
$signupdate is the one that I wanted to be the timestamp obviously!!!
LOL
Thanks in advance for any help someone can give me
-Original Message-
From: Rober
At 12:18 -0800 2001/12/14, Steve Osborne wrote:
> Timestamp additional info:
>
> INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
>VALUES ('$NameID','1','$RegNumc','NULL');
>
>ProdRegDate is the field that I want to t
Thanks, it is working perfectly as described
Steve
> Don't reference the timestamp column at all in your INSERT (or future
> UPDATE) statements and the timestamp should update just fine on its own.
>
> i.e.
> INSERT INTO Owners (NameID,ProductsKey,RegNum)
> VALUES ('$NameID','1','$RegNum
-+---++
|1 | World | 20011214194555 |
+--+---++
1 row in set (0.00 sec)
mysql>
Regards
M
-Original Message-
From: Steve Osborne [mailto:[EMAIL PROTECTED]]
Sent: 14 December 2001 20:16
To: MySQL (E-mail)
Subject: t
You are inserting the string 'NULL'
Don't include it at all in the insert.
Steve Osborne wrote:
> Timestamp additional info:
>
> INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
> VALUES ('$NameID','1','$RegNumc','NULL
default for a timestamp column - it is always
NULL (which displays as '00').
HTH,
--
coop
On Fri, 2001-12-14 at 15:16, Steve Osborne wrote:
>
> Timestamp additional info:
>
> INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
> VALUES ('$NameID&#
mysql (filter)
Timestamp additional info:
INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
VALUES ('$NameID','1','$RegNumc','NULL');
ProdRegDate is the field that I want to timestamp. (Again, I've t
Timestamp additional info:
INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
VALUES ('$NameID','1','$RegNumc','NULL');
ProdRegDate is the field that I want to timestamp. (Again, I've tried
passing '', NULL, and 'NULL').
Thanks for all your suggestions, I apparently had a brain cramp.
Problem solved.
Thanks,
Steve
- Original Message -
From: "Steve Osborne" <[EMAIL PROTECTED]>
To: "MySQL (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, December 07, 2001 1:36 PM
Subject: Query
I am trying to validate a user in a login form.
There are 3 things that must be true.
User login name = email_login (from User table)
User password = password (from User Table)
User must be active: activeuser (from Owner table) = 'Y'
The Owner table does have a common field with the User Table
Hi. I'll be more precise: I'm trying to compile MySQL 3.23.32
it under Amiga, with EGCS 2.91.66 using some kind of UNIX emulation.
I've already ported other programs like Lynx, Yacas, MUD/IRC clients...
I've found that F_TO_EOF is defined as 0L in mysql/include/my_global.h,
but
15 matches
Mail list logo
