I've created the following table (server 4.1 in win2k)
CREATE TABLE `os` (
`id` tinyint(10) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` varchar(255) default NULL,
PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
and was very surprised that I can do the following twice. Should'nt
this be rejected since name is a primary key ad has already been used?
INSERT INTO os (name,description) VALUES ( 'winxp','winxp');
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]