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 =
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:
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?
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
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