Hello, I know how to set up the mysql server database, tables, and fields. How to set it up so that each row how a number associated with it? Please let me know, thanks.
Define a column as an integer type with the AUTO_INCREMENT attribute. I normally use an unsigned integer since it (usually) does not make any sense to have negative numbers as IDs. Assuming you want this field to be the primary key:
ALTER TABLE `table_name` ADD COLUMN `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
Geeze Nog is there anything you can't do? You have to be the smartest coder I ever met! Can I add that code straight in after I click on "sql" at the database? Is there anything I should be careful about? As always, appreciated very much.
OK, as nervous as I was I bit the bullet and tried it. Once again you saved the day! I am sure I already sent you everything I had as a thank you previously, but I'll remember you if this web site ever starts making any money. You're my hero, thanks a lot!!!
Aww, shucks. :o
Believe me, there are a lot of programmers who are better than I am -- many of them regular contributors here. In any case, you're welcome. 🙂
