0

Sybase PowerDesigner Version 16.0.0.3514
Current DBMS mysql 5.0

Generate SQL

enter image description here

In fact, I want to add backquote around the field name, like this

enter image description here

How to configure it?

S.I.
  • 3,250
  • 12
  • 48
  • 77
iuha
  • 1
  • What have you tried to achieve your wanted results? What has your research concerning your problem shown? Can you provide code of your tries? [How do I ask a good question](https://stackoverflow.com/help/how-to-ask), [How much research effort is expected](https://meta.stackoverflow.com/questions/261592/how-much-research-effort-is-expected-of-stack-overflow-users) and [How to create a Minimal, Complete, and Verifiable example](https://stackoverflow.com/help/mcve) might be helpful to improve your question. – Geshode Jan 16 '18 at 07:23
  • Why do you want to add quotes? – pascal Jan 16 '18 at 14:20
  • The field name and reserved word repeatedly conflict – iuha Jan 17 '18 at 04:58
  • The list of known reserved words is in `Script\Sql\Keywords\ReservedWord`. If you enhance the list, the reserved words should be automatically quoted when used as identifiers. – pascal Jan 17 '18 at 11:14

1 Answers1

0

Assuming the reason to add quotes is to preserve case-sensitivity (not sure whether MySQL supports it)...

  • create your own copy of the MySQL DBMS,
  • add an item CaseSensitivityUsingQuote under Script > Sql > Format (Add items... in the contextual menu on Format),
  • set it to Yes.
pascal
  • 3,287
  • 1
  • 17
  • 35