| customerNumber | int(11) | NO | MUL | NULL | | | orderNumber | int(11) | NO | PRI | NULL | | | Field | Type | Null | Key | Default | Extra | Issue the USE command to switch to the database to classicmodels: mysql> USE classicmodels >mysql -u root -pĬode language: SQL (Structured Query Language) ( sql )
The following example demonstrates how to display columns of the orders table in the classicmodels database. To show all columns of a table, you use the following steps:
