Home

Welcome to the sql wiki!

This is created for recall all the queries.

1. • Check other pages to understand SQL Queries from scratch to advance.
2. • Replace database_name and table_name with your own.

Important syntax:

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 - modifies a table DROP TABLE - deletes a table CREATE INDEX - creates an index (search key) DROP INDEX - deletes an index