You are here

Changing/customizing MySQL's command prompt

Submitted by Druss on Mon, 2015-10-26 12:10

I wanted to add a timestamp to my MySQL command prompt to keep a track of when the previous command on my screen was executed (my mysql window is open all the time). As per MySQL's docs, this can be done with something like:

mysql>  prompt [\w, \R:\m]> 
PROMPT set to '[\w, \R:\m]> '
[Sun, 12:30]>

(Note that there's a space after the > in the prompt command.)

The other options for the prompt command are:

A counter that increments for each statement you issue
The full current date
The default database
The server host
The current delimiter
Minutes of the current time
A newline character
The current month in three-letter format (Jan, Feb, …)
The current month in numeric format
The current TCP/IP port or socket file
The current time, in 24-hour military time (0–23)
The current time, standard 12-hour time (1–12)
Seconds of the current time
A tab character
Your full user_name@host_name account name
Your user name
The server version
The current day of the week in three-letter format (Mon, Tue, …)
The current year, four digits
The current year, two digits
A space
A space (a space follows the backslash)
Single quote
Double quote
A literal "\" backslash character
x, for any "x" not listed above