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