Auto increment alter mysql example

Auto increment:

If any of your primary field need to be auto incremented. You can alter the column like below or you can create the sequences also for the same.

[sql]ALTER TABLE search modify COLUMN id INT NOT NULL AUTO_INCREMENT;[/sql]

Here search is the table name.
id is the column name.

While inserting you can put null or 0 for id(auto increment) column.