Useful MySQL commands

# Set the auto_increment value (e.g. `id`) to one more the highest `id` value currently alter table `foo` auto_increment=1 # Show how MySQL will parse this query, including key (indices) used and any additional parameters explain select * from `foo`; # Show indices for the given table show keys from `foo`;

Read More Useful MySQL commands