Help Center/ GaussDB(DWS)/ Tool Guide/ DSC/ SQL Syntax Migration Reference/ MySQL Syntax Migrating/ Data Manipulation Language (DML)/ SELECT/ Quotation Marks
Updated on 2024-07-19 GMT+08:00
View PDF
Share

Quotation Marks

Single Quotation Mark (')

Aliases in MySQL contain single quotation marks, which are not supported by GaussDB(DWS). DSC changes them to double quotation marks during migration.

Input

1
 
select name as 'mingzi' from t1;

Output

1
2
3
4
 
SELECT
  name AS "mingzi"
FROM
  t1;

Backquote (`)

Aliases and column names in MySQL contain backquotes, which are not supported by GaussDB(DWS). DSC changes them to double quotation marks during migration.

Input

1
 
select `name` as `mingzi` from t1;

Output

1
2
3
4
 
SELECT
  "name" AS "mingzi"
FROM
  t1;

Double Quotation Mark (")

In MySQL, constant strings are enclosed in double quotation marks, which are not supported by GaussDB(DWS). DSC changes them to single quotation marks during migration.

Input

1
 
select name from t1 where name = "test2";

Output

1
2
3
4
5
6
 
SELECT
  name
FROM
  t1
WHERE
  name = 'test2';
Parent topic: SELECT