Lines Matching refs:p300
22 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (304, '(p300-2999-)subp8');
23 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (303, '(p300-2999-)subp8');
24 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (302, '(p300-2999-)subp8');
25 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (301, '(p300-2999-)subp8');
73 SELECT * FROM t1 PARTITION (`p300-2999`);
75 301 (p300-2999-)subp8
76 302 (p300-2999-)subp8
77 303 (p300-2999-)subp8
78 304 (p300-2999-)subp8
79 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
80 SELECT * FROM t1 PARTITION (`p300-2999`);
82 301 p300-2999-upd
83 302 p300-2999-upd
84 303 p300-2999-upd
85 304 p300-2999-upd
169 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
177 SELECT * FROM t2 PARTITION (`p300-2999`);
179 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
180 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;