Creating Database and Table

Last updated: 2020-06-15 13:02:51

    This document describes how to create databases and tables in TencentDB for MySQL instances.

    Concepts

    • Instance: a standalone database environment running in Tencent Cloud, which can include multiple databases created by users and can be accessed using the same tools and applications as those for a standalone database instance.
    • Database: a warehouse that organizes, stores, and manages data based on its structure.

    Creating Database

    1. Log in to the phpMyAdmin Console, click New or Databases to enter the database creation page.
    2. Enter the database name, select the collation (utf8_general_ci by default), and click Create.
      • Database name: a database name contains 1-64 characters, and must be unique in the instance.
      • Collation: click next to "Create database" to be redirected to MySQL official documentation for details.
    3. Select the desired database and click Operations on the navigation bar at the top to enter the database operation page, where you can Create table, Remove database, or perform other operations. You can also move, rename, or copy the database after creation.

    Creating Table

    1. Log in to the phpMyAdmin Console. Select the database where you want to create a table, click New or enter the table name and select the number of columns in the Create table bar, and then click Go.

      Table name: a table name contains 1-64 characters, and must be unique in the database.

    2. On the table creation page, if you need to add columns, you can enter the number of columns to be added in the Add box and then click Go. You can enter the column information in Structure and partition information in PARTITION definition (see MySQL partitioning chapter). After entering all the information, click Save to create the table.

      You can click next to the fields for more information.

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help