clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2555260 fiddles created (37456 in the last week).

CREATE DATABASE ijdb USE ijdb CREATE TABLE joke ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, joketext TEXT, jokedate DATE NOT NULL ) DEFAULT CHARACTER SET utf8 ENGINE=InnoDB
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USE ijdb CREATE TABLE joke ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, ' at line 2
 hidden batch(es)


CREATE DATABASE ijdb; USE ijdb; CREATE TABLE joke ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, joketext TEXT, jokedate DATE NOT NULL ) DEFAULT CHARACTER SET utf8 ENGINE=InnoDB
Access denied for user 'u_1903861635'@'localhost' to database 'ijdb'
 hidden batch(es)


INSERT INTO joke VALUES (1, 'Test', '2020-05-11 00:00:00')
Table 'db_1903861635.joke' doesn't exist
 hidden batch(es)


SELECT * FROM joke
Table 'db_1903861635.joke' doesn't exist
 hidden batch(es)