Skip to content

Bug: Escape Keys In SQL Statement #1074

@gerrior

Description

@gerrior

Describe the bug

Describe the bug
I long ago foolishly created a table called keys. I have to escape the table name every time I use it. SQLPro does not. Please escape this reserved word.

To Reproduce
Steps to reproduce the behavior:

  1. Update a field in the table and try to update. Sample SQL statement: UPDATE keys SET PaymentMethod = 6 WHERE KeyRecordNo = 2309 LIMIT 1;
  2. This results in: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'keys
    SET
    PaymentMethod = 6
    WHERE
    KeyRecordNo = 2309
    LIMIT 1' at line 2. (Error Request: Easy way to migrate existing database connection profiles from an old laptop to a new laptop #1064)

Expected behavior
Escape (backtick) Keys and it will work. e.g.

UPDATE `keys` SET PaymentMethod = 6 WHERE KeyRecordNo = 2309 LIMIT 1;

Product

SQLPro Studio

App version

Version 2025.1 (Build 111120)

Platform

macOS

Installation source

Setapp

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions