This online tool help you to test and run issues with databases and tables using: MySQL, PostgreSQL and SQLite:
You can see bellow one screenshot with some MySQL queries:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | CREATE DATABASE IF NOT EXISTS catafest_DB; USE catafest_DB; CREATE TABLE tasks ( nrcrt INT NOT NULL AUTO_INCREMENT PRIMARY KEY , task VARCHAR(255) NOT NULL, description TEXT, startDate DATE, endDate DATE, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE INNODB; INSERT INTO tasks (task,description, startDate,endDate) VALUES ('test','test description',DATE '2022-05-14',DATE '2022-05-16'); INSERT INTO tasks (task,description, startDate,endDate) VALUES ('read','read a book',DATE '2022-05-16',DATE '2022-05-17'); INSERT INTO tasks (task,description, startDate,endDate) VALUES ('write','write letter',DATE '2022-05-16',DATE '2022-05-17'); |