I am working on a partition automation script and I need the string concat output as below. The prefix and suffix of the query will be framed in separate statements
PARTITION pweek38 VALUES LESS THAN (TO_DAYS('2024-09-22 00:00:00.000000'))
Below is my code
SET @q = 'SELECT CONCAT(@query,'' PARTITION '', @partition_name, '' VALUES LESS THAN (TO_DAYS('', @partition_ts, '')'', '')'') INTO @query';
Above statement does not add single quotes between the date time value.
6
SET @q = 'SELECT CONCAT(@query,'' PARTITION '', @partition_name, '' VALUES LESS THAN (TO_DAYS('''''', @partition_ts, '''''')'', '')'') INTO @query';
SELECT @q;
SET @query = '', @partition_name = 'PARTITION_1', @partition_ts = CURRENT_DATE;
PREPARE stmt FROM @q;
EXECUTE stmt;
DROP PREPARE stmt;
SELECT @query;
| @q |
|---|
| SELECT CONCAT(@query,’ PARTITION ‘, @partition_name, ‘ VALUES LESS THAN (TO_DAYS(”’, @partition_ts, ”’)’, ‘)’) INTO @query |
| @query |
|---|
| PARTITION PARTITION_1 VALUES LESS THAN (TO_DAYS(‘2024-09-17’)) |
fiddle