> Isn't 'key' a reserved word?
Yeah... *slaps forhead*
That's why I "always" use 'id' as my key column name and "always" quote my
column names.
Thanks for the quick response!
nik
( sql query )
-
Before posting, please che
[snip]
tbl
keyint, primary key, auto increment
valint
I've inserted several dummy values so that my table looks like this:
key val
150
2100
3150
4200
I can successfully run this query:
UPDATE tbl SET val = val + 1
but THIS query fails:
UPDATE tbl SET val = val
Hello, I'm new to the mailing list.
I have a simple table:
tbl
keyint, primary key, auto increment
valint
I've inserted several dummy values so that my table looks like this:
key val
150
2100
3150
4200
I can successfully run this query:
UPDATE tbl SET val = va
You don't supply enough information to even guess what the problem is.
What hardware/software are you running?
What is the MySQL version?
Was this a binary package, or did you compile it?
What compiler did you use?
What are you using to do the update?
How do you know it failed?
Did you check the l
Jesús Gómez wrote:
> I have a problem with the update querys.
>
> When i do a update in a table,it fails.
> If i do this query two or three times it works fine.
> There isn´t a table problem because this error happens in every tables.
>
> The select and insert querys work fine.
>
> Anybody kno
I have a problem with the update querys.
When i do a update in a table,it fails.
If i do this query two or three times it works fine.
There isn´t a table problem because this error happens in every tables.
The select and insert querys work fine.
Anybody knows what could be the problem?
Petter Larsson writes:
> Hi,
>
> I recantly upgraded from 3.22.32 to 3.23.35 using an rpm from
> www.mysql.com.
> My platform: Redhat Linux 2.2.14 i686
>
> The problem is now that UPDATE do not always succed. I get a query OK
> but no
> update is done unless the same query is issued
Hi,
I recantly upgraded from 3.22.32 to 3.23.35 using an rpm from
www.mysql.com.
My platform: Redhat Linux 2.2.14 i686
The problem is now that UPDATE do not always succed. I get a query OK
but no
update is done unless the same query is issued once again.
This problem is not constant but rath
