What is the difference between showing and selecting. I assume when I select something it can be manipulated, but I may be wrong. I.e. SHOW columns FROM customers vs. SELECT * FROM customers. Is there a difference?

Question

SHOW vs. SELECT

Answer 1

We use show for our database and tables while select is for getting data within a table.

Answer 2

You may be using the SQL command line...but try it on real world applications... showing and selecting are similar yet different

Answer 3

like both of em are accessor commands...but selection command can also be used for subqueries indulging modifiers but not show