mycli icon indicating copy to clipboard operation
mycli copied to clipboard

Is it possible to disable quoting on auto-completed fields

Open scottchiefbaker opened this issue 7 years ago • 1 comments

I read the FAQ and the Docs but I didn't find anything about this issue.

Is it possible to disable quoting on auto-completed fields that do not require quoting? For example if I type:

SELECT CustID FROM C<tab>

I end up with this SQL:

SELECT CustID FROM `CustInfo`

The table name CustInfo doesn't need quoting, but mycli adds quoting to every field regardless. Is there a setting that I can apply to mycli will only quote fields that require quoting?

scottchiefbaker avatar Jul 16 '18 21:07 scottchiefbaker

I've tried many things to fix this issue.I searched for quotes in the search engine and even looked for corresponding parts from the whole file of Mycli. And at the end of many tests, I found that if the table name does not contain capital letters, there is no unnecessary quotation mark. So the way I'm trying to fix this issue is rename the table to lowercase. alter original_name rename New_name. If you change the new name to custinfo in this phrase, you can solve unnecessary quotation marks.

Yedam22 avatar May 07 '21 01:05 Yedam22