To connect to a mysql database run:
mysql -u root -h IP -p
To see databases: show databases;
show databases;
To use one database: use DATABASE_NAME;
use DATABASE_NAME;
To see tables of database: show tables;
show tables;
To modify a value: update runcheck set run = 1;
update runcheck set run = 1;
Now (when you inside a table) you can do: select * from TABLE_NAME
select * from TABLE_NAME
Last updated 1 year ago