need help learning my database

[Wizdom]

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

[Satish]

Let 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.

[Wizdom]

i 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>?

[Satish]

Hope you’re asking about adding a profile picture. If so, do as directed here Your Profile Picture In This Forum: Gravatar

[Author]

Posts