need help learning my database

Home Forums Programming PHP & MySQL need help learning my database

This topic contains 3 replies, has 2 voices, and was last updated by  Satish 5 years, 4 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #1407

    Wizdom
    Member

    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

    #1414

    Satish
    Keymaster

    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.

    #1418

    Wizdom
    Member

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

    #1419

    Satish
    Keymaster

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

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.