{"id":50,"date":"2011-06-27T06:27:22","date_gmt":"2011-06-27T06:27:22","guid":{"rendered":"http:\/\/tech.avant.net\/q\/?p=50"},"modified":"2012-12-25T22:40:46","modified_gmt":"2012-12-25T22:40:46","slug":"mysql-c","status":"publish","type":"post","link":"https:\/\/tech.avant.net\/q\/mysql-c\/","title":{"rendered":"mysql \\c"},"content":{"rendered":"

The mysql command line interface provides several very useful shortcuts. For example, the ‘tee’ command will append everything to a specified outfile:<\/p>\n

\r\nmysql> \\T logfile.txt\r\nLogging to file 'logfile.txt'\r\n<\/pre>\n
The ‘clear’ command saves from accidentally hitting Ctrl-C and disconnecting from the database:<\/p>\n
\r\nmysql> select * from typo \\c\r\nmysql> \r\n<\/pre>\n
The ‘clear’ command is especially useful when you’re in the middle of a transaction or prepared statement:<\/p>\n
\r\nmysql> PREPARE useradd FROM \"INSERT INTO foobar_users (username) VALUES (?)\";\r\nQuery OK, 0 rows affected (0.02 sec)\r\nStatement prepared\r\n\r\nmysql> SET @user = I forgot\\c<\/strong>\r\nmysql> SET @user = 'joebob';\r\nQuery OK, 0 rows affected (0.01 sec)\r\n\r\nmysql> EXECUTE useradd USING @user;\r\nQuery OK, 1 row affected (0.01 sec)\r\n\r\nmysql> DEALLOCATE PREPARE useradd;\r\nQuery OK, 0 rows affected (0.00 sec)\r\n<\/pre>\n
The ‘pager’ command is very useful for viewing large result sets in any externally callable program, for example,<\/p>\n
\r\nmysql> \\P less -n -i -S\r\nPAGER set to 'less -n -i -S'\r\nmysql> select * from foobar_users; -- viewed in a horizontal and vertical scrolling screen\r\n<\/pre>\n
And the shortcuts to turn off ‘pager’ and ‘tee’<\/p>\n
\r\nmysql> \\n\r\nPAGER set to stdout\r\nmysql> \\t\r\nOutfile disabled.\r\nmysql>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
The mysql command line interface provides several very useful shortcuts. For example, the ‘tee’ command will append everything to a specified outfile: mysql> \\T logfile.txt Logging to file ‘logfile.txt’ The ‘clear’ command saves from accidentally hitting Ctrl-C and disconnecting from the database: mysql> select * from typo \\c mysql> The ‘clear’ command is especially useful […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[15],"tags":[],"_links":{"self":[{"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/posts\/50"}],"collection":[{"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/comments?post=50"}],"version-history":[{"count":10,"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/posts\/50\/revisions"}],"predecessor-version":[{"id":738,"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/posts\/50\/revisions\/738"}],"wp:attachment":[{"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/media?parent=50"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/categories?post=50"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/tags?post=50"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}