Dgriff - 8:48 am on Jun 6, 2013 (gmt 0)
I don't know why I was doing both SELECT and ALTER TABLE! I'm quite new to this.
I ran this sql query:
ALTER TABLE 'blog_posts' CHANGE 'post_id' 'post_id' int(11) AUTO_INCREMENT PRIMARY KEY;
but I'm getting this error:
#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 ''blog_posts' CHANGE 'post_id' 'post_id' int(11) AUTO_INCREMENT PRIMARY KEY' at line 1
any ideas? Thanks for your help.