Re: ERROR 1193 (HY000): Unknown system variable
Posted by: Todd Farmer
Date: August 07, 2015 09:30AM

Hi Macamba,

I'm a little confused about what this statement aims to do - can you clarify? It looks like you want to do an UPDATE statement? If so, the query would look like:

UPDATE
projects
SET
projectnumber=100101,
project='TimeKeeper',
activity='DAOTest',
per_number=100101,
day='2015-04-10',
worked_time='04:15:00'
WHERE
pro_id=2;

Maybe I've misunderstood what you're trying to do, though. I'm pretty sure you don't meant to use the SET command, which is intended to manipulate variables rather than table data.

https://dev.mysql.com/doc/refman/5.6/en/set-statement.html

Hope that helps!

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/

Options: ReplyQuote


Subject
Written By
Posted
Re: ERROR 1193 (HY000): Unknown system variable
August 07, 2015 09:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.