Do you mean altering the table after it has been created? If so you need to use alter table, in particular:
ALTER TABLE tablename MODIFY COLUMN new-column-definition
e.g.
ALTER TABLE test MODIFY COLUMN locationExpect VARCHAR(120);
More Related Contents:
- add column to mysql table if it does not exist
- MySQL: ALTER TABLE if column not exists
- Adding multiple columns AFTER a specific column in MySQL
- How can I modify the size of column in a MySQL table?
- Error renaming a column in MySQL
- ALTER TABLE to add a composite primary key
- How to add not null constraint to existing column in MySQL
- Alter MySQL table to add comments on columns
- Create an index on a huge MySQL production table without table locking
- MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
- ALTER table – adding AUTOINCREMENT in MySQL
- Alter table if exists or create if doesn’t
- `MODIFY COLUMN` vs `CHANGE COLUMN`
- How do I add more members to my ENUM-type column in MySQL?
- Optimizing MySQL for ALTER TABLE of InnoDB
- Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)
- Using LIMIT within GROUP BY to get N results per group?
- Quick easy way to migrate SQLite3 to MySQL? [closed]
- How to change the CHARACTER SET (and COLLATION) throughout a database?
- Equivalent of Oracle’s RowID in MySQL
- How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
- Getting all parent rows in one SQL query
- How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
- Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
- How can I enable the federated engine in mysql after installation?
- Is incrementing a field in MySQL atomic?
- Delete from one table with join
- MySQL column type “TIMESTAMP” implicitly includes “NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”
- MySQL: Compare BETWEEN time
- MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?