The syntax of mysql RENAME TABLE tb1 TO tb2 is not supported.

```rust
let sql = "RENAME TABLE `test`.`test` TO `test`.`test2`";

let dialect = MySqlDialect {};
let ast = Parser::parse_sql(&dialect, sql).unwrap();

println!("AST: {:#?}", ast);
```

output error:
```
called `Result::unwrap()` on an `Err` value: ParserError("Expected: an SQL statement, found: RENAME at Line: 1, Column: 1")
```

Start with the Parser::parse_sql call using MySqlDialect and the failing RENAME TABLE example in the issue. Trace how MySQL statements are recognized and represented, then verify that the example parses successfully and produces an AST for renaming `test`.`test` to `test`.`test2`.

Written by the indexing model from the issue text.