Thread: Anyone Know?
View Single Post
  #4  
Old 11-06-2004, 02:34 PM
Echoes
Sarnak
 
Join Date: Oct 2004
Posts: 56
Default

fixed that last 1 but says this now when i run the commands said before
Quote:

mysql> source doors_update.sql;
Query OK, 5249 rows affected (0.37 sec)
Records: 5249 Duplicates: 0 Warnings: 0

Query OK, 5249 rows affected (0.41 sec)
Records: 5249 Duplicates: 0 Warnings: 0

Query OK, 5249 rows affected (0.36 sec)
Records: 5249 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4) DEFAULT "0" N
OT NULL;
ERROR 1054: Unknown column 'liftheight' in 'doors'
mysql> ALTER TABLE `doors` ADD `size` SMALLINT(5) UNSIGNED DEFAULT "100" NOT NUL
L;
ERROR 1060: Duplicate column name 'size'
mysql>
__________________
Reply With Quote