MySqlBackup.Net icon indicating copy to clipboard operation
MySqlBackup.Net copied to clipboard

Double quotes in create table instead of backtick?

Open fulviocanducci opened this issue 1 year ago • 1 comments

Example:

CREATE TABLE "backup" (
  "id" varchar(36) NOT NULL,
  "user_id" int NOT NULL,
  "file_name_sql" varchar(19) NOT NULL,
  "file_name_zip" varchar(19) NOT NULL,
  "created_at" datetime NOT NULL,
  "deleted_at" datetime DEFAULT NULL,
  PRIMARY KEY ("id"),
  UNIQUE KEY "id_UNIQUE" ("id")
);

I'm backing up on a server at DigitalOcean and I had this surprise where it should be "" in double quotes, is there a way to configure this to always be backtick ""?

fulviocanducci avatar Jul 07 '22 02:07 fulviocanducci

You can have a look at the article: https://github.com/MySqlBackupNET/MySqlBackup.Net/wiki/Table-or-Column's-name-wrapped-with-double-quotes-in-stead-of-single-quote

adriancs2 avatar Jul 07 '22 03:07 adriancs2