Learn MySQL. MySQL is a widely used relational database management system (RDBMS). MySQL is free and open-source. MySQL is ideal for both small and large applications. Start learning MySQL now »

Code Editor (Try it) With our online code editor, you can edit code and view the result in your browser

SQL is a standard language for storing, manipulating and retrieving data in databases. Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

Code Editor (Try it) With our online code editor, you can edit code and view the result in your browser

The code editor is packed with features to help you achieve more: Templates: Start from scratch or use a template; Cloud-based: no installations required. You only need your browser; Terminal & Log: debug and troubleshoot your code easily; File Navigator: switch between files inside the code editor; And much more! Learn More

The MySQL CREATE TABLE Statement. The CREATE TABLE statement is used to create a new table in a database. Syntax

Some of The Most Important SQL Commands. SELECT - extracts data from a database; UPDATE - updates data in a database; DELETE - deletes data from a database; INSERT INTO - inserts new data into a database; CREATE DATABASE - creates a new database; ALTER DATABASE - modifies a database; CREATE TABLE - creates a new table; ALTER TABLE - …

The MySQL SELECT Statement. The SELECT statement is used to select data from a database. The data returned is stored in a result table, called the result-set. SELECT Syntax

The SQL COUNT() Function. The COUNT() function returns the number of rows that matches a specified criterion.

Code Editor (Try it) With our online code editor, you can edit code and view the result in your browser