Re: [Squirrel-sql-users] A wrong SQL Update statement and Squirrel detect it, but still the first p
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: John H. <jh...@im...> - 2012-01-13 13:56:46
|
On Thu, 12 Jan 2012, Gerd Wagner wrote: > On 12.01.2012 23:00, John Hardin wrote: >> On Thu, 12 Jan 2012, Paulus Gunawan wrote: >> >> > UPDATE TABLE_A WHERE STATUS = 'X'; >> >> That seems to be an incomplete UPDATE statement (no SET clause). >> >> What SQL engine accepted that query as valid? What is it supposed to do? > > I copied the statement from Paulus's mail quoted below. The statement is not > correct SQL syntax but from the context of the original mail the statement is > good enough to make sense in its context. > > But you are right, it would have been clearer if I had written > > UPDATE TABLE_A ... WHERE STATUS = 'X'> Okay. I was wondering if that is what was meant. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- The United States has become a place where entertainers and professional athletes are mistaken for people of importance. -- Maureen Johnson Smith Long ----------------------------------------------------------------------- 4 days until Benjamin Franklin's 306th Birthday |