Help Center> Data Warehouse Service> Tool Guide> DSC - SQL Syntax Migration Tool> SQL Syntax Migration Reference> MySQL Syntax Migration> Comments
View PDF

Comments

MySQL uses a # character or a -- sequence to comment a single line, while GaussDB A uses a -- sequence. DSC will replace # with --.

Input

## comment sample create a table 
CREATE TABLE IF NOT EXISTS `public`.`runoob_tbl`( 
   `runoob_id` VARCHAR, 
   `runoob_title` VARCHAR(100) NOT NULL, 
   `runoob_author` VARCHAR(40) NOT NULL, 
   `submission_date` VARCHAR 
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

Output

-- comment sample create a table 
CREATE TABLE "public"."runoob_tbl" 
( 
  "runoob_id" VARCHAR, 
  "runoob_title" VARCHAR(100) NOT NULL, 
  "runoob_author" VARCHAR(40) NOT NULL, 
  "submission_date" VARCHAR 
) 
  WITH ( ORIENTATION = ROW, COMPRESSION = NO ) 
  NOCOMPRESS 
  DISTRIBUTE BY HASH ("runoob_id");
Parent topic: MySQL Syntax Migration