Deleting rows from multiple mysql tables using an array

Question

I want to delete specific row from multiple mysql tables at a time. The tables have a common column.

I save the table names in an array like this :

$tables = array('table1','table2','table3','table4');
foreach($tables as $table) {
$query = $con->query("DELETE FROM $table WHERE Column='somevalue'");
}

if($query === FALSE) {
echo "Error : " . $query . $con->error;
}

Is this a way to delete rows from multiple tables at once? Please excuse me if this is a silly question. I am not an expert in PHP and MySql..

possible duplicate of How to delete from multiple tables in MySQL? — umka
– umka, Commented Jun 7, 2015 at 5:46

user2977636 · Accepted Answer · 2015-06-07 05:50:08Z

1

To delete tables you have to use the drop command. Just use DROP with the mysql tables that you want to drop separated by commas:

ex: DROP TABLE T1, T2, T3

answered Jun 7, 2015 at 5:50

user2977636

2,3263 gold badges21 silver badges22 bronze badges

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

2 Comments

Hiranmoy Chatterjee Over a year ago

I have to delete specific rows from multiple tables, not entire tables.

user2977636 Over a year ago

Ah okay. Then the way you have should work. However, it would be vulnerable to a MySQL injection attack if any part of the sql string is coming from the user. If this is the case, look into escaping the data you are getting from the user.

Collectives™ on Stack Overflow

Deleting rows from multiple mysql tables using an array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related