MySQL Flashcards

1
Q

What MYSQL syntax is used for creating a database?

A

CREATE DATABASE database_name;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What MYSQL syntax is used for switching to a database?

A

USE database_name;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What MYSQL syntax is used for creating a table?

A

CREATE TABLE table_name (
column1 datatype,
column2 dataype,
)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What MYSQL syntax is used for inserting data into a table?

A

INSERT INTO table_name (column1, column2)
VALUES

How well did you know this?
1
Not at all
2
3
4
5
Perfectly