MySQL Flashcards
1
Q
What MYSQL syntax is used for creating a database?
A
CREATE DATABASE database_name;
2
Q
What MYSQL syntax is used for switching to a database?
A
USE database_name;
3
Q
What MYSQL syntax is used for creating a table?
A
CREATE TABLE table_name (
column1 datatype,
column2 dataype,
)
4
Q
What MYSQL syntax is used for inserting data into a table?
A
INSERT INTO table_name (column1, column2)
VALUES