From 90b43201e560e0c0dd6af23520328161e2a03f0a Mon Sep 17 00:00:00 2001
From: Tom Ryder <tom@sanctum.geek.nz>
Date: Mon, 16 Sep 2013 19:33:59 +1200
Subject: Standard approach to database prompts

---
 mysql/my.cnf | 3 ++-
 psql/psqlrc  | 2 +-
 2 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/mysql/my.cnf b/mysql/my.cnf
index 1c55c791..be035865 100644
--- a/mysql/my.cnf
+++ b/mysql/my.cnf
@@ -1,3 +1,4 @@
 [mysql]
-prompt='(\u@\h)\n[\d] mysql> '
+prompt='(\u@\h:\d) mysql> '
+safe-updates
 
diff --git a/psql/psqlrc b/psql/psqlrc
index e3f4434b..d58e73e9 100644
--- a/psql/psqlrc
+++ b/psql/psqlrc
@@ -1,6 +1,6 @@
 \encoding unicode
 \pset null 'NULL'
 \set HISTSIZE 1000000
-\set PROMPT1 '(%n@%M:%>)\n[%/] psql> '
+\set PROMPT1 '(%n@%M:%>:%/) psql> '
 \timing
 
-- 
cgit v1.2.3