Auto increment in phpmyadmin

by

There are possible steps to enable auto increment for a column. I guess the phpMyAdmin version is 3.5.5 but not sure.

Click on Table > Structure tab > Under Action
Click Primary (set as primary),
click on Change on the pop-up window, scroll left and check A_I. Also make sure you have selected None for Defaultenter image description here

More Related Contents:

  1. Can I store query result of one field into different variables? if not then what should I do for that?
  2. how to compare the two fields in php with different table in mysql?
  3. Php foreach give 2 users random value
  4. The requested URL was not found on this server.
  5. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  6. How to write a stored procedure using phpmyadmin and how to use it through php?
  7. phpmyadmin – count(): Parameter must be an array or an object that implements Countable
  8. Import file size limit in PHPMyAdmin
  9. “Connection for controluser as defined in your configuration failed” with phpMyAdmin in XAMPP
  10. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  11. Mysql event error using php
  12. Call to undefined function __() error – phpMyAdmin
  13. Access denied for user ‘root’@’localhost’ with PHPMyAdmin
  14. Store procedures in phpMyAdmin
  15. How to connect sql server with php using xampp?
  16. How to solve time out in phpmyadmin?
  17. WAMP/MySQL errors not in correct language
  18. phpmyadmin automatic logout time
  19. WAMPServer phpMyadmin Maximum execution time of 360 seconds exceeded
  20. #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
  21. Unknown database error in PHP but it exists in PHPMyAdmin
  22. Extension mysqli is missing, phpmyadmin doesn’t work
  23. phpMyAdmin Error: The mbstring extension is missing. Please check your PHP configuration
  24. How to SELECT DEFAULT value of a field
  25. How to log in to phpMyAdmin with WAMP, what is the username and password?
  26. Auto Increment skipping numbers?
  27. save html-formatted text to database
  28. How to write a stored procedure in phpMyAdmin?
  29. Installing PDO driver on MySQL Linux server
  30. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

Leave a Comment