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.



MySQL Phrasebook. Essential Code and Commands
MySQL Phrasebook
ISBN: 0672328399
EAN: 2147483647
Year: 2003
Pages: 130

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net