How to Delete Row Numbers in MySQL

MySQL tables have columns you set up to contain different types of data. A numeric column is set up as an integer, so you insert only numbers in the column fields. To delete these numbers, you must "drop" the column on the table. Dropping a column deletes it from the MySQL table, so it is no longer available.

Instructions

1. Click the Windows "Start" button. Click "All Programs," then click "MySQL." Click the "Query Browser" shortcut to open the query software.

2. Type the database name in the opened "Log In" window. Type the MySQL user name and password and click "Log In" to connect to the database.

3. Type the following code to remove the column:

   alter table table_name drop column

   Replace "column" with the name of the numeric column you want to remove. Replace "table_name" with the name of the table.

4. Click "Execute" to run the code. The code removes the column from the table immediately.

References

• W3 Schools: SQL ALTER TABLE Statement