Questions Linux Laravel Mysql Ubuntu Git Menu

HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin

Renaming prefixes of table names within phpmyadmin?

Tags:

database

rename

phpmyadmin

prefix

Is there a more dynamic way to rename all prefixes in a database within phpmyadmin, rather than manually typing to replace the name for each table? I have about 50 tables to change prefixes on... Maybe I should grab a snickers bar?

like image

720

asked Nov 04 '11 16:11

klewis

People also ask

When naming a table what prefix would you use?

Tables do not require prefixes. This is purely up to you. However, we prefix tables with relation to the MODULES in the application they belong to, just to group the tables more easily.

1 Answers

Have all the corresponding tables in phpMyadmin ticked and select With Selected..->Replace table prefix

like image

91

answered Oct 10 '22 00:10

Thomas

Sign in to Comment

Related questions
                            
                                Refresh/Reload database reference in custom ContentProvider after restore
                            
                                SQL Server: compare columns in two tables
                            
                                how to remove error "[NSString stringWithUTF8String:]: NULL cString' "?
                            
                                Laravel load settings from database
                            
                                Java Best Practice for Date Manipulation/Storage for Geographically Diverse Users
                            
                                What's wrong with Linq to SQL?
                            
                                Is storing counts of database record redundant?
                            
                                Change tinyint default value into 1 mysql
                            
                                Is it OK to put a database initialization call in a C# constructor? [closed]
                            
                                Is it *really* worth to use integer over varchar for a set of data?
                            
                                How do I resize and convert an uploaded image to a PNG using GD?
                            
                                Database Design: replace a boolean column with a timestamp column?
                            
                                How to iterate over a date range in PL/SQL
                            
                                Copy a row within the same table
                            
                                How to add auto-increment to column in mysql database using phpmyadmin?
                            
                                Opinion: in HTML, Possible Duplicate IDs or Non-Standard Attributes?
                            
                                When is sql distinct faster than java programming 'distinct'
                            
                                What are the design criteria for primary keys?
                            
                                What is difference between Titan and Neo4j graph database?
                            
                                Which database should I use for home project use?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With