I am using MySQL 5.1. As a rookie, here are some basic command commands I feel useful to rememberknow.
Some basic mysql commands
Use mysql client to access the database.
Panel |
---|
% $ myslq -u database-user -p |
Show databases
...
No Format |
---|
SELECT ... FROM ... INTO OUTFILE '/tmp/sqlresultsqlresults.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n'; |