Who am I?

From SQLZOO
Revision as of 14:46, 17 July 2012 by Connor (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Who am I - what is my user id?

schema:gisq

Find the user name or user id. The SQL standard permits the function USER

 
 
SELECT USER FROM anyoldtable
SELECT USER FROM anyoldtable
SELECT USER FROM anyoldtable
SELECT USER FROM anyoldtable
SELECT USER
SELECT USER, uid FROM dual
USE scott;
SELECT USER, user_id();
USE gisq;
SELECT USER, user_id()
SELECT USER()
SELECT USER FROM anyoldtable
USE scott;
SELECT USER, user_id();
USE gisq;
SELECT USER, user_id()
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense