Useful MySQL commands

Nugget post (useful nuggets of information pertaining to MySQL) - Ubuntu mysql configuration (including username and password) is stored in: /etc/mysql/debian.cnf - Import data from csv file: LOAD DATA LOCAL INFILE '/importfile.csv' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3); - Database manipulation: show databases create database [dbname] drop … Continue reading Useful MySQL commands