1. delete any whitespaces between the column name and the "=" and the
values.
2. try using
columnname="value"
That works for me.
On Thursday, May 16, 2002, at 09:59 AM, Daniel Lim wrote:
>
> Hi there,
> I have MySql version: 3.23.36 running on RedHat 7.1, it has been
> working fine for sometimes until a day ago when the INSERT into for new
> record appeared to return OK status but upon verifying the record isn't
> there?
>
> This is an example;
>
> To insert new record:
>
> mysql> INSERT into userdata SET loginname =
> 'test3',lastname='test3',firstname='Testing 3',middlename='Three';
> Query OK, 1 row affected (0.00 sec)
>
> verify inserted record:
>
> mysql> select loginname,firstname,middlename from userdata where
> loginname = "test3" ;
> Empty set (0.04 sec)
>
> mysql>
>
> Any suggestion is much appreciated.
> Thanks in advance
>
> Regards,
> Daniel Lim
> UNIX Systems Administartor
> NSW Dept. of Public Works
> Sydney, Australia
> This e-mail message (and attachments) is confidential, and / or
> privileged and is intended for the use of the addressee only. If you are
> not the intended recipient of this e-mail you must not copy, distribute,
> take any action in reliance on it or disclose it to anyone. Any
> confidentiality or privilege is not waived or lost by reason of mistaken
> delivery to you. DPWS is not responsible for any information not related
> to the business of DPWS. If you have received this e-mail in error
> please destroy the original and notify the sender
>
> For information on services offered by DPWS, please visit our website
> at www.dpws.nsw.gov.au
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <mysql-unsubscribe-
> [EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
