I am at the moment learning a lot about MySQL by reading the book, Learning MySQL and I thought providing a list of queries could help beginners like myself. Different ways to select databases, tables, rows and columns in MySQL Do note, I will be updating the list occasionally. So if this list seems incomplete, you may either wait, provide suggestions per email or simply comment down below. Just basics here; listing out your databases –> SHOW DATABASES(DB); To focus on a specific database –> USE {DB_NAME} To list all the tables in that specific database –> SHOW TABLES; Display the “column headers” of a table and their properties e.g. default value, type…
