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
So I'm having a problem with an update query. I have three tables:
Table: A
Columns: acnt, name, company, email, domain
Table: AM
Columns: acnt, m_id
Table: M
Columns: m_id, name, company, email, domain
and I want to conditionally update the columns in one to values from the
other. i.e.,
: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Amit Lonkar" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 1:34 PM
Subject: Update Query problem
> Hi All!!
>
> I am writing a .sql file
Hi All!!
I am writing a .sql file. I want to execute this file
at runtime.
One of the queries is :-
"update lotjobtemp set duedate = (select duedate from
importparameters);"
This query generates an error as
"ERROR 1064: You have an error in your SQL syntax near
'select duedate from impor
tpar
