Hi all,

When I try to use SQL to update records, it says there is an error in my syntax, but I don't see it.

Here is what I want to do. I have a table called users with a column called techs. I want to query the techs field for certain names and change them to other names.

So, here is the query I wrote:

UPDATE users
SET tech = 'Tech 1'
WHERE tech = 'Tech 2'

This should change all "Tech 1" to "Tech 2" in the users table.

However, when I enter thee command, I get the error "UPDATE" is a reserved keyword."

So, how do I update a bunch of records?

(It is probably pretty obvious, but I am really stuck, and not a SQL guy...."

Hi Thiudans,
Only SELECT queries are supported by the Query Designer at the moment. This may be possible using scripts (without SQL) but this is less efficient approach as more data needs to be fetched to the client side.

I propose to add these wishes at bugs.kde.org:
- Add support for UPDATE queries in Designer
- Add support for DELETE queries in Designer
- Add support for CREATE queries in Designer

jstaniek wrote:Hi Thiudans,
Only SELECT queries are supported by the Query Designer at the moment. This may be possible using scripts (without SQL) but this is less efficient approach as more data needs to be fetched to the client side.

I propose to add these wishes at bugs.kde.org:
- Add support for UPDATE queries in Designer
- Add support for DELETE queries in Designer
- Add support for CREATE queries in Designer

Thanks. I will lookk into the scripting option.