SQL statements are started with any of the SQL commands/keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP etc. and the statement ends with a semicolon (;). Example of SQL statement:
SELECT "column_name" FROM "table_name";
Semicolon is used to separate SQL statements. It is a standard way to separate SQL statements in a database system in which more than one SQL statements are used in the same call. In this tutorial, we will use semicolon at the end of each SQL statement.
SELECT: it extracts data from a database.
UPDATE: it updates data in database.
DELETE: it deletes data from database.
CREATE TABLE: it creates a new table.
ALTER TABLE: it is used to modify the table.
DROP TABLE: it deletes a table.
CREATE DATABASE: it creates a new database.
ALTER DATABASE: It is used to modify a database.
INSERT INTO: it inserts new data into a database.
CREATE INDEX: it is used to create an index (search key).
DROP INDEX: it deletes an index.← Previous Next →
© 2018 BreakInerview