Query: Get 100 itemid's for each id.

[Jacob Friis Larsen]

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 (`id`)
);

I'd like to get 100 itemid's for each id.

Is that possible. If so, please show me how.

Thanks,
Jacob

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]