Basic Commands that we use in Sql while creating project....

Hi friends, today I will say you about basic Sql commands that we use while creating our project.

1) Create

2) Insert

3) Update

4) Delete

Create Table Statement

    CREATE TABLE "table_name"
("column 1" "data type for column 1" [column 1 constraint(s)],
"column 2" "data type for column 2" [column 2 constraint(s)],
...
[table constraint(s)]);

·        Drop Table Statement
DROP TABLE "table_name";

·        Truncate Table Statement
TRUNCATE TABLE "table_name";

·        Insert Into Statement
INSERT INTO "table_name" ("column1", "column2", ...)
VALUES ("value1", "value2", ...);

·        Update Statement
UPDATE "table_name"
SET "column_1" = [new value]
WHERE "condition";

·        Delete From Statement
DELETE FROM "table_name"
WHERE "condition";

·        Alter Statement

ALTER TABLE tb_TableName ADD Record_Status varchar(20);

ALTER TABLE tb_TableName 

add constraint cnt_Record_Status Default '' for Record_Status;

Six types of constraints can be placed when creating a table:

·        NOT NULL Constraint: Ensures that a column cannot have NULL value.

·        DEFAULT Constraint: Provides a default value for a column when none is specified.

·        UNIQUE Constraint: Ensures that all values in a column are different.

·        CHECK Constraint: Makes sure that all values in a column satisfy certain criteria.

·        Primary Key Constraint: Used to uniquely identify a row in the table.

·        Foreign Key Constraint: Used to ensure referential integrity of the data.

SQL > SQL Syntax

In this page, I have listed the SQL syntax for each of the SQL commands in this tutorial, making this an easy reference for someone to learn SQL.

·       Select Statement

   SELECT "column_name" FROM "table_name";

·        Distinct
SELECT DISTINCT "column_name"
FROM "table_name";

·        Where
SELECT "column_name"
FROM "table_name"
WHERE "condition";

·        And/Or
SELECT "column_name"
FROM "table_name"
WHERE "simple condition"
{[AND|OR] "simple condition"}+;

·        In
SELECT "column_name"
FROM "table_name"
WHERE "column_name" IN ('value1', 'value2', ...);

·        Between
SELECT "column_name"
FROM "table_name"
WHERE "column_name" BETWEEN 'value1' AND 'value2';

·        Like
SELECT "column_name"
FROM "table_name"
WHERE "column_name" LIKE {PATTERN};

·        Order By
SELECT "column_name"
FROM "table_name"
[WHERE "condition"]
ORDER BY "column_name" [ASC, DESC];

·        Count
SELECT COUNT("column_name")
FROM "table_name";

·        Group By
SELECT "column_name1", SUM("column_name2")
FROM "table_name"
GROUP BY "column_name1";

·        Having
SELECT "column_name1", [Function("column_name2")]
FROM "table_name"
[GROUP BY "column_name1"]
HAVING (arithematic function condition);

    

    You can rate my class on right side top of my blog......

    

                                                        -Your's santoshklpkl

·