SELECT
id, title
FROM
sample
WHERE
id = 1
SELECT
*
FROM
sample
WHERE
id = 1
AND
title = 'sample1'
SELECT
*
FROM
sample
WHERE
id = 1
OR
title = 'sample1'
SELECT
*
FROM
sample
WHERE
(id = 1 AND title = 'sample1')
OR
(id = 2 AND title = 'sample2')
SELECT
*
FROM
sample
WHERE
title LIKE '%sample1%'
SELECT
*
FROM
sample
WHERE
id IN (1, 2, 3, 4)
SELECT
*
FROM
sample
INNER JOIN
sample1
ON sample.id = sample1.id
WHERE
sample.id = 1
SELECT
*
FROM
sample
LEFT JOIN
sample1
ON sample.id = sample1.id
WHERE
sample.id = 1
SELECT
*
FROM
sample
RIGHT JOIN
sample1
ON sample.id = sample1.id
WHERE
sample.id = 1
SELECT
*
FROM
sample
WHERE
id IN (SELECT
id
FROM
sample1
WHERE
id = 1
)
INSERT INTO
sample(id, title)
VALUES
(1, 'sample1')
UPDATE
sample
SET
title = 'sample1'
WHERE
id = 1
DELETE FROM
sample
WHERE
id = 15
SELECT
id, title
FROM
sample
WHERE
id IS NULL
SELECT
id, title
FROM
sample
WHERE
id IS NOT NULL
SELECT
id, title
FROM
sample
WHERE
id BETWEEN 1 AND 100
SELECT
id, title
FROM
sample
WHERE
id NOT BETWEEN 1 AND 100
SELECT
*
FROM
sample
LIMIT 5
(SELECT id
FROM sample
WHERE id = 1
) UNION ALL
(SELECT id
FROM sample
WHERE id = 2
) UNION
(SELECT id
FROM sample
WHERE id = 3
)
SELECT
id,
title
FROM
user
UNION (SELECT id, title FROM sample)
UNION (SELECT id, title FROM sample)