Saturday, May 25, 2013

[SQL][MySQL] Change the size of a column in a mysql table

ALTER TABLE <table_name> MODIFY <col_name> VARCHAR(<new_size>);
<---- change the text in red to your own-text

example:
ALTER TABLE users MODIFY twitter_handle VARCHAR(100);
It means changing the column(username) in table(users),  size to 100,



After input "ALTER TABLE users MODIFY twitter_handle VARCHAR(100);":


No comments :

Post a Comment