jzj_xhj的专栏

原始写法：SELECT * FROM table_v2 LIMIT 0, 3412771;优化写法：SELECT t1.* FROM table_v2 t1, (SELECT id FROM table_v2 LIMIT 0, 3412771) t2 WHERE t1.id=t2.id;优化后的写法是原始的10倍至少 ...

数据库配置，在真实的物理数据库配置，生成如下表和函数DROP TABLE IF EXISTS MYCAT_SEQUENCE;CREATE TABLE MYCAT_SEQUENCE (NAME VARCHAR (50) NOT NULL,current_value INT NOT NULL,increment INT NOT NULL DEFAULT 100,PRIMARY K...