How do I update this?

[BrentonHale]

i dont know how to update my mysql statement..  I forgot an "S" on the end of something. Let me show you what I mean:

 

 

CREATE TABLE url_associations (ua_id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT,
url_id SMALLINT(4) UNSIGNED NOT NULL, url_category_id TINYINT(3) UNSIGNED NOT NULL,
date_submitted TIMESTAMP, approved CHAR(1) DEFAULT 'N' NOT NULL, PRIMARY KEY (ua_id));

 

see where it says "url_associations"  I forgot the "s" there.  How do I update this?

 

i think u start out using UPDATE content (which is the tablename) but after that im lost

[cags]

The UPDATE syntax is for updating data in a table, if you wish to modify the table structure itself you are probably looking for the ALTER syntax. Though having said that I'm not entirely clear on what exactly you are wishing to change. It appears you maybe want to rename the table, this can be done with the RENAME TABLE syntax (or I believe it can be done with ALTER TABLE if you really wanted).