Studio DnB
Reputation: 19
PhpMyAdmin: What does the number next to a primary A_I column means?
I was wondering this since a guy was here checking my database and he expanded the primary column and grimmed a bit.
This is the screenshot of what I mean:
Upvotes: 0
Views: 726
Answers (1)
Miguel G. Flores
Reputation: 822
The number next the column in phpMyAdmin is the order of the ORDER BY, in some cases you can have more than one field in the ORDER BY clause and they will numbered.
Example:
Upvotes: 2
Related Questions
- Get the new record primary key ID from MySQL insert query?
- How do I restore a dump file from mysqldump?
- MySQL error code: 1175 during UPDATE in MySQL Workbench
- Finding duplicate values in MySQL
- Setting up foreign keys in phpMyAdmin?
- How can I find all the tables in MySQL with specific column names in them?
- What does SQL clause "GROUP BY 1" mean?
- What does the KEY keyword mean?
- What is the size of column of int(11) in mysql in bytes?