全网最全MySQL Prompt

CREATE TABLE student_score (
   id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
   name VARCHAR(50) NOT NULL,
   score DECIMAL(5,1) NOT NULL,
   created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
   updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE student_score (
   id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
   name VARCHAR(50) NOT NULL,
   score DECIMAL(5,1) NOT NULL,
   created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
   updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

192.168.12.161,read_only,xxxxxx
192.168.12.162,read_only,xxxxxx

xtrabackup --defaults-file=/data/mysql/conf/my.cnf -uu_backup -p'Ujg8G_aUU' --backup --stream=xbstream --target-dir=./ >/data/backup/xtrabackup.xbstream

// This file is auto-generated, don't edit it. Thanks.
package main


import (
   "fmt"
   openapi "github.com/alibabacloud-go/darabonba-openapi/v2/client"
   rds20140815 "github.com/alibabacloud-go/rds-20140815/v3/client"
   util "github.com/alibabacloud-go/tea-utils/v2/service"
   "github.com/alibabacloud-go/tea/tea"
   "os"
)




/**
 * 使用AK&SK初始化账号Client
 * @param accessKeyId
 * @param accessKeySecret
 * @return Client
 * @throws Exception
 */
func CreateClient (accessKeyId *string, accessKeySecret *string) (_result *rds20140815.Client, _err error) {
   config := &openapi.Config{
      // 必填，您的 AccessKey ID
      AccessKeyId: accessKeyId,
      // 必填，您的 AccessKey Secret
      AccessKeySecret: accessKeySecret,
   }
   // Endpoint 请参考 https://api.aliyun.com/product/Rds
   config.Endpoint = tea.String("rds.aliyuncs.com")
   _result = &rds20140815.Client{}
   _result, _err = rds20140815.NewClient(config)
   return _result, _err
}


func _main (args []*string) (_err error) {
   // 请确保代码运行环境设置了环境变量 ALIBABA_CLOUD_ACCESS_KEY_ID 和 ALIBABA_CLOUD_ACCESS_KEY_SECRET。
   // 工程代码泄露可能会导致 AccessKey 泄露，并威胁账号下所有资源的安全性。以下代码示例使用环境变量获取 AccessKey 的方式进行调用，仅供参考，建议使用更安全的 STS 方式，更多鉴权访问方式请参见：https://help.aliyun.com/document_detail/378661.html
   client, _err := CreateClient(tea.String(os.Getenv("ALIBABA_CLOUD_ACCESS_KEY_ID")), tea.String(os.Getenv("ALIBABA_CLOUD_ACCESS_KEY_SECRET")))
   if _err != nil {
      return _err
   }


   describeSlowLogRecordsRequest := &rds20140815.DescribeSlowLogRecordsRequest{
      DBInstanceId: tea.String("rm-uf6img56ru4l61963"),
      StartTime: tea.String("2023-09-04T02:00Z"),
      EndTime: tea.String("2023-09-04T03:00Z"),
   }
   runtime := &util.RuntimeOptions{}
   tryErr := func()(_e error) {
      defer func() {
         if r := tea.Recover(recover()); r != nil {
            _e = r
         }
      }()
      // 调用API并获取返回结果
      response, _err := client.DescribeSlowLogRecordsWithOptions(describeSlowLogRecordsRequest, runtime)
      if _err != nil {
         return _err
      }


      // 打印API的输出结果
      fmt.Println(response)


      return nil
   }()


   if tryErr != nil {
      var error = &tea.SDKError{}
      if _t, ok := tryErr.(*tea.SDKError); ok {
         error = _t
      } else {
         error.Message = tea.String(tryErr.Error())
      }
      // 如有需要，请打印 error
      _, _err = util.AssertAsString(error.Message)
      if _err != nil {
         return _err
      }
   }
   return _err
}




func main() {
   err := _main(tea.StringSlice(os.Args[1:]))
   if err != nil {
      panic(err)
   }
}