Skip to content

Instantly share code, notes, and snippets.

@varmais

varmais/trigger.sql

Created July 21, 2015 15:31
Show Gist options
  • Save varmais/a3122235f2a499f03cbe to your computer and use it in GitHub Desktop.
Save varmais/a3122235f2a499f03cbe to your computer and use it in GitHub Desktop.
Download ZIP
Raw
trigger.sql
CREATE TRIGGER username AFTER INSERT ON user FOR EACH ROW
IF user.displayname IS NULL THEN
SET user.displayname := user.username;
END IF;;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment