19.1 MySQL Basic Meta Commands

$ mysql -u kayon -p    # Connect to MySQL as user, prompting for password.
mysql> show databases; # List databases.
mysql> use alerts      # Connect to (use) the specified database.
mysql> show tables;    # List relations (tables).
mysql> describe users; # Show the table schema.


Your donation will support ongoing availability and give you access to the PDF version of the book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2021 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0.