Notice: session_start(): A session had already been started - ignoring in /home/u614325693/domains/onedoubt.com/public_html/post.php on line 3
Some Use Full Sql Queries - ONEDOUBT.COM

Some Important SQL Queries

For geting ALL table_names From Database : SELECT table_name FROM information_schema.tables WHERE table_type='BASE TABLE'
Show all tables : show tables
Show list of base tables : SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_type='BASE TABLE'
Show list of all tables : SELECT * FROM INFORMATION_SCHEMA.TABLES
Count Base tables base tables : SELECT count(*) AS TotalTable FROM INFORMATION_SCHEMA.TABLES WHERE table_type='BASE TABLE'
coumls present in tables : SELECT TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE table_type='BASE TABLE'
For Stucture Of Table : DESC table_name

Login
ADS CODE