yazilimweb tasarim
For Immediate Onsite or Remote Support Call: +254746505075 or 0735193167

How to add column to mysql table using command-kogibay.com Tutorials

Date: July 16, 2019 Author: peter Category: MYSQL Comments: 0

If you want to add a column to an exiting mysql table use the following command

alter table table_name_here add column column_name_here data_type_here after column_name

Eg. alter table employee add column employeeCounty varchar(50) after NationalId

To add a column before another column in mysql,use the following command

alter table employee add column employeeCounty varchar(50) before NationalId

Leave a Reply

Your email address will not be published. Required fields are marked *