sql_query_builder
sql_query_builder copied to clipboard
Adds MySQL syntax
Adds MySQL syntax to Select builder
# Cargo.toml
sql_query_builder = { version = "2.x.x", features = ["mysql"] }
Basic API
use sql_query_builder as sql;
let query = sql::Select::new()
.select("*")
.from("employees")
.partition("p1")
.to_string();
let expected_query = "SELECT * FROM employees PARTITION (p1)";
assert_eq!(expected_query, query);
Reference
- https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
- https://dev.mysql.com/doc/refman/8.4/en/create-index.html
- https://dev.mysql.com/doc/refman/8.4/en/create-table.html
- https://dev.mysql.com/doc/refman/8.4/en/delete.html
- https://dev.mysql.com/doc/refman/8.4/en/drop-index.html
- https://dev.mysql.com/doc/refman/8.4/en/insert.html
- https://dev.mysql.com/doc/refman/8.4/en/select.html
- https://dev.mysql.com/doc/refman/8.4/en/update.html