×
Night mode
Sign up
Login
SHOW COLUMNS from a table with specifying a database
Lists all the columns from 
students
table that is in the 
university
database
SHOW COLUMNS FROM university.students
Another method to specify a database when listing columns from a table
SHOW COLUMNS FROM students IN university
by Valeri Tandilashvili
4 years ago
MySQL
SHOW
1
Pro tip: use ```triple backticks around text``` to write in code fences