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'; |