sql_query_builder icon indicating copy to clipboard operation
sql_query_builder copied to clipboard

Add MySQL syntax

Open belchior opened this issue 1 year ago • 0 comments

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/delete.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

belchior avatar Nov 11 '24 12:11 belchior