Adding mysql user to database <p>Is it possible to add mysql user into a database as column? </p> <p>Lets say we have a following table:</p> <pre><code>CREATE TABLE message( id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255), message TEXT, last_edited TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE=INNODB; </code></pre> <p>and we want to add 'editor' column which would get the current mysql user and insert it there and also updates it automatically similar to the behaviour of the TIMESTAMP datatype. Can this be done and if so what sort of datatype should I use (is there such a type as USER or should I use simple varchar) and what kind of syntax is involved?</p>