View DDL statements DML&DQL SELECT INSERT INSERT ON CONFLICT(UPSERT) INSERT OVERWRITE COPY DELETE UPDATE TRUNCATE ANALYZE and auto-analyze Accelerate the execution of SQL statements by using fixed plans Query data across databases (beta) SQL transaction capabilities HINT EXPLAIN and EXPLAIN ANALYZE Prox...
DDL: data definition language, such as CREATE, ALTER, DROP DQL: data query language, such as SELECT DML: data manipulation language, such as INSERT, UPDATE, DELETE DCL: data control language, such as GRANT, REVOKE TCL: transaction control language, such as COMMIT, ROLLBACK For a backend en...
5、possible_keys possible_keys是指在这个SQL中,mysql可以使用这个索引去辅助查找记录,当查询涉及到的字段,都会被列出,但不一定被查询使用.若为空则表示没有可以使用的索引,此时可以通过检查where语句看是否可以引用某些列或者新建索引来提高性能。 6、key(重要) key列显示的是当前表实际使用的索引,如果没有选择索引...
DDL: data definition language, such as CREATE, ALTER, DROP DQL: data query language, such as SELECT DML: data manipulation language, such as INSERT, UPDATE, DELETE DCL: data control language, such as GRANT, REVOKE TCL: transaction control language, such as COMMIT, ROLLBACK For a backend en...
DDL: data definition language, such as CREATE, ALTER, DROP DQL: data query language, such as SELECT DML: data manipulation language, such as INSERT, UPDATE, DELETE DCL: data control language, such as GRANT, REVOKE TCL: transaction control language, such as COMMIT, ROLLBACK ...