- Release Notes and Announcements
- Product Introduction
- Kernel Features
- Purchase Guide
- Getting Started
- Operation Guide
- Instance Management
- Cluster Management
- Upgrading Version
- Scaling Instance
- Database Audit
- Account Management
- Database Management
- Parameter Configuration
- Multi-AZ Deployment
- Backup and Rollback
- Migrating Data
- Network and Security
- Monitoring and Alarms
- Basic SQL Operations
- Connecting to TDSQL-C for MySQL Through SCF
- White Paper
- API Documentation
- History
- API Category
- Making API Requests
- Instance APIs
- ActivateInstance
- UpgradeInstance
- SetRenewFlag
- OfflineCluster
- ModifyMaintainPeriodConfig
- IsolateInstance
- IsolateCluster
- DescribeMaintainPeriod
- DescribeInstanceSpecs
- DescribeClusters
- DescribeClusterDetail
- CreateClusters
- AddInstances
- OfflineInstance
- DescribeInstanceDetail
- DescribeClusterInstanceGrps
- DescribeInstances
- ModifyInstanceName
- ModifyClusterName
- Account APIs
- Backup and Restoration APIs
- Parameter Management APIs
- Serverless APIs
- Other APIs
- Data Types
- Error Codes
- FAQs
- TDSQL-C Policy
- Glossary
- Contact Us
- Release Notes and Announcements
- Product Introduction
- Kernel Features
- Purchase Guide
- Getting Started
- Operation Guide
- Instance Management
- Cluster Management
- Upgrading Version
- Scaling Instance
- Database Audit
- Account Management
- Database Management
- Parameter Configuration
- Multi-AZ Deployment
- Backup and Rollback
- Migrating Data
- Network and Security
- Monitoring and Alarms
- Basic SQL Operations
- Connecting to TDSQL-C for MySQL Through SCF
- White Paper
- API Documentation
- History
- API Category
- Making API Requests
- Instance APIs
- ActivateInstance
- UpgradeInstance
- SetRenewFlag
- OfflineCluster
- ModifyMaintainPeriodConfig
- IsolateInstance
- IsolateCluster
- DescribeMaintainPeriod
- DescribeInstanceSpecs
- DescribeClusters
- DescribeClusterDetail
- CreateClusters
- AddInstances
- OfflineInstance
- DescribeInstanceDetail
- DescribeClusterInstanceGrps
- DescribeInstances
- ModifyInstanceName
- ModifyClusterName
- Account APIs
- Backup and Restoration APIs
- Parameter Management APIs
- Serverless APIs
- Other APIs
- Data Types
- Error Codes
- FAQs
- TDSQL-C Policy
- Glossary
- Contact Us
This document describes common SQL commands.
For more information on SQL commands, including command parameters and restrictions, see MySQL 5.7 Reference Manual.
Querying Version
Method 1:
MySQL [(none)]> SELECT CYNOS_VERSION();
+------------------------+
| CYNOS_VERSION() |
+------------------------+
| 5.7.mysql_cynos.1.3.10 |
+------------------------+
1 row in set (0.00 sec)
Method 2:
MySQL [(none)]> SELECT @@CYNOS_VERSION;
+------------------------+
| @@CYNOS_VERSION |
+------------------------+
| 5.7.mysql_cynos.1.3.10 |
+------------------------+
1 row in set (0.00 sec)
Method 3:
MySQL [(none)]> SHOW VARIABLES LIKE 'CYNOS_VERSION';
+---------------+------------------------+
| Variable_name | Value |
+---------------+------------------------+
| cynos_version | 5.7.mysql_cynos.1.3.10 |
+---------------+------------------------+
1 row in set (0.01 sec)
Database Commands
| Command | Example |
|---|---|
| Creates database and specifies character set | create database db01 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci; |
| Drops database | drop database db01; |
Account Commands
| Command | Example |
|---|---|
| Creates account | CREATE USER 'username'@'host' IDENTIFIED BY 'password'; |
| Drops account | DROP USER 'username'@'host'; |
| Grants permission | GRANT SELECT ON db01.* TO 'username'@'host'; |
| Queries accounts in database | SELECT user,host,password FROM mysql.user_view;or show grants for xxx |
| Revokes permission | Revokes all permissions: REVOKE ALL PRIVILEGES,GRANT OPTION FROM 'username'@'host';Revokes specified permission: REVOKE UPDATE ON *.* FROM 'username'@'host'; |
Yes
No
Was this page helpful?