Another tool I’ve been becoming more familiar with for sites that don’t have phpMyAdmin to access the MySQL databases is Sequel Pro. It’s an open source application for managing SQL databases on the Mac. I have come to appreciate it in newfound ways after the UNLV migration; it is to databases management what Transmit has been to moving around files via FTP. Anyway, one think I discovered it can do is copy the structure of a database table, such as wp_users:
And then insert it as SQL code in something like PHPMyAdmin:
Sequel Pro does all SQL query structuring for me, which is awesome. Was a nice little bonus to discover, and another trick for the toolbox.