Modifiy column size of mysql table.

I have a mySQL table called transactionhead

Table Design:


here alter datatype of transactionhead column

alter Syntax:
ALTER TABLE <table_name> MODIFY <col_name> VARCHAR(size);
Sample Query:
ALTER TABLE transactionhead MODIFY TransactionHead VARCHAR(200);
Example:


Post a Comment

0 Comments