Topic: [SOLVED] DELETE FROM help please

[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....