increment number
-
how to generate field number by increment (+1) in table mysql using PHP after inserting and deleting data? ex: Number 1A (next) 2A 3A
-
how to generate field number by increment (+1) in table mysql using PHP after inserting and deleting data? ex: Number 1A (next) 2A 3A
In SQL Server Management Studio (SSMS), in the Object Explorer, connect to your Database Engine, Databases, Expand your Database Name, Expand Tables, Right - click the Table Name in which you wish to have the increment number and select Modify from the context menu. You will see the column names in that particular table. Just select the column where you want the increment number and in the bottom in the Column Properties window, Expand Identity Specification. In the (Is Identity) from the drop down list select Yes and you will see the Identity Increment as 1 by default. That is what you need. If you wish you can change it also to 2 or some other number as you wish. Hope this helps. I was to descriptive to answer this simple question, but I am not sure how much do you know about it, so I thought of starting from the scratch. Good Luck.
-
how to generate field number by increment (+1) in table mysql using PHP after inserting and deleting data? ex: Number 1A (next) 2A 3A
Are those "A"s part of the "number"? :confused: If so, I don't think the system can do it automatically, you'd have to roll your own.
-
how to generate field number by increment (+1) in table mysql using PHP after inserting and deleting data? ex: Number 1A (next) 2A 3A
why you dont declare the column in the design of table auto increamnet ?