Now that the ProductId column uses the auto-increment feature, we can insert values for the ProductName and QuantityInStock columns and get the ProductId column values automatically generated for us. ProductId INTEGER NOT NULL AUTO_INCREMENT, To achieve this, we use this CREATE TABLE statement: The ProductId numbers are assigned in order of products’ insertion into the database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |