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> 


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

mysql> show table status like 'File';
+------+--------+---------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+---------------------+---------+
| Name | Engine | Version | Row_format | Rows     | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time          | Collation         | Checksum | Create_options      | Comment |
+------+--------+---------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+---------------------+---------+
| File | MyISAM |      10 | Dynamic    | 85316944 |            107 |  9266694376 | 281474976710655 |   3377016832 | 122211928 |     1153883873 | 2008-02-14 14:15:03 | 2008-02-15 15:32:46 | 2008-02-14 15:21:31 | latin1_swedish_ci |     NULL | max_rows=4294967295 |         | 
+------+--------+---------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+---------------------+---------+
1 row in set (0.00 sec)