· 8 years ago · Nov 17, 2017, 01:00 PM
1CREATE DATABASE IF NOT EXISTS `mydata` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2USE `mydata`;
3CREATE TABLE `crud` (
4 `id` int(11) NOT NULL PRIMARY KEY,
5 `name` varchar(60) NOT NULL,
6 `email` varchar(45) NOT NULL,
7 `phone` varchar(20) NOT NULL,
8 `address` text NOT NULL
9) ENGINE=InnoDB DEFAULT CHARSET=latin1;