usql
usql copied to clipboard
double quotes can't be supported in mysql driver
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]>