≡ Menu

Running SQL Queries/Commands for MySQL Database in PhpMyAdmin

SQLExecuting commands in PhpMyAdmin lets you easily remove junk posts, add entries, make tables, and modify your database quickly if you are good at mySQL commands like

DELETE FROM wp_posts WHERE post_type = "revision"

It can save you a lot of time since you do not have to login to your CMS or forum to make changes to your data base. You can just use the built-in phpmyadmin SQL text box tool.

1. Login to phpmyadmin to administrate your database.

2. Before you make any changes, you should make a backup of your database file by using the export option for phpmyadmin since there is no UNDO in phpmyadmin.

3. Click the SQL button in the sidebar, or click the SQL tab when you enter the database tables listings.

SQL

4. A SQL box will appear where you can run queries with it by typing or pasting SQL code and clicking the GO button to execute them.

SQL command texbox

0 comments… add one

Leave a Comment