Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite0
Difference between "SELECT" and "SHOW" in SQL
What is the difference between "SELECT phone no. FROM friends" And "SHOW phone no. FROM friends"
2 Réponses
+ 4
SHOW does not work like SELECT, it does not retrieve the data values. If you specify COLUMNS above, you will receive column information, instead -- columns' names, types, keys and properties.
As far as I know, you can't specify a particular column name in a SHOW statement.
Take a look at possible SHOW uses:
https://dev.mysql.com/doc/refman/8.0/en/show.html
+ 1
Got it 👍