View Single Post
  #3  
Old 08-10-2006, 12:49 AM
johane
Sarnak
 
Join Date: Sep 2005
Location: Gold Coast, Oz
Posts: 69
Default

Quote:
Originally Posted by greneday
I looked around, and tried to on my own, but I just do not know how to impliment the change logs into my database.

ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;
when plugged into mysql, or saved as a sql file and tried to query, it just gives me syntax errors.
Don't use the character ` for quotes, use the character ' .

That's the single quote near your enter key, NOT the one near your escape key (assuming you have a standard US keyboard layout).

Last edited by johane; 08-10-2006 at 08:59 AM..
Reply With Quote