Home » mysql » How to add new column in a table?

How to add new column in a table?

To insert new column in a table we use ALTER query.

Syntax:

For example, if we consider the table employee we can write the query as:

by this query we see that a new column E_City has been added in table Employee.Further you can also insert values in column city by using update query.
insertion of a new column


Leave a comment

Your email address will not be published.

Managed by MochaHost - Fast & Easy WordPress Hosting