Search code examples
mysqlphpmyadminsql-deleterecords

MySQL Deleting Multiple Records

I have a database with a bunch of shops and once a month someone sends me a spreadsheet with the cancellations for that month so I need to delete 30-40 shops each month.

Is there a quick way to do it? Right now I just manually go in and delete them because sometimes there is only 8-10 but this last spreadsheet had a bunch and I would love to make this process a lot faster.

Solution

  • Depending on how technical you want to get, you could create an process that takes your spreadsheet as an input and deletes the ones listed in there. It would then be advisable to keep the spreadsheet structure the same every time.

    Otherwise, you could simply use a SQL statement as such

    delete from stores where store_id in (:ids);

    or

    delete from stores where store_name in (:names);

    and manually copy the list of store IDs or names as a comma delimited list where the :variable is. If you are using names, just be sure each name is enclosed with ' .