Minimum and maximum number with - and + 500 in Mysql and Sql query and Find out table scheema of our database in Mysql and sql query and Find out all table name of our database in Mysql and sql query and Find out current date and time in mysql and sql help of sql query
Minimum and maximum number with - and + 500 in Mysql and Sql query:-
syntax:-
SELECT MIN(Used)-500 , max(Used)+500 FROM audit
Find out current date and time in mysql and sql help of sql query:-
syntax:-
SELECT now()
Find out database name in Mysql and sql query:-
syntax:-
SELECT DATABASE();
Find out all table name of our database in Mysql and sql query:-
syntax:-
SHOW TABLES;
Find out table scheema of our database in Mysql and sql query:-
syntax:-
DESCRIBE <table name>;
syntax:-
SELECT MIN(Used)-500 , max(Used)+500 FROM audit
Find out current date and time in mysql and sql help of sql query:-
syntax:-
SELECT now()
Find out database name in Mysql and sql query:-
syntax:-
SELECT DATABASE();
Find out all table name of our database in Mysql and sql query:-
syntax:-
SHOW TABLES;
Find out table scheema of our database in Mysql and sql query:-
syntax:-
DESCRIBE <table name>;
Comments
Post a Comment