Skip to content

1.0

Compare
Choose a tag to compare
@dyazincahya dyazincahya released this 26 Oct 07:16
· 11 commits to main since this release
746aee9

Function

  • SQL__select
  • SQL__selectRaw
  • SQL__insert
  • SQL__update
  • SQL__delete
  • SQL__truncate
  • SQL__dropTable
  • SQL__query

Example

    SQL__select("table_name", "field1, field2", "WHERE id = 1")
    SQL__selectRaw("SELECT * FROM table_name WHERE id = 1")
    SQL__insert("table_name", [{field: "field1", value: "value1"}, {field: "field2", value: "value2"}])
    SQL__update("table_name", [{field: "field1", value: "new_value1"}, {field: "field2", value: "new_value2"}], 1, "WHERE id = 1")
    SQL__delete("table_name", 1, "WHERE id = 1")
    SQL__truncate("table_name")
    SQL__dropTable("table_name")
    SQL__query("SELECT * FROM table_name")