SHOW DATABASES; SHOW TABLES;
CREATE TABLE ban (user TEXT, kedy TIMESTAMP); INSERT INTO ban (user, kedy) VALUES ('matush', '2004-6-16 14:57:22'); INSERT INTO ban (user, kedy) VALUES ('jaja', NOW() + INTERVAL 10 DAY); namiesto DAY: SECOND, MINUTE, HOUR, MONTH, YEAR, MINUTE_SECOND, DAY_HOUR, HOUR_MINUTE, YEAR_MONTH, HOUR_SECOND, DAY_MINUTE, DAY_SECOND
SELECT * FROM ban WHERE kedy > NOW(); SELECT * FROM ban WHERE kedy > ( NOW() + INTERVAL 7 DAY);
ALTER TABLE ban CHANGE kedy kedy TIMESTAMP; alebo: ALTER TABLE ban MODIFY kedy TIMESTAMP;
DELETE FROM ban; DROP TABLE ban;