Base de connaissances

Modify Table Column in phpMyAdmin

Begin by accessing phpMyAdmin via cPanel

1. Select the database you want to work with (by clicking on database name in the left column of the phpMyAdmin home page).

2. Click on the table you wish to modify.

3. 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.

4. You can change a variety of things, including the name of the column, length of the field, default value, and more.

5. Once you are ready to proceed, click on Save to save the changes.

 

  • 0 Utilisateurs l'ont trouvée utile
Cette réponse était-elle pertinente?

Articles connexes

SQL injection

SQL injection is an attack where malicious code is passed to an SQL Server for execution. The attack can result in unauthorized access to confidential data or the destruction of critical data....

MySQL Database Limit

There is no limit for the size of databases. MySQL is only limited to the size of your cPanel's disk space. As long as there is still some free space in your cpanel disk, you are good to go.

MySQL Variable Types

MySQL database has three (3) main data types: text, numbers and dates/times. Text Types CHAR( ) A fixed section from 0 to 255 characters long. VARCHAR( ) A variable section from 0...

cPanel MySQL Database Wizard

This instructions guides you through the setup of a MySQL® database, user accounts, and user privileges. We recommend that you use this wizard to create your first database and user. To create...

phpMyAdmin Glossary

phpMyAdmin is a free open source tool written in PHP language. This tool handles the administration of MySQL and MSSQL over the web, performing various tasks such as creating, modifying or deleting...