Quote:
|
INSERT INTO VARIABLES VALUES ('MOTD','Welcome to EverQuest!','Server Message of the Day',20060411132036);
|
2 solutions but you don't give enough informations :(
1/
because you try to INSERT variables which already exist
In mysql commands INSERT is for new data
you must use REPLACE for change data
2/
Because VARIABLES table isn't exist
Create it with :
Quote:
CREATE TABLE `variables` (
`varname` varchar(25) NOT NULL default '',
`value` text NOT NULL,
`information` text NOT NULL,
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
But my advice is to learn more about mysql in internet guide
__________________
__________________________________________________ _____________________________________
I speak english like a spanish cow..., I speak spanish like a english pudding...
But I try to speak good french !!! (Non au langage SMS sur forum)
http://eqfroggy.new.fr : Froggy French Server Website.
Threaded Mode
