CREATE TABLE mos_test
(
	id integer primary key not null,
	age integer,
	text varchar(20),
	text2 varchar(20)
);

INSERT INTO mos_test
	(id, text, text2)
	VALUES
	(2, 'Mumintrollet', 'Mumindalen');

INSERT INTO mos_test
	(id, text, text2)
	VALUES
	(2, 'Mumintrollet', 'Mumindalen');

INSERT INTO mos_test
	(id, text, text2)
	VALUES
	(?, ?, ?);

UPDATE mos_test
SET
	age = 22,
	text = 'Mumintrollet',
	text2 = 'Mumindalen'
WHERE id = 2
;

UPDATE mos_test
SET
	age = 22,
	text = 'Mumintrollet',
	text1 = 'Mumindalen'
WHERE id = 2
;

UPDATE mos_test
SET
	age = ?,
	text = ?,
	text1 = ?
WHERE id = ?
;

SELECT
	age, text, text1
FROM mos_test
WHERE 
	(id = 2)
;

SELECT
	age, text, text1
FROM mos_test
WHERE 
	(id = 2)
ORDER BY id ASC
;

SELECT
	t1.*, t2.*
FROM mos_test AS t1
INNER JOIN mos_test AS t2
	ON t1.id = t2.id
;

SELECT
	t1.*, t2.*, t3.*
FROM mos_test AS t1
INNER JOIN mos_test AS t2
	ON t1.id = t2.id
INNER JOIN mos_test AS t3
	ON t1.id = t3.id
;

DELETE FROM mos_test WHERE id = 2;

DELETE FROM mos_test;

DROP TABLE mos_test;