usql icon indicating copy to clipboard operation
usql copied to clipboard

double quotes can't be supported in mysql driver

Open mrpre opened this issue 2 years ago • 0 comments

only single quote can be recognized in usql

my:[email protected]:3306/mydb=> update `version_release` set `db_type` = 'Redis';
UPDATE
my:[email protected]:3306/mydb=> update `version_release` set `db_type` = "Redis";
error: mysql: 1054: Unknown column 'Redis' in 'field list'
my:root@server:3306/mydb=>

while I use mysql command

MySQL [mydb]> UPDATE version_release set db_type="Redis";
Query OK, 0 rows affected (0.03 sec)
Rows matched: 2  Changed: 0  Warnings: 0

MySQL [mydb]> UPDATE version_release set db_type='Redis';
Query OK, 0 rows affected (0.04 sec)
Rows matched: 2  Changed: 0  Warnings: 0

MySQL [mydb]>

mrpre avatar Mar 10 '22 06:03 mrpre