Cineva priceput in mysql ?[REZOLVAT]

[WISHEXEC]

Instructiunea :

Code: Select all

CREATE TABLE IF NOT EXISTS `wc3_player` ( `player_id` int(8) unsigned NOT NULL auto_increment, `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `time` timestamp(14) NOT NULL, PRIMARY KEY  (`player_id`), KEY `player_name` (`player_name`), KEY `player_ip` (`player_ip`), KEY `player_steamid` (`player_steamid`) )

eroarea :

Code: Select all

[SQL] CREATE TABLE IF NOT EXISTS `wc3_player` ( `player_id` int(8) unsigned NOT NULL auto_increment, `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `time` timestamp(14) NOT NULL, PRIMARY KEY  (`player_id`), KEY `player_name` (`player_name`), KEY `player_ip` (`player_ip`), KEY `player_steamid` (`player_steamid`) )

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, PRIMARY KEY  (`player_id`), KEY `player_name` (`player_name`), KE' at line 1

ce e gresit la sintaxa asta?

[The Kalu]

Acuma ar trebui sa fie ok.

Code: Select all

CREATE TABLE IF NOT EXISTS `wc3_player` ( 
       `player_id` int(8) unsigned NOT NULL auto_increment, 
       `player_steamid` varchar(25) NOT NULL default '', 
       `player_ip` varchar(20) NOT NULL default '', 
       `player_name` varchar(35) NOT NULL default '', 
       `timp` timestamp(6) NOT NULL,
       PRIMARY KEY  (`player_id`), 
       KEY `player_name` (`player_name`), 
       KEY `player_ip` (`player_ip`), 
       KEY `player_steamid` (`player_steamid`) 
)

[WISHEXEC]

nu e de la asta si daca modific tot la fel da

Code: Select all

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL,
       PRIMARY KEY  (`player_id`), 
       KEY `player_name` (`p' at line 6