0

The difference between SHOW and SELECT query ?

21st Sep 2016, 8:15 AM
Joshua Ng andwe
Joshua Ng andwe - avatar
3 ответов
+ 1
it is easier to chance the characteristics with SELECT
21st Sep 2016, 8:24 AM
walkingtree
walkingtree - avatar
+ 1
SHOW is a older term, so SELECT is better
21st Sep 2016, 8:26 AM
walkingtree
walkingtree - avatar
+ 1
SHOW will display all the databases and tables, while, with SELECT it will display particular tables and columns.
21st Sep 2016, 11:02 AM
DARSHANA WADHWA
DARSHANA WADHWA - avatar