Bluehost India Web Hosting Help
Modifying table columns - phpMyAdmin
Modifying table columns in phpMyAdmin
This tutorial will demonstrate how to modify existing MySQL database tables in phpMyAdmin.
Begin by accessing phpMyAdmin via cPanel.
- Select the database you want to work with (by clicking on database name in the left column of the phpMyAdmin home page).
- Once inside a database, you will see a list of tables. Click on the table you wish to modify.
- Inside the table, you will see a list of columns. To the right of the column name, you will see a link called "Change" under the Actions. Click on the Change link for the column you wish to modify.
- You can change a variety of things, including the name of the column, length of the field (maximum number of characters allowed), default value, and more.
- Once you are ready to proceed, click on Save to save the changes.
The changes you requested will have been applied.
Recommended Help Content
Dropping columns from a database table using PhpMyAdmin
A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin
How To Rename Database Tables in PHPMyAdmin
This article will show you how to rename a database table in phpMyAdmin.
How to Add Tables to a DB in PhpMyAdmin
Guidance on adding tables to your mySQL database in phpMyAdmin
Related Help Content
Searching a database in PhpMyAdmin
Step by step directions on how you can search your database using phpMyAdmin
Adding a column to a db table in phpMyAdmin
Instructions on adding a column to your database in phpMyAdmin
How To Copy A Database Using PHPMyAdmin
A guide to duplicating a MySQL database using phpMyAdmin
MySQL dump of tables only no data
I would like to dump the Table Structure for my MySQL Database, but none of the data.
How To Run SQL Queries in PHPMyAdmin
A guide on performing a standard SQL query using the phpMyAdmin interface
Managing Your DB Using phpmyadmin
A repository of information on how you can manage your database by using the phpMyAdmin interface.
Import a MySQL Database using phpMyAdmin
How do I import a backup of my database (.sql file) using phpMyAdmin?
MySQL Repair and Optimize Tables in phpMyAdmin
How to repair and optimize your database using phpMyAdmin: