Happy New Year

SQL-Query-Statement

SQL Query Statement

A query can either be a request for data results from your database or for action on the data, or for both. A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database

SYNTAX: Insert Data Sql Table

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

EXAMPLE: Insert Data Sql Table

INSERT INTO MyCar_tbl(Car_Name,Car_Color,Car_Number)
VALUES (‘Swift’, ‘white’, ‘GJ3BH5060’);

EXAMPLE: Select data Sql Table

SELECT * FROM MyCar_tbl
SELECT * FROM MyCar_tbl WHERE Car_Name=’Swift’

EXAMPLE: UPDATE Data Sql Table

UPDATE MyCar_tbl SET
Car_Name=’BMW’
WHERE Car_Name=’Swift’

EXAMPLE: Delete Data SQL Table

DELETE FROM MyCar_tbl WHERE Car_Name=’Swift’
DELETE FROM MyCar_tbl