I have been trying to figure out how to change a value in a table variable in a MySQL database, but I've hit nothing but syntax errors, despite copying and pasting commands from bits I can find. I started at the CLI and couldn't find the commands to work, so I was going to try with the MySQL Workbench from my PC. I disabled the firewall, changed the binding to allow remote machines to connect, and then tried to grant access from both any machine or just my IP and that's where the syntax errors came in. Even direct copying and pasting full commands, changing that which needed to be changed resulted in the same syntax errors.

Ideally, I'd prefer to change it from the mysql cli in Linux as with the right command, that's probably super simple, the problem is I can't find the right command. Nothing I've found has worked.

I can get all the way down to looking the variable in the table after selecting the database, but I can't get further than that.

mysql> select * from my_variables\G;
*************************** 1. row ***************************
variable_id: 1
variable_name: padding_tile
variable_datetime_utc: 2026-02-21 19:04:23
variable_value: 754
variable_type: int

Could someone please tell me what command I'd need to run to change the 'variable_value' of '754' to something else? It seems this should be so simple, but I haven't been able to find a clear command.

Subject

Written By

Posted

Alter table variable value

February 21, 2026 03:11PM

February 23, 2026 04:46AM