Need help with my sql string. I'm t 2

[mikecx]

Need help with my sql string. I'm trying to INSERT INTO users (wd, wh, ld, pg, sl) VALUES (1, 1, 1, 1, 1) WHERE username = 'username' and it wont let me. Help!!

 

[r937]

INSERT VALUES does not allow a WHERE clause

perhaps you want

INSERT INTO users (wd, wh, ld, pg, sl, username)
VALUES (1, 1, 1, 1, 1, 'username')


rudy

 

[travisbrown]

Are you tryin to insert a new record, or update an existing one? You can use WHERE with UPDATE queries.

 

[mikecx]

travis, you hit it right on the head. A friend of mine just pointed out that you can't insert over top . Seems common sense but i'm tired. It's now an update string and working perfectally. Thanks