Baza znanja

How To Delete A Column in phpMyAdmin

1. Log in to your cPanel or Plesk.

2. Navigate to your control panel and click the phpMyAdmin icon.

3. In phpMyAdmin, locate the database name from your list of databases, then click the expand + icon

4. From the list of tables under the database, click the expand + icon of your selected table.

5. Click Columns.

6. In the Columns' Structure tab, select the column name(s) you wish to delete.

7. Click the Drop icon from the list of Actions as shown below.

8. The phpMyAdmin will prompt you the command it will run:


ALTER TABLE 'your_selected-table'
DROP 'your_selected_column';
 

9. Make sure that this is the column you want to drop. Click Yes to confirm the deletion.

 

  • 0 Korisnici koji smatraju članak korisnim
Je li Vam ovaj odgovor pomogao?

Vezani članci

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