Im a newbie at this stuff, so could someone please post how to alter a table so that i can make a field called numbers to be auto incremented. I dont know how to do this please. The table is called blog. Or can you post how to setup a auto incremented field. Thanks. Oh and i use phpmyadmin!
jakx12 0 Junior Poster
nav33n 472 Purple hazed! Team Colleague Featured Poster
If you 'investigate' properly in phpmyadmin, there is an option exactly below the table's structure to add a new column. You can specify the columnname, its datatype and mention "auto_increment" under extra. :-) Its quite simple.
ALTER TABLE tablename ADD columnname INT NOT NULL AUTO_INCREMENTis the query (just in case if you can't find it!)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.