· 8 years ago · Mar 08, 2018, 10:22 PM
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;
15
16INSERT INTO `persons` (`FirstName`, `LastName`, `Age`) VALUES
17('oooo', 'ffffffff', 10);