Home » mysql » Updating the column data size

Updating the column data size

To create a table

after creating table we want to increase the size of description field from varchar(20) to varchar(100).

for that we will use alter table command

Syntax

Example

we can also decrease the size of column but it may cause the data loss.
like

Please follow and like us:
error