· 8 years ago · Mar 07, 2018, 01:38 AM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
4/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
5/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
6/*!40101 SET NAMES utf8 */;
7
8
9CREATE TABLE IF NOT EXISTS `persons` (
10 `FirstName` varchar(20) NOT NULL,
11 `LastName` varchar(20) NOT NULL,
12 `Age` int(11) NOT NULL,
13 UNIQUE KEY `FirstName` (`FirstName`)
14) ENGINE=MyISAM DEFAULT CHARSET=latin1;