07/24: MySQL > Client Program
Category: Study
Posted by: hajime osako
Excute SQL from shell shell> mysql -e (or --excute) "SELECT DATABASE(); SELECT VERSION();" Statement Terminators \c to cancel current statement \q to exit mysql comand console \g is terminator \G is terminator plus output vertically Using Script Files mysql> SOURCE input_file shell> mysql de_name < input_file Output Formats --batch (or -B) tab-delimited output --table (or -t) tabular output --html (or -H) HTML format --xml (or -X) XML format Clinet Commands and SQL statements mysql> STATUS; mysql> HELP item;