Mysql Alter table using concat

Question

These SQLs should be give same result? Second one gives an error (SQL Error 1064).

Correct :          ALTER TABLE table1 TRUNCATE PARTITION d20; 
Does not work   :  ALTER TABLE table1 TRUNCATE PARTITION concat('d', '20');

Actually I stuck on truncate table with respect to day of month, (ie today is 25th) execute

i was planned sql like below, but does not work

ALTER TABLE table1 TRUNCATE PARTITION DAYOFMONTH(now());

zerkms · Accepted Answer · 2011-04-25 08:36:22Z

1

No, they shouldn't. TRUNCATE PARTITION accepts a partition name, which is not a string.

UPD:

You still can create and perform dynamic sql queries using PREPARE + EXECUTE

edited Apr 25, 2011 at 8:36

answered Apr 25, 2011 at 8:25

zerkms

256k73 gold badges447 silver badges551 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Erdinç Taşkın Over a year ago

Thanks this is sol'n for problem but I have a constraint. SQL should be simple that only one line (statement). If it is possible done by one step i am very glad

zerkms Over a year ago

@erdinc: unfortunately it is not. Only dynamic sql.

Collectives™ on Stack Overflow

Mysql Alter table using concat

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related