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 check:
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 knows what
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
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 once