mysql数据库新建一个递增的_MySQL数据库--怎样创建一张用户表,ID设置为自动增长列(新手必会)...

CREATE TABLE IF NOT EXISTS `users` (

`id` int(9) NOT NULL AUTO_INCREMENT,

`name` varchar(32) NOT NULL,

`full_name` varchar(255) NOT NULL,

`password` varchar(64) NOT NULL,

`login_count` int(10) unsigned NOT NULL DEFAULT '0',

`last_login` int(10) unsigned NOT NULL DEFAULT '0',

`email` varchar(64) DEFAULT NULL,

`admin` tinyint(1) DEFAULT '0',

`guest` tinyint(1) DEFAULT '0',

`hash` char(32) DEFAULT NULL,

`url` varchar(255) DEFAULT NULL,

`locale` char(10) DEFAULT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `name` (`name`),

UNIQUE KEY `hash` (`hash`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

转存表中的数据 `users`

--

INSERT INTO `users` (`id`, `name`, `full_name`, `password`, `login_count`, `last_login`, `email`, `admin`, `guest`, `hash`, `url`, `locale`) VALUES(1, 'guest', 'Guest User', '', 0, 0, NULL, 0, 1, NULL, NULL, NULL),

(2, 'admin', 'Gallery Administrator', '', 0, 0, 'unknown@unknown.com', 1, 0, NULL, NULL, NULL);

本文转载