Difference between revisions of "MySQL"
From Useful Things
| Line 14: | Line 14: | ||
<syntaxhighlight lang="mysql"> | <syntaxhighlight lang="mysql"> | ||
drop user {database_user}@'%'; | drop user {database_user}@'%'; | ||
| + | </syntaxhighlight> | ||
| + | |||
| + | = Triggers = | ||
| + | |||
| + | == After update == | ||
| + | <syntaxhighlight lang="mysql"> | ||
| + | create trigger {trigger_name} after update on {table_name} | ||
| + | for each row begin | ||
| + | insert into {new_table} (..., ..., ...) values (..., ..., ...) | ||
| + | end | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 02:56, 26 June 2014
Contents
User management
Adding a user
grant all privileges on {database_name}.* to {database_user}@'%' identified by 'their_password';Revoking privileges
revoke usage on {databse_name}.* from {database_user}@'%';Removing a user
drop user {database_user}@'%';Triggers
After update
create trigger {trigger_name} after update on {table_name}
for each row begin
insert into {new_table} (..., ..., ...) values (..., ..., ...)
end