Hi There,
I'm using MySQL with PHP and am trying to alter a table. I need to insert a column into a table. I copied to an example from the MySQL docs however I got an error. I'm not sure if my permissions are set right or if I am screwing up.
Could someone please post a sample alter statement to add a new column to a table after a specific existing column (say "food").
Thanks,
-Dico
I'm using MySQL with PHP and am trying to alter a table. I need to insert a column into a table. I copied to an example from the MySQL docs however I got an error. I'm not sure if my permissions are set right or if I am screwing up.
Could someone please post a sample alter statement to add a new column to a table after a specific existing column (say "food").
Thanks,
-Dico