Monday 9 December 2019

Mysql Increase the size of column

Increase the size of a column in MySQL
Did you create a column with a specific size and would you like increase it now? 
In this MySQL Tutorial, we shall learn how to modify the size of a column in MySQL Table.
To change column size use ALTER TABLE query as shown below:

Example to change column size in MySQL Table

Let us consider students table with the following schema.
MySQL Change Column Size
The name column is of datatype varchar and size 5.
To increase the size of the column, we shall run the following SQL Query.
MySQL modify column size
Now, let us see the modified schema if the column size has updated.
MySQL Describe Table
The column size has been successfully updated to the new value.

0 comments:

Post a Comment