On Wednesday 05 February 2003 06:02, Mudit Wahal wrote: > >Description: > > I have a delete statement and an insert statment. I'm replacing a line but > I want to make sure, that its deleted. The insertion is successful as per > sql batch output. But when I dump the data from the table, there is no > record for the date ! Seems like delete operation happened after the > insert.
[skip] It works fine for me on v4.0.10: mysql> select * from MSFT where date = '2003-02-04'; +------------+-------+-------+-------+--------+-------+ | date | close | high | low | volume | yest | +------------+-------+-------+-------+--------+-------+ | 2003-02-04 | 47.32 | 47.94 | 46.88 | 406440 | 47.80 | +------------+-------+-------+-------+--------+-------+ 1 row in set (0.01 sec) As I can see you are using version 4.0.1 of MySQL, it's a bit outdate version and many bugs were fixed since that time. So, upgrading MySQL server is highly recommended. > >Fix: > > > > > >Submitter-Id: <submitter ID> > >Originator: Mudit Wahal > >Organization: > > > >MySQL support: none > >Synopsis: Insert after delete fails. > >Severity: critical > >Priority: high > >Category: mysql > >Class: > >Release: mysql-4.0.1-alpha-max (Official MySQL-max binary) > >Server: /usr/local/mysql/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for > > pc-linux-gnu on i686 > > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > and you are welcome to modify and redistribute it under the GPL license > > Server version 4.0.1-alpha-max > Protocol version 10 > Connection Localhost via UNIX socket > UNIX socket /tmp/mysql.sock > Uptime: 2 days 4 hours 15 min 23 sec > > Threads: 1 Questions: 1301712 Slow queries: 0 Opens: 182971 Flush > tables: 11 Open tables: 64 Queries per second avg: 6.919 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
