write delete query for following in zend framework

Question

I am having a situation in my MySQL database table of row repeating
So I got this

DELETE from table1
USING table1, table1 as vtable
WHERE (NOT table1.ID=vtable.ID)
AND (table1.field_name=vtable.field_name)

Where table1 is the table and vtable is a virtual table

How should I write that in Zend Framework

Community · Accepted Answer · 2023-11-14 22:27:54Z

2

Zend_Db_Select supports the USING clause, but I think it's not supported by the Zend_Db_Adapter delete() method.

A possible alternative would be passing the SQL expression directly to the connection (if you are using the pdo_mysql adapter, it will be a PDO object):

$db->getConnection()->exec($sqlExpression);

(IMPORTANT: Make sure you quote properly all the identifiers and values in the SQL sentence, Zend_Db_Adapter has some extensive documentation about this).

edited Nov 14, 2023 at 22:27

CommunityBot

11 silver badge

answered Sep 21, 2011 at 8:37

dinopmi

2,67319 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

dinopmi Over a year ago

Thanks for the comment, @Pang ! I have just replaced the dead link. Apparently the documentation URL was moved since I wrote this answer 5 years ago.

JNDPNT · Accepted Answer · 2011-09-21 08:08:58Z

1

I'm not sure what you are trying to do, but this is how to use a basic delete in Zend:

$db->delete('table1', array('ID != ?' => $otherID, 'field_name = ?' => $otherFieldName));

Is this what you are looking for?

answered Sep 21, 2011 at 8:08

JNDPNT

7,4752 gold badges37 silver badges40 bronze badges

Collectives™ on Stack Overflow

write delete query for following in zend framework

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related