MariaDB 10.4

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

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

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'

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

SELECT * FROM joke
Table 'db_1903861635.joke' doesn't exist