As with anything in our work we find the command line more efficient over time. Here is a good list of MySQL Commands which are easily forgotten in the day-to-day, like:
Here are two handy commands that aren't on the list:
1) Temporarily disable foreign key constraints:
Be sure to perform SET FOREIGN_KEY_CHECKS=1; afterward.
2) Change the current count of an AUTO_INCREMENT value:
ALTER TABLE t2 AUTO_INCREMENT = value;