Informix Forum

Re: sql delete bypass where question

Posted By: Obnoxio The Clown
Date: Wednesday, 5 April 2006, at 1:50 p.m.

In Response To: sql delete bypass where question (MICHAEL CLARK)

MICHAEL CLARK said:
>
> I'd like to automate deletion of all the data in an entire table. How do I
> bypass the question when there is no where clause in the delete statement?
>
> "No where clause on Delete or Update, every row in table will be affected"
> I've tried using
>
> delete from table_name
> where upper(column_name) matches '[A-Z]*';
>
> but it doesn't work even though using this syntax in a select statement
> retrieves all the rows.

a) this forum exists to discuss the marketing of Informix, not technical
questions;
b) delete from table where 1=1

--
Bye now,
Obnoxio

Information within this post contains forward looking statements within
the meaning of Section 27A of the Securities Act of 1933 and Section 21B
of the S E C Act of 1934. Statements that involve discussions with respect
to projections of future events are not statements of historical fact and
may be forward looking statements. Don't rely on them to make a decision.

The poster is not a reporting company registered under the Exchange Act of
1934.

I have received a life peerage from Her Majesty, who is not an officer,
minister or affiliate Labour party member.

I intend to recover my loan now, which could cause the parliamentary
majority to go down, resulting in losses for you. Today's Labour party
has: an accumulated deficit and a reliance on loans from officers and
affiliates to pay expenses. It is not an operating political party. The
party is going to need financing to continue as a going concern. A failure
to finance could cause the party to go out of business. This report shall
not be construed as any kind of investment advice or solicitation. You can
lose all your money by investing in this party.

Messages In This Thread

• sql delete bypass where question
  MICHAEL CLARK -- Tuesday, 4 April 2006, at 2:41 p.m.
  • Re: sql delete bypass where question
    MICHAEL CLARK -- Tuesday, 4 April 2006, at 3:33 p.m.
  • Re: sql delete bypass where question
    ART KAGEL, BLOOMBERG/ 731 LEXIN -- Wednesday, 5 April 2006, at 11:29 a.m.
  • Re: sql delete bypass where question
    Peter_Logan@spartanstores.com -- Wednesday, 5 April 2006, at 11:34 a.m.
  • Re: sql delete bypass where question
    Obnoxio The Clown -- Wednesday, 5 April 2006, at 1:50 p.m.

Informix Forum is maintained by Administrator with WebBBS 5.12.