How can I set up integers in phpMyAdmin to be unsigned by default?

Question

How can I set up integers in phpMyAdmin to be unsigned by default? Most times I am setting them to be auto-incremented, and I don't need the negative values. Is there a way I can do this?

Answer 1

This is possible in the later version of phpMyAdmin using the Attributes option.

Answer 2

1. Setting integers unsigned via UI.

   • Open the dropdown menu against the Attributes column in the table structure.
   • Select "unsigned" and click save.

Unfortunately there doesn't seem to be a way to do this by default. However you can check multiple columns and click edit to change those at once via the phpmyadmin UI as shown below.