MySQL Basics Practice Test: Using SQL to Manage Data — Flashcards

Quiz questions on server SQL mode, Mysql identifiers and rules, sql statements case sensitivity, selecting, creating, dropping and altering databases, table retrievals with joins, union and subqueries, views, transactions, foreign key, table creation, populating and modifying tables.

Here are some MySQL commands that can be used to create a database, add tables, and list tables:
create database: Creates a new database
ALTER DATABASE: Modifies a database
CREATE TABLE: Creates a new table
ALTER TABLE: Modifies a table
DROP TABLE: Deletes a table
CREATE INDEX: Creates an index
DROP INDEX: Deletes an index
SHOW TABLES: Lists all tables in the selected database
SHOW DATABASES: Lists all databases in the current MySQL database server
mysql -e: Gets information about the tables from the Linux shell
mysqlshow: Gets information about the tables from the Linux shell, and also displays databases 

Here are some examples of how to use these commands:
create database bookstoredb: Creates a new database named "bookstoredb"
show databases connect bookstoredb: Checks and connects to the bookstoredb database
CREATE TABLE users: Adds a new table named "users"
mysql -u root -p: Connects to the MySQL server
SHOW DATABASES;: Lists all databases in the current MySQL database server 

You can also use pattern matching to filter the returned tables. For example, you can use the following syntax: mysql> SHOW TABLES LIKE pattern and mysql> SHOW TABLES WHERE expression.