CREATE DATABASE metadb;

USE metadb;



CREATE TABLE Book(

id BIGINT AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(255),

content VARCHAR(255),

author VARCHAR(255)

);



SHOW VARIABLES LIKE 'c%';

ALTER DATABASE metadb CHARACTER SET = 'utf8mb4' COLLATE = 'utf8mb4_general_ci';

SELECT * FROM Book;

SELECT @time_zone, NOW();