Database, Table, and Column Name Completion

When writing queries, you can save yourself time by entering the first few characters of a database, table, or column name, and then pressing the Tab key. mysql examines a list of database, table, and column names that it built dynamically when starting (or when switching to another default database via USE) and tries to complete the name for you.

If you have created a new table or otherwise modified the data on the server, type \# and press Enter to rebuild the list of names.