mysql column delete

Post Reply
mchd17
Forecaster
Forecaster
Posts: 188
Joined: Sat Mar 17, 2018 2:01 am
Location: Illinois
Station model: Davis Pro2 Plus
Software: Meteobridge

mysql column delete

Post by mchd17 » Sat May 21, 2022 2:47 am

how do i delete a column in mysql?

cpanel, phpMyAdmin
Image

User avatar
Asobig
Advisor
Advisor
Posts: 70
Joined: Mon Aug 21, 2017 7:05 am
Location: Almere
Station model: Davis Vantage VP2+
Software: Meteobridge (Red)
Contact:

Re: mysql column delete

Post by Asobig » Sat May 21, 2022 8:31 pm

In this link you will find the Mysql statement and some examples:
https://www.mysqltutorial.org/mysql-drop-column/

But it is like this:

Code: Select all

ALTER TABLE table_name
DROP COLUMN column_name;

mchd17
Forecaster
Forecaster
Posts: 188
Joined: Sat Mar 17, 2018 2:01 am
Location: Illinois
Station model: Davis Pro2 Plus
Software: Meteobridge

Re: mysql column delete

Post by mchd17 » Sat May 21, 2022 9:19 pm

thanks
Image

Post Reply