SQL Syntax

SQL Statements

The following SQL statement selects all the records in the "student" table:
SELECT * FROM Student;
The easiest way to get MySQL and PHPMyAdmin is to install free tools like XAMPP or WAMP, which include all necessary installers.

SQL Commands

  • INSERT INTO - inserts new data into a database
  • SELECT - extracts data from a database
  • UPDATE - updates or Modifies records in database.
  • DELETE - deletes data from a database
  • CREATE DATABASE - creates a new database
  • ALTER DATABASE - modifies a database
  • CREATE TABLE - creates a new table
  • i>
  • DROP TABLE - deletes a table in database
  • CREATE INDEX - creates an index (search key)
  • DROP INDEX - deletes an index