If you inadvertedly created a table with a column name that 's a reserved word, you will find it not so convenience to use. To rename the column, you can't do something like
mysql> ALTER TABLE table_name CHANGE COLUMN reserved_word new_column_name varchar(255);
Instead, you have to it this way:
mysql> ALTER TABLE `table_name` CHANGE COLUMN `table_name`.`reserved_word` `table_name`.`new_column_name` varchar(255);
Recent comments
2 weeks 5 days ago
3 weeks 6 days ago
7 weeks 4 days ago
32 weeks 4 days ago
33 weeks 3 days ago
44 weeks 3 days ago
45 weeks 5 days ago
1 year 2 weeks ago
1 year 2 weeks ago
1 year 3 weeks ago