Save time and energy: How to … (… continued)

Posted: 2nd July 2009 by Darren Cassar in Beginner, Databases, MySQL

Earlier this year I had published a small blog about being efficient when using mysql prompt. This is a small continuation of it highlighting a couple of other cool features which I really find very useful when working command line (i.e. always!).

The first I’m gonna list here is setting the prompt itself by typing – \R mysql \D > thus enabling date and time display at each comand which is great for auditing and record keeping. There is a whole bunch of prompt values which you can find here:

Option Description
\c //A counter that increments for each statement you issue
\D //The full current date
\d //The default database
\h //The server host
\l //The current delimiter (new in 5.0.25)
\m //Minutes of the current time
\n //A newline character
\O //The current month in three-letter format (Jan, Feb, …)
\o //The current month in numeric format
\P //am/pm
\p //The current TCP/IP port or socket file
\R //The current time, in 24-hour military time (0–23)
\r //The current time, standard 12-hour time (1–12)
\S //Semicolon
\s //Seconds of the current time
\t //A tab character
\U //Your full user_name@host_name account name
\u //Your user name
\v //The server version
\w //The current day of the week in three-letter format (Mon, Tue, …)
\Y //The current year, four digits
\y //The current year, two digits
\_ //A space
\ //A space (a space follows the backslash)
\' '//Single quote
\" "//Double quote
\\ //A literal “\” backslash character
\x //x, for any “x” not listed above

The second thing is the \e or edit which lets you edit a long query you might have been writing, in any editor you have set on your machine, most often vi, a must know editor for all of you out there.


VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)