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

  Select data from the table.

• insert

  Insert one or more records into the table.

• update

  Modify data from the table.

• delete

  Delete data from the table.

• replace

  Replace old data with a new one

• create

  Create a table.

• drop

  Drop a table.

• get

  Get only one record from the table.

• has

  Determine whether the target data existed from the table.

• count

  Count the number of rows from the table.

• max

  Get the maximum value of the column.

• min

  Get the minimum value of the column.

• avg

  Calculate the average value of the column.

• sum

  Calculate the total value of the column.

• rand

  Fetch data from the table randomly.

• id

  Return the ID for the last inserted row.

• query

  Execute the customized raw query

• quote

  Quotes the string for the query.

• action

  Start a transaction.

• debug

  Enable debug mode and output readable statement string.

• log

  Return all executed queries.

• last

  Return the last query performed.

• info

  Get information about the database connection.