- 论坛徽章:
- 0
|
我这儿正常:
- mysql> CREATE TABLE domaininfo (
- -> domain_id int(5) NOT NULL auto_increment,
- -> domain varchar(25) NOT NULL default '',
- -> alias varchar(30) default NULL,
- -> passwd varchar(35) NOT NULL default '',
- -> usernum int(5) NOT NULL default '0',
- -> quota int(11) NOT NULL default '0',
- -> des varchar(30) default NULL,
- -> expire date NOT NULL default '0000-00-00',
- -> active tinyint(1) NOT NULL default '1',
- -> create_time datetime default NULL,
- -> PRIMARY KEY (domain_id),
- -> UNIQUE KEY domain (domain),
- -> KEY domain_id (domain_id)
- -> ) TYPE=MyISAM COMMENT='domain information';
- Query OK, 0 rows affected (0.04 sec)
- mysql>
复制代码
会不会是mysql版本不同的原因,你是什么版本?我的是4.0.x的
- mysql> status
- --------------
- /usr/local/bin/mysql Ver 12.22 Distrib 4.0.26, for unknown-freebsd6.1 (i386)
- Connection id: 17236
- Current database: test
- Current user: root@localhost
- SSL: Not in use
- Current pager: more
- Using outfile: ''
- Server version: 4.0.26 CNFUG Optimized
- Protocol version: 10
- Connection: Localhost via UNIX socket
- Client characterset: gb2312
- Server characterset: gb2312
- UNIX socket: /tmp/mysql.sock
- Uptime: 17 days 10 hours 5 min 29 sec
- Threads: 1 Questions: 86189 Slow queries: 0 Opens: 95 Flush tables: 2 Open tables: 46 Queries per second avg: 0.057
- --------------
复制代码 |
|