CREATE DATABASE mylibrary DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci;drop database mylibrary;