AnalyticDB:Navicat Premium

Test environment

Test scope

• Connectivity: In Navicat, edit a MySQL connection. Set the connection name to ADB3.0, the host to 127.0.0.1, and the port to 3303. Enter your username and password, select the Save password checkbox, and then click Test Connection. A Connection Successful message confirms a valid connection.
• List databases: The test database is test4dmp (ADB3.0 connection). It contains the following tables: binary_test, course, dimension_test_date, dimension_test_date_1, dimension_test_id, dimension_test_id_1, dimension_test_int, dimension_test_int_1, dimension_test_timestamp, dimension_test_timestamp_1, elective, grade, keyword_test, large_decimal_test, student, test, and test_datatype_list. All tables use the InnoDB storage engine and the utf8_bin collation.
• Create table:

  DROP TABLE IF EXISTS `school`;
  CREATE TABLE `school` (
      `id` bigint NOT NULL,
      `name` varchar,
      `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
      key status_idx(`name`),
      primary key (id)
  ) DISTRIBUTE BY HASH(`id`);

• List all tables: In the test4dmp database on ADB3.0, run show tables;. The command returns 18 tables, including binary_test, course, dimension_test_date, dimension_test_id, dimension_test_int, dimension_test_timestamp, elective, grade, keyword_test, large_decimal_test, school, student, test, and test_datatype_list.
• View table schema: Run show create table school; to view the DDL statement for the school table. The school table has four columns: id (bigint, primary key, NOT NULL), name (varchar), create_time (timestamp, NOT NULL), and update_time (timestamp, NOT NULL).
• Write data to a table: Run the SQL statement insert into school (id, name) value (1,'a');. The statement executes successfully, returning Affected rows: 1.
• Create view: In the SQL editor, run the statement CREATE VIEW school_view as select * from school;. The statement returns OK, indicating that the view was created successfully.
• View view structure: In the SQL editor, run SHOW CREATE VIEW school_view;. The output shows the view's definition, CREATE VIEW test4dmp.school_view AS SELECT *, along with the character_set_client (utf8) and collation_connection (utf8_general_ci) settings.
• Query a view: In the SQL editor, run select * from school_view;. The query returns one row with the following values: ID=1, NAME=a, CREATE_TIME=2019-11-19 16:20:02.373, UPDATE_TIME=2019-11-19 16:20:02.373.