This topic lists some of the commonly used SQL statements.
For more information about the SQL statements including parameters and restrictions, see MySQL 5.7 Reference Manual.
Database-related SQL statements
Operation | Example |
---|---|
Create a database and designate a character set. |
|
Delete a database. |
|
Account-related SQL statementss
Note If an RDS instance has a premier account, the passwords of the other accounts under
this instance cannot be changed by using the premier account. To change the password
of another account, you must delete this account and create a new one.
Operation | Example |
---|---|
Create an account. |
|
Delete an account. |
|
Authorize the account. |
|
Query the created accounts in the database. |
or
|
Reclaim permissions. |
|