mysql delete security risks

admin

Administrator
Staff member
Hi,

I know there is a security risk with having a SELECT statement where you can have a DELETE statement within the SELECT statement and therefore delete all records from a DB table when performing a SELECT statement. Can anyone show me the syntax for this?

I know its something like

SELECT * from table where id= (delete from table where id=1)

or something like that?!
 
Back
Top