How to check table status in MySQL Workbench

Configurare noua (How To)

Situatie

We want to view table status/information in MySQL database.

We will follow the steps bellow.

Backup

Not necessary.

Solutie

Pasi de urmat

Open MySQL Workbench and type show databases; in order to view the databases stored in the server:

See bellow the databases from the server:

Type use countries; in order to use the countries database for checking the tables:

Type show table status; command in order to view table status on countries database:

Tip solutie

Permanent

Impact colateral

Not applicable.

Plan de restaurare in caz de nefunctionare

Not necessary.

Voteaza

(21 din 51 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?