[Feature][MySQL-CDC] Support truncate table ddl

### Search before asking

- [X] I had searched in the [feature](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22Feature%22) and found no similar feature requirement.

### Description

Updates
- mysql-cdc
- docs
- e2e

ref
- https://github.com/apache/seatunnel/pull/6929

### Usage Scenario

_No response_

### Related issues

_No response_

### Are you willing to submit a PR?

- [ ] Yes I am willing to submit a PR!

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)

Start by reviewing the referenced pull request #6929 and the mysql-cdc implementation, documentation, and e2e areas named in the issue. Confirm how truncate table DDL is handled, then ensure support is covered across the implementation, docs, and end-to-end validation.

Written by the indexing model from the issue text.