php - Using the "UNION" Delete MySQLI Query -


I want to delete some of my database information in 2 tables.

The first question, is this possible? If yes:

I tried a union daily query, but it does not work. ID id like ". $ Id" "& amp; amp; and user like" $. from $ 1 <$> $ delete = mysqli_query ($ sql, " UserID. "'UNION' (Delete table 2 with WHERE source_id as" $. "$ Id." & Amp;; User ID preference ''. $ User '' '') ");

union will only use SELECT statements:

If you do not want to use two separate DELETE statements and are related to those two tables, then include statement: < / p>



Comments