Home › Forums › Programming › PHP & MySQL › need help learning my database
Tagged: auto_increment, mysql, php, primary key, query
- This topic has 3 replies, 2 voices, and was last updated 12 years, 8 months ago by Satish.
- AuthorPosts
- February 15, 2012 at 3:05 pm#1407WizdomMember
ok i got ur script running fine but trying to add auto_incrremnet and primary key
wanting to know how i add those command i am running Mysql 5.5 on a xampp sever
February 15, 2012 at 4:08 pm#1414SatishKeymasterLet me explain with phpmyadmin interface:
Start your xamp or wamp server software.
Right click to get a pop up menu, which has phpmyadmin interface link.On the left hand side ( in wamp ) you can see the list of databases you have created. Click or select the one you want to modify/update.
Select the table and then the field you want to modify.
Click on the Structure tab, there you can see key icon and pencil icon.
Click on key icon to make the field primary key.
Now click on pencil icon to edit the field, later you can see the AUTO_INCREMENT field. Click on the check box / select and make sure to SAVE it.
Now, the auto_increment can be checked by inserting some more records.
February 16, 2012 at 10:43 pm#1418WizdomMemberi knew how to get to that data base but was using command line didnt know i could edit there too i i was editing tyvm for ur help do have a question how u get custom profiles for each user to custom there own profile>?
February 17, 2012 at 6:40 am#1419SatishKeymasterHope you’re asking about adding a profile picture. If so, do as directed here Your Profile Picture In This Forum: Gravatar
- AuthorPosts
- You must be logged in to reply to this topic.