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   


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 .
















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