تلك هى اوامر انشاء table
كود:
CREATE TABLE `games` (
`gId` smallint(5) unsigned NOT NULL auto_increment,
`gInCategory` tinyint(3) unsigned NOT NULL default '0',
`gSwfFile` varchar(100) NOT NULL default '',
`gName` varchar(100) NOT NULL default '',
`gVisible` tinyint(1) NOT NULL default '1',
`gOrder` smallint(5) NOT NULL default '0',
`gThumb` varchar(100) NOT NULL default '',
`gWidth` smallint(5) unsigned NOT NULL default '0',
`gHeight` smallint(5) unsigned NOT NULL default '0',
`gDescription` varchar(100) NOT NULL default '',
`gplays` smallint(5) unsigned NOT NULL default '0',
`description2` text NOT NULL,
`sponsor_name` varchar(255) NOT NULL default '',
`sponsor_link` varchar(255) NOT NULL default '',
`playstoday` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`gId`),
UNIQUE KEY `gName` (`gName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3999 ;
هذا هو الخطا
كود:
SQL query:
INSERT INTO `games`
VALUES ( 2618, 5, '20302.swf', 'Techno Bounce', 1, 0, '20302.png', 490, 490, 'Va trebui sa folosesti caramizile pentru a tine mingea in aer!', 1402, '', '', '', 1402 ) ;
MySQL said: Documentation
#1062 - Duplicate entry 'Techno Bounce' for key 2
ارجوا المساعده