Creating views: Create View name [(column name 1, column Name 2, ... )] As a complex SELECT statement; View using: SELECT * from view name where Condition order by ..... Modify view: Alter VIEW name [(column name 1, column Name 2, ... )] AS SELECT statement; Delete view: Name of Drop view [if exists] view; MySQL creation User: Create username ' @ ' allow its login address ' identified by ' password '; Delete User: Drop User ' username ' @ ' Allow login address '; Change Password: Modify your password: set password = password (' new password '); modify others password (must have Modify permission): Set password for ' username ' @ ' allow it to log in address ' = password (' new password '); Add permission: Grant permission name 1, permission Name 2, .... on database name. The object name to ' user name ' @ ' allows its login address ' identified by ' password '; Delete permission: Revoke permission name 1, permission Name 2, .... on database name. Object name from ' username ' @ ' allow it to log in address ';
0815 MySQL view, user