There are three kinds of people in this world;
those who can count, and those who can't.
Ray wrote:
You are inserting 6 values into 7 fields, so it fails.
looks like a 6 field table to me
create table if not exists MSFT (date DATE not null, close
DECIMAL(10,2), high DECIMAL(10,2), low DEC
> You are inserting 6 values into 7 fields, so it fails.
looks like a 6 field table to me
create table if not exists MSFT (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));
1) date
2) close
3) high
4) l
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, ther
]
Subject: insert after delete is not atomic
>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, the
You are inserting 6 values into 7 fields, so it fails.
You don't see the failure because you are doing an insert ignore.
You are also inserting numbers with 4 digits right of the decimal, where
you have specified 2.
Mudit Wahal wrote:
Description:
I have a delete statement and an insert st
This doesn't directly address the problem you are having, but it
probably is a better way of doing it. Have you looked into using the
REPLACE function instead of a delete and insert. It should be faster and
more reliable.
I assume since you are using the ignore statement in your insert that
yo
>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
