[RESOLVED] Alter Column Set Default Error

[cisforcasey]

Hello,

I am trying to change the default value of a column in a table of mysql database with some PHP code. Here is my query:

$strSQL = "ALTER TABLE '$new_signup_list' ALTER COLUMN workshop SET DEFAULT '$new_workshop'";

Here is the error I am getting:

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 ''TF_20000601_signup_list' ALTER COLUMN workshop SET DEFAULT 'TF_20000601'' at line 1 : <strong>Sign up Alter Failed</strong>

My variables both have valid values. I'm almost positive my syntax is correct, but I guess not. I used this book (page 36) as a reference, as well as some other tutorials. Can anyone tell me what I'm doing wrong? Thanks a lot.

• Casey

[NogDog]

Use "back-ticks" (left quote "") around your table name, not straight quotes.
[code=php]
$strSQL = "ALTER TABLE$new_signup_list` ALTER COLUMN workshop SET DEFAULT '$new_workshop'";
[/code]

[cisforcasey]

great! thanks a lot. I was killing myself over that error.