SQL

Question 1

How do you create a new table?

Answer 1

CREATE TABLE table_name (
column datatype,
column datatype
)

Question 2

How do you insert a new record into an table?

Answer 2

INSERT INTO users (email, username, pwd) VALUES (‘test@gmail.com’, ‘test123’, ‘rightright’);

Question 3

How can you select a specific record?

Answer 3

SELECT * from users WHERE id = 1

Question 4

How can you update a specific record?

Answer 4

UPDATE table_name SET email = ‘new@gmail.com’ WHERE id = 1

Question 5

How can you delete a specific record?

Answer 5

DELETE from table_name WHERE id = 1

Question 6

How can you receive all records from a table?

Answer 6

SELECT * from table_name