Documentation

To get started, we recommended you read the guiding document to understand how to install and start a simple code.

• new Medoo

  The guide of how to start using Medoo and start a database connection

• Collaboration

  The guide about how to make Medoo work with other full-stack frameworks together

• Upgrade

  The guide about upgrading to the latest version

The article about the Medoo data filter as the argument of most Medoo functions - $where, it is important to use it for filtering data to get the target data we wanted.

• where

  The document about the $where argument.

The Medoo API list. You can find anything you want.

• select

  Retrieve data from a table.

• insert

  Insert one or more records into a table.

• update

  Update records in a table.

• delete

  Delete records from a table.

• replace

  Replace existing data in a table with new values.

• create

  Create a new table.

• drop

  Drop a table.

• get

  Retrieve a single record from a table.

• has

  Check whether any matching record exists in a table.

• count

  Count matching rows in a table.

• max

  Return the maximum value of a column.

• min

  Return the minimum value of a column.

• avg

  Calculate the average value of a column.

• sum

  Calculate the sum of a column.

• rand

  Retrieve random data from a table.

• id

  Return the ID of the last inserted row.

• query

  Execute a custom raw SQL query.

• quote

  Quote a string for use in a query.

• action

  Run queries inside a transaction.

• debug

  Enable debug mode and output readable SQL statements.

• log

  Return the executed query log.

• last

  Return the last executed query.

• info

  Return information about the current database connection.