mysql set current user as default value

Asked Apr 24 '19 at 16:28

Active Apr 24 '19 at 18:19

Viewed 1,285 times

I am making a table which will be filled with records uploaded from other devices and I want to make a column which value is the user, who uploaded it.

I know I can get the actual user with select CURRENT_USER(); , but can not make that user varchar(20) by selecting it like: user_id varchar(20) default select CURRENT_USER() LIMIT 1

edited Apr 24 '19 at 18:19

Janny

asked Apr 24 '19 at 16:28

Krisztián Villers

1

I think you have to use a trigger for this, because `current_user()` is a volatile function. – Gordon Linoff Apr 24 '19 at 16:30
1

https://stackoverflow.com/questions/270309/can-i-use-a-function-for-a-default-value-in-mysql – Alex M Apr 24 '19 at 16:31
That trigger in Alex's link is exactly what you need. Replace with something like `NEW.userwhouploadedit = CURRENT_USER()` – Thomas G Apr 24 '19 at 18:21

mysql set current user as default value

0 Answers0