Handy MySQL Commands
Log into mysql: (enter password on next prompt) Show all databases on server: To reset an auto_increment field to 1: To load a local csv file into an empty existing table: (This assumes you’ve already created your empty table with…