|
|
|
|
| |
mysql> SHOW COLUMNS FROM president LIKE '%name';
| Field |
Type |
Null |
Key |
Default |
Extra |
| last_name |
varchar(15) |
|
|
|
|
| first_name |
varchar(15) |
|
|
|
|
The '%' character used here is a special wildcard character that is described later in the "Pattern Matching" section. Similar restrictions can be used with DESCRIBE and EXPLAIN as well; for the exact syntax, see Appendix D, "SQL Syntax Reference."
The SHOW statement has other forms that are useful for obtaining different types of information from MySQL. SHOW TABLES lists the tables in the current database, so with the two tables we've created so far in the sampdb database, the output looks like this:
|
|
|
|
|
|
| Link Partners: Asia florist, Flowers to India, Hong kong flowers, Site submit, Cheap web hosting, China florist, Japan florist |
|
