The difference between SHOW and SELECT query ? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

The difference between SHOW and SELECT query ?

sql
21st Sep 2016, 8:15 AM
Joshua Ng andwe
Joshua Ng andwe - avatar
3 Answers
+ 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

Often have questions like this?

Learn more efficiently, for free:

See all courses
Hot today
Guys how do we solve the code of ballpark orders
1 Votes
The test ouput is not working. It is Python Basics and smart parking lot
1 Votes
Roblox full version
0 Votes
Help me
1 Votes
What is the bug here??
0 Votes
Why does first list has one less element in the same range?
1 Votes
Help!
1 Votes
What should I learn?
1 Votes
Ai and coding !!?
2 Votes
Html code
1 Votes