MySQL Forums
Forum List  »  Newbie

Re: Trying to get Key Field to Auto Increment
Posted by: Dave Smith
Date: March 27, 2005 10:57PM

I am not sure how to do this with PHPMyAdmin; however, you need to add the auto_increment property to the `key` field definition. From the command line interface this would be...

ALTER TABLE pixs(CHANGE key INT(11) NOT NULL AUTO_INCREMENT);

I can't help you on the preview of a BLOB question.



Dave Smith

Options: ReplyQuote


Subject
Written By
Posted
Re: Trying to get Key Field to Auto Increment
March 27, 2005 10:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.