SQL ALTER Command

 Field  Type Attributes Null Default Extra
 id  int(2)   No    auto_increment 
 name  varchar(50)   No     
 class  varchar(10)   No     
 mark  int(3)   No   

Subscribe to our YouTube Channel here


Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com



    tamil

    10-02-2009

    This site looks good
    nandy

    25-02-2010

    Very useful and reference-friendly.
    Dave

    26-09-2010

    I noticed that the code to make a field unique and auto_increment is PHP code, not a direct SQL command, while the code for changing the name of a field is straight SQL code. I am inexperienced in PHP however I can use SQL commands fine. Please tell me the equivalent SQL code for making a field unique and auto_increment. Removing the quotes, parens and variable names does not seem to work.
    smo

    26-09-2010

    These are SQL commands only. There is no PHP code here. Tested in phpmyadmin with MySQL
    bhavik

    19-03-2011

    i have 1 question. first we create table and define two column id and name. but that time we missed to define id as auto_increment, now what we do. i want solved this problem with query. can we do that with ATLER TABLE ? please give me the answer sir...

    Post your comments , suggestion , error , requirements etc here .





    SQL Video Tutorials










    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2024 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer