[SOLVED] DELETE FROM help plz

[sspoke]

i know how to do this now with UPDATE/SELECT's

 

but not im sure why it doesn't compile with DELETE FROM.

 

/** failures */

DELETE FROM `user_invitems` AS l USING `user_credentials` AS c WHERE l.id = c.id AND c.name = 'testing123'

DELETE FROM `user_invitems` AS l,  `user_credentials` AS c WHERE l.id = c.id AND c.name = 'testing123'

DELETE FROM `user_invitems` AS l,  `user_credentials` AS c AS l.id = c.id AND c.name = 'testing123'

 

using 2 tables 1 to pick name from and match its id row to a different tables row.

 

 

also another question relating speed its really odd on the working UPDATE/SELECT which is exactly like DELETE FORM except it works..

for some reason those UPDATE/SELECT process for this took around 0.0130 secs to get id from a different table and do its process which is alot more compared to normal SELECT/UPDATEs on a preset id which are like 0.0020 secs

[sspoke]

did more research and tried

DELETE `user_invitems` FROM `user_invitems` AS l, `user_credentials` AS c WHERE l.id = c.id AND c.name = 'testing123'

 

didn't work..

 

can't edit topics srry

[teng84]

delete from tablename where field =condition

thats all!!!!!!

[sspoke]

delete from tablename where field =condition

thats all!!!!!!

 

No.. I know that.. im talking about SELECT + DELETE in one DELETE.

[teng84]

delete from tablename where fieldtobedeleted in(select form tbale where condition)????

[sspoke]

and how can I do what u said?  ??? ?

 

DELETE FROM `user_invitems` AS l, `user_credentials` AS c WHERE l.id = c.id IN c.name = 'testing123'

?

 

remember I can't delete user_invitems without only deleting the linked ID's to user_credentials by name..

[teng84]

do something like a Cartesian join

http://dev.mysql.com/doc/refman/5.0/en/delete.html

[sspoke]

yah thats no help..  at all..

 

 

[fenway]

yah thats no help..  at all..

 

Did you get this figured out? There was a lot of nonsense posted on this thread....