Mysql cheetsheet commands & script

Shchema Information

Show database (version) tables, create table, index

show status;
show global status ;
select version();
show variables like 'slow%';
show databases;
use database <db_name>
show tables;
desc employees;
show create table employees;
show indexes from employees;

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
LORY

LORY

A Senior Software Developer/Body builder . to help others enjoy coding and stay healthy