简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

Use PHP to batch delete all tables with prefix_ in the database_PHP tutorial

WBOY
Release： 2016-07-13 10:28:42
Original
930 people have browsed it

The following is a script that uniformly deletes tables with the prefix "prefix_":

Copy code The code is as follows:

//Set database connection information. Database server address, database username, data password
mysql_connect('database host', 'database username', 'database password');
//Set the query database name
mysql_select_db('database name ');
$rs=mysql_query('show tables');
while($arr=mysql_fetch_array($rs))
{
//Set the database table prefix to be deleted in batches, such as ：prefix_
$TF=strpos($arr[0],'prefix_');
if($TF===0){
$FT=mysql_query("drop table $arr[0] ");
if($FT){
echo "$arr[0] deleted successfully!
";
}
}
}
?>

Create a new php file and save it as deletedata.php

For example, you want to delete the background data of www.aworldair.com or http://www.pro-reach.com/ , two steps are enough:

1. First upload the saved deletedata.php file to the root directory of your website;

2. Directly enter: www. aworldair.com/deletedata.php or http://www.pro-reach.com/deletedata.php will be OK if you execute this deletion script. The script will display the successful deletion information of all tables in the browser.

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/781036.htmlTechArticleThe following is a script to uniformly delete tables with the prefix "prefix_": Copy the code as follows: ?php //Settings Database connection information. Database server address, database user name, data...
Related labels：
批量删除表
source：php.cn
Previous article：Detailed description of libraries, helpers, hooks folders in CI framework_PHP tutorial Next article：PHP Add and modify data in the same form 2_PHP tutorial
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to group and count in MySQL? I'm trying to write a query that extracts the total number of undeleted messages sent to f...
From 2024-04-06 18:30:17
0
1
353
How to insert multiple rows in MySQL table and return new IDs? Normally I can insert a row in a MySQL table and get the last_insert_id. But now, I want t...
From 2024-04-06 10:03:44
0
2
294
jQuery.remove() and array.splice() issues So I have a page that has a list of items and a shopping list. If you add x number of item...
From 2024-04-04 17:21:35
0
1
347
The list item symbols (<ul> and <ol>) in the root node cannot be displayed and removed in CSS, and the overflow-x: hidden problem cannot be removed. I'm currently working on a web page and I'm having trouble with my list items. The dots an...
From 2024-04-04 16:38:22
0
1
3617
Steps to remove a foreign key entry I have two tables Employee and Address. Employee is my main table and Address is a subtabl...
From 2024-04-04 14:15:44
0
1
352
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！