Anonymous

CREATE TABLE `File` (
  `FileId` int(10) unsigned NOT NULL auto_increment,
  `FileIndex` int(10) unsigned NOT NULL default '0',
  `JobId` int(10) unsigned NOT NULL default '0',
  `PathId` int(10) unsigned NOT NULL default '0',
  `FilenameId` int(10) unsigned NOT NULL default '0',
  `MarkId` int(10) unsigned NOT NULL default '0',
  `LStat` tinyblob NOT NULL,
  `MD5` tinyblob NOT NULL,
  PRIMARY KEY  (`FileId`),
  KEY `JobId` (`JobId`),
  KEY `JobId_2` (`JobId`,`PathId`,`FilenameId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=4294967295


mysql> INSERT INTO File (FileIndex,JobId,PathId,FilenameId,MarkId,LStat) select FileIndex,JobId,PathId,FilenameId,MarkId,LStat from File where FileId=1153883883;
Query OK, 1 row affected, 1 warning (0.00 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> INSERT INTO File (FileIndex,JobId,PathId,FilenameId,MarkId,LStat) select FileIndex,JobId,PathId,FilenameId,MarkId,LStat from File where FileId=1153883883;
ERROR 1062 (23000): Duplicate entry '1153883873' for key 1
mysql> 

mysql> SELECT * FROM File WHERE FileId=1153883883;
+------------+-----------+-------+---------+------------+--------+--------------------------------------------------+-----+
| FileId     | FileIndex | JobId | PathId  | FilenameId | MarkId | LStat                                            | MD5 |
+------------+-----------+-------+---------+------------+--------+--------------------------------------------------+-----+
| 1153883883 |        11 |  8270 | 1680137 |          1 |      0 | A A EH/ B A A A A A A BHtRbO BHtLaP BEcKPM A A L | 0   | 
+------------+-----------+-------+---------+------------+--------+--------------------------------------------------+-----+
1 row in set (0.00 sec)

mysql>