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

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

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

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 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

What is MySQL? MySQL is a relational database management system; MySQL is open-source; MySQL is free; MySQL is ideal for both small and large applications; MySQL is very fast, reliable, scalable, and easy to use; MySQL is cross-platform; MySQL is compliant with the ANSI SQL standard; MySQL was first released in 1995

MySQL Date Data Types. MySQL comes with the following data types for storing a date or a date/time value in the database: DATE - format YYYY-MM-DD; DATETIME - format: YYYY-MM-DD HH:MI:SS; TIMESTAMP - format: YYYY-MM-DD HH:MI:SS; YEAR - format YYYY or YY; Note: The date data type are set for a column when you create a new table in your database!

The MySQL UPDATE Statement. The UPDATE statement is used to modify the existing records in a table. UPDATE Syntax

MySQL ALTER TABLE Statement. The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. The ALTER TABLE statement is also used to add and drop various constraints on an existing table.