ubuntu 9.10 安装 Oracle 10g手记

mysql> CREATE TABLE IF NOT EXISTS `users` (
`User` varchar(16) NOT NULL default '',
`Password` varchar(32) NOT NULL default '',
`Uid` int(11) NOT NULL,
`Gid` int(11) NOT NULL,
`Dir` varchar(128) NOT NULL default '',
`QuotaFiles` int(10) NOT NULL default '500',
`QuotaSize` int(10) NOT NULL default '30',
`ULBandwidth` int(10) NOT NULL default '80',
`DLBandwidth` int(10) NOT NULL default '80',
`Ipaddress` varchar(15) NOT NULL default '*',
`Comment` tinytext,
`Status` enum('0','1') NOT NULL default '1',
`ULRatio` smallint(5) NOT NULL default '1',
`DLRatio` smallint(5) NOT NULL default '1',
PRIMARY KEY (`User`),
UNIQUE KEY `User` (`User`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

老是报错:

ERROR 1064 (42000):You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the rightsyntax to use neat ''users' ('User' varchar(16) NOT NULLdefault '','Password' varchar(32) NOT NULL' at line 1

mysql> CREATE TABLE IF NOT EXISTS `users` (
`User` varchar(16) NOT NULL default '',
`Password` varchar(32) NOT NULL default '',
`Uid` int(11) NOT NULL,
`Gid` int(11) NOT NULL,
`Dir` varchar(128) NOT NULL default '',
`QuotaFiles` int(10) NOT NULL default '500',
`QuotaSize` int(10) NOT NULL default '30',
`ULBandwidth` int(10) NOT NULL default '80',
`DLBandwidth` int(10) NOT NULL default '80',
`Ipaddress` varchar(15) NOT NULL default '*',
`Comment` tinytext,
`Status` enum('0','1') NOT NULL default '1',
`ULRatio` smallint(5) NOT NULL default '1',
`DLRatio` smallint(5) NOT NULL default '1',
PRIMARY KEY (`User`),
UNIQUE KEY `User` (`User`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

老是报错:

ERROR 1064 (42000):You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the rightsyntax to use neat ''users' ('User' varchar(16) NOT NULLdefault '','Password' varchar(32) NOT NULL' at line 1

mysql> CREATE TABLE IF NOT EXISTS `users` (
`User` varchar(16) NOT NULL default '',
`Password` varchar(32) NOT NULL default '',
`Uid` int(11) NOT NULL,
`Gid` int(11) NOT NULL,
`Dir` varchar(128) NOT NULL default '',
`QuotaFiles` int(10) NOT NULL default '500',
`QuotaSize` int(10) NOT NULL default '30',
`ULBandwidth` int(10) NOT NULL default '80',
`DLBandwidth` int(10) NOT NULL default '80',
`Ipaddress` varchar(15) NOT NULL default '*',
`Comment` tinytext,
`Status` enum('0','1') NOT NULL default '1',
`ULRatio` smallint(5) NOT NULL default '1',
`DLRatio` smallint(5) NOT NULL default '1',
PRIMARY KEY (`User`),
UNIQUE KEY `User` (`User`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

老是报错:

ERROR 1064 (42000):You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the rightsyntax to use neat ''users' ('User' varchar(16) NOT NULLdefault '','Password' varchar(32) NOT NULL' at line 1