Skip to content

could you please support prepared sql for mysql5.7 and mysql8.0 user create/rename/drop etc...? #1511

@Jacklli

Description

@Jacklli

Issue description

go-sql-driver does not support prepared sql for mysql5.7 and mysql8.0, could you please support prepared sql for mysql5.7 and mysql8.0 user create/rename/drop etc...?

Example code

go-sql-driver does not support prepared sql for mysql5.7 and mysql8.0, could you please support prepared sql for mysql5.7 and mysql8.0 user create/rename/drop etc...?

Error log

go-sql-driver does not support prepared sql for mysql5.7 and mysql8.0, could you please support prepared sql for mysql5.7 and mysql8.0 user create/rename/drop etc...?

Configuration

go-sql-driver does not support prepared sql for mysql5.7 and mysql8.0, could you please support prepared sql for mysql5.7 and mysql8.0 user create/rename/drop etc...?

mysql official doc claim mysql5.7 and mysql8.0 support prepared statement for user create/rename/drop etc...

https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html

SQL Syntax Permitted in Prepared Statements
The following SQL statements can be used as prepared statements:

ALTER TABLE
ALTER USER
ANALYZE TABLE
CACHE INDEX
CALL
CHANGE MASTER
CHECKSUM {TABLE | TABLES}
COMMIT
{CREATE | DROP} INDEX
{CREATE | RENAME | DROP} DATABASE
{CREATE | DROP} TABLE
{CREATE | RENAME | DROP} USER
{CREATE | DROP} VIEW
DELETE
DO
FLUSH {TABLE | TABLES | TABLES WITH READ LOCK | HOSTS | PRIVILEGES
| LOGS | STATUS | MASTER | SLAVE | USER_RESOURCES}
GRANT
INSERT
INSTALL PLUGIN
KILL
LOAD INDEX INTO CACHE
OPTIMIZE TABLE
RENAME TABLE
REPAIR TABLE
REPLACE
RESET {MASTER | SLAVE}
REVOKE
SELECT
SET
SHOW BINLOG EVENTS
SHOW CREATE {PROCEDURE | FUNCTION | EVENT | TABLE | VIEW}
SHOW {MASTER | BINARY} LOGS
SHOW {MASTER | SLAVE} STATUS
SLAVE {START | STOP}
TRUNCATE TABLE
UNINSTALL PLUGIN
UPDATE

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions