data troubles
Posted: Fri Nov 17, 2006 2:19 pm
i made a mistake when i was creating a one to one database relationship type....in the customer table "user_name" is the primary key....now in the merchant table...i made user_name being unique when in actuality it shouldent be...but now i cant fugure out how to change it back to just being a regular varchar....i tried this in my xampp...
but it gives me this as an error

Code: Select all
ALTER TABLE `merchant` DROP INDEX `user_name`, ADD `user_name` (`user_name`)please helpError
SQL query:
ALTER TABLE `merchant` DROP INDEX `user_name` ,
ADD `user_name` (
`user_name`
)
MySQL said:
#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 '(`user_name`)' at line 1