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.
|
Assuming that everything is installed as defaults, see if this helps:
goto c:\mysql\bin>
Type in mysql -ueq -p peq (peq if your using peq database or eq if your using cavedude's database)
Enter your password. You should now be at a mysql> prompt
TYpe in the Changes
ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;
If you get an error, leave off the ` around traps, message and effectvalue2
when your done, type in quit to exit mysql.