Check your indexes. 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 ><[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
