1

I would like to RENAME the column item_id this column is int(11) UN zero-fill PK I would like to rename to agricultural_machine_id I've tried this command

ALTER TABLE agricultural_machine CHANGE COLUMN `item_id` `agricultural_machine_id` int(11);

I run this command but don't appear if successful or failed. enter image description here

When I run this command appear item_id

SELECT * FROM agricultural_machine;

enter image description here

Vagner Wentz
  • 391
  • 1
  • 7
  • 29
  • https://stackoverflow.com/questions/30290880/rename-a-column-in-mysql – Honeyboy Wilson May 11 '20 at 14:44
  • Does this answer your question? [How to rename a column name in maria DB](https://stackoverflow.com/questions/53735305/how-to-rename-a-column-name-in-maria-db) – Jsowa May 11 '20 at 15:08

1 Answers1

0

I resolved put the schema together like autoparanaiba.TABLE_NAME.

Vagner Wentz
  • 391
  • 1
  • 7
  • 29