How to add template in codeigniter |how to create template in codeigniter| template in codeigniter 4
In this article I am going to show you how to set auto increment while creating a table. As you know we need an ID field in a table which is unique and its need to be auto increment. If you set ID as auto increment then you don’t need to be increment its value from your coding. So if we set auto increment It’s value will be increase automatically by plus one.
AutoIncrement
CREATE TABLE user ( ID int NOT NULL AUTO_INCREMENT, firstname varchar(265) NOT NULL, lastname varchar(265), age int, PRIMARY KEY (ID) );
Related posts