Try using the IS NULL operator instead of !
-Travis
-Original Message-
From: Andy Wallace [mailto:awall...@ihouseweb.com]
Sent: Thursday, September 16, 2010 10:47 AM
To: mysql@lists.mysql.com
Subject: Update query problem
So I'm having a problem with an update query. I have three tables
Dear Amit,
> "update lotjobtemp set duedate = (select duedate from
> importparameters);"
In MySQL, you need 2 queries for this:
SELECT @var:=duedate FROM importparameters;
UPDATE lotjobtemp SET duedate = @var;
Most probably, you will want to use a WHERE clause for both statments.
To make this