> >This is my table: > > > >CREATE TABLE items ( > > id int(10) UNSIGNED NOT NULL default '0', > > itemid int(10) UNSIGNED NOT NULL auto_increment, > > PRIMARY KEY (`itemid`) > >); > > > >I'd like to get 100 itemid's for each id. > > > >Is that possible. If so, please show me how. > - you have id set as the primary key... which means each value of it > will be unique, so you cannot have more than one value of itemid for > each value of id.
Your right. I have changed the key to itemid. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]