in my MySql table i have a 'id' colum and i have it set to char(10) but for some reason, phpmyadmin keeps on changing it to varchar(10). is there anyway for me to generate a unique id for every entry.
Why not set the id column to int? And have an auto-increment? Like this:
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
