JAEN

SQL

SELECT

SafeRead data

SELECT * FROM <table> LIMIT 10;

Reads rows from a table; LIMIT keeps it safe to preview.

Examples

  • SELECT COUNT(*) FROM users;Count rows

Syntax

SELECT <cols> FROM <table> [WHERE ...] [LIMIT n];

Before you run it

Read-only.

Related commands

The same reference, with no signal at all

Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store