![]() ![]() Example: We will create Students table with fields Student_ID, First_Name, Last_Name, we will auto generate Student_ID by using auto increment and will make it Primary Key for the table. By default, the AUTO_INCREMENT starts with 1 and increases by 1. Summary: in this tutorial, you will learn about SQLite AUTOINCREMENT column attribute and when to use it in your table. SQLite AUTOINCREMENT is a keyword used for auto incrementing a value of a field in the table. ![]() MySQL Auto Increment : In MySQL, AUTO_INCREMENT keyword is employed for auto increment feature. INSERT INTO Students(First_Name, Last_Name )
0 Comments
Leave a Reply. |