Lines Matching refs:p300
24 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (304, '(p300-2999-)subp8');
25 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (303, '(p300-2999-)subp8');
26 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (302, '(p300-2999-)subp8');
27 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (301, '(p300-2999-)subp8');
79 SELECT * FROM t1 PARTITION (`p300-2999`);
81 301 (p300-2999-)subp8
82 302 (p300-2999-)subp8
83 303 (p300-2999-)subp8
84 304 (p300-2999-)subp8
85 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
86 SELECT * FROM t1 PARTITION (`p300-2999`);
88 301 p300-2999-upd
89 302 p300-2999-upd
90 303 p300-2999-upd
91 304 p300-2999-upd
175 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
183 SELECT * FROM t2 PARTITION (`p300-2999`);
185 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
186 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;