How to change/replace database tables prefix ?

I this article, I would like to explain how to change/replace database all tables prefix. it is very simple so please just follow below steps and you can change all tables prefix of any database.


Step 1 : Please login into your phpmyadmin, After login into your phpmyadmin, you will find list of database in left sidebar. please select database in which you want to change/replace tables prefix. please see below screenshot :


Truncate Mysql Table

Mysql TRUNCATE TABLE statement allow to delete all data of table. Truncate statement is like a delete record feature without any where clause but truncate statement is automatically reset primary key of table.


Here shows mysql TRUUNCATE TABLE statement stntax. you can use belowe syntax and delete all records of your table.


Drop Mysql Table

Mysql DROP TABLE statement is useful and allow to drop/delete existing mysql database table, but you need to careful while delete mysql table because of deleted table data not recovered after deleting table.


Here show drop table query syntax :


Create Mysql Table

A database table name consists two parameters, one is table prefix and another is table name. prefix used for in single database consist two different application tables. for example any given database store A Application and B application data, then A application tables consist prefix a and another B application table name prefix is b.

Every table consists columns and rows. CREATE TABLE statement is used for create a mysql table. mysql table creation command require 3 parameters which is show below :

  • Name of the table
  • Name of fields
  • Definition and type of each fields

Create Table using PHP Script:

mysql_query function used for create Mysql table using php script. mysql_query function need two parameters for creating table and returns TRUE for success or FALSE for failure.

Syntax :

Create Table syntax :


Drop Mysql Database

A database is a collection of  set of tables, views and set of data. If you want to drop mysql database you will need special privileges for drop/delete a MySQL database. so you will need root access of your mysql server.

Drop Database using PHP Script:

mysql_query function used for drop Mysql Database using php script. mysql_query function need two parameters for drop database and returns TRUE for success or FALSE for failure of query.

Syntax :

Input Parameter Detail
sql_statement Required – SQL query of drop MySQL database
connection_string Optional – if not set, then used last opened mysql connection.