I have a pre-existing table, containing ‘fname’, ‘lname’, ’email’, ‘password’ and ‘ip’. But now I want an auto-increment column id. However, when I enter:
ALTER TABLE `myTable` ADD COLUMN `id` INT AUTO_INCREMENT UNIQUE FIRST;
March 8, 2020 in MySql, Tips and Tricks
I have a pre-existing table, containing ‘fname’, ‘lname’, ’email’, ‘password’ and ‘ip’. But now I want an auto-increment column id. However, when I enter:
ALTER TABLE `myTable` ADD COLUMN `id` INT AUTO_INCREMENT UNIQUE FIRST;
Explore powerful AI-driven tools for daily guidance, spirituality, fun quizzes, and self-discovery.
Reveal insights about your future, love, and career with AI tarot readings.
Read TarotView daily Panchang, auspicious timings, tithi, nakshatra, and festivals.
View PanchangDiscover your destiny number, life path, and numerology predictions.
Calculate Now