Re: Data being not inserted in the table inspite of success from mysql

2003-02-08 Thread Dan Nelson
In the last episode (Feb 05), [EMAIL PROTECTED] said: > 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

Data being not inserted in the table inspite of success from mysql

2003-02-06 Thread mwahal
>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),