List:General Discussion« Previous MessageNext Message »
From:mwahal Date:February 5 2003 11:20pm
Subject:Data being not inserted in the table inspite of success from mysql
View as plain text  
>Description:
	I'm adding the data in the tables via batch mode. I see that the sql INSERT statement
	returns success. But when I query the data, I get empty set.
>How-To-Repeat:

	--------------
	create  table if not exists CBI (date DATE not null, close DECIMAL(10,2), high
DECIMAL(10,2), low DECIMAL(10,2), volume MEDIUMINT, yest DECIMAL(10,2), PRIMARY KEY date
(date))
	--------------

	Query OK, 0 rows affected (0.00 sec)

	--------------
	insert ignore into CBI Values('2003-02-05','31.2000','31.3500','31.0500','350','31.3500')
	--------------

	Query OK, 1 row affected (0.02 sec) <====== 1 row is added

	++++++++++++++++++ now the query result +++++++++++++++++

	--------------
	select * from   CBI where date='2003-02-05'
	--------------

	Empty set (0.00 sec)



>Fix:

>Submitter-Id:	<submitter ID>
>Originator:	Mudit Wahal
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:	Insert failure
>Severity:	
>Priority:	
>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 23 hours 35 min 54 sec

Threads: 1  Questions: 1844605  Slow queries: 0  Opens: 249225  Flush tables: 18  Open
tables: 64  Queries per second avg: 7.156
>Environment:
	
System: Linux bp6 2.4.20 #8 Wed Jan 29 09:50:06 PST 2003 i686 unknown
Architecture: i686

Some paths:  /home/wmudit/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc'  CFLAGS='-O3 -mpentium '  CXX='gcc'  CXXFLAGS='-O3 -mpentium 
-felide-constructors'  LDFLAGS='-static'
LIBC: 
lrwxrwxrwx    1 root     root           13 Jan 24 18:13 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x    1 root     root      1282588 Sep  4  2001 /lib/libc-2.2.4.so
-rw-r--r--    1 root     root     27304836 Sep  4  2001 /usr/lib/libc.a
-rw-r--r--    1 root     root          178 Sep  4  2001 /usr/lib/libc.so
Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=Official
MySQL-max binary' --with-extra-charsets=complex --with-server-suffix=-max
--enable-thread-safe-client --enable-assembler --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --disable-shared --with-berkeley-db --with-innodb

Thread
Data being not inserted in the table inspite of success from mysqlmwahal6 Feb
  • Re: Data being not inserted in the table inspite of success from mysqlDan Nelson7 Feb