SQL Syntax

Question 1

UPDATE syntax?

Answer 1

UPDATE table_name
SET column1 = value1, column2 = value2, …
WHERE condition;

Question 2

COUNT

Answer 2

SELECT COUNT(column_name/*)
FROM table_name
WHERE condition;

Question 3

wildcard syntax (e.g. start with letter a)

Answer 3

SELECT * FROM Customers
WHERE CustomerName LIKE ‘a%’;

Question 4

ALTER syntax (change datatype, drop, rename)

Answer 4

ALTER TABLE table_name
–THEN
ADD column_name datatype;
–
DROP COLUMN column_name;
–
RENAME COLUMN old_name to new_name;
–
ALTER COLUMN column_name datatype; ?maybe?

Question 5

CREATE syntax (w/constraints)

Answer 5

CREATE TABLE table_name (
column1 datatype constraint,
column2 datatype constraint,
column3 datatype constraint,
….
);

Question 6

assign PK

Answer 6

PK is part of constraints

Question 7

inner join syntax

Answer 7

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;