[go: up one dir, main page]
Scribd
Upload
17 views2 pages

Mysql Cheetsheet

The document provides an overview of SQL manipulation commands, including column constraints such as PRIMARY KEY, UNIQUE, NOT NULL, and DEFAULT. It outlines the CREATE TABLE statement for creating new tables, the INSERT INTO statement for adding records, and the ALTER TABLE statement for modifying existing tables. Additionally, it covers the DELETE and UPDATE statements for removing and editing records in a table.

Uploaded by

karthick
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
17 views2 pages

Mysql Cheetsheet

The document provides an overview of SQL manipulation commands, including column constraints such as PRIMARY KEY, UNIQUE, NOT NULL, and DEFAULT. It outlines the CREATE TABLE statement for creating new tables, the INSERT INTO statement for adding records, and the ALTER TABLE statement for modifying existing tables. Additionally, it covers the DELETE and UPDATE statements for removing and editing records in a table.

Uploaded by

karthick
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Firefox about:srcdoc

Cheatsheets / Learn SQL

Manipulation

Column Constraints

Column constraints are the rules applied to the values CREATE TABLE student (
of individual columns:
id INTEGER PRIMARY KEY,
• PRIMARY KEY constraint can be used to
uniquely identify the row. name TEXT UNIQUE,
• UNIQUE columns have a di�erent value for grade INTEGER NOT NULL,
every row.
age INTEGER DEFAULT 10
• NOT NULL columns must have a value.
);
• DEFAULT assigns a default value for the
column when no value is speci�ed.
There can be only one PRIMARY KEY column per
table and multiple UNIQUE columns.

CREATE TABLE Statement

The CREATE TABLE statement creates a new table CREATE TABLE table_name (
in a database. It allows one to specify the name of the
column1 datatype,
table and the name of each column in the table.
column2 datatype,
column3 datatype
);

INSERT Statement

The INSERT INTO statement is used to add a new -- Insert into columns in order:
record (row) to a table.
INSERT INTO table_name
It has two forms as shown:
• Insert into columns in order. VALUES (value1, value2);
• Insert into columns by name.

-- Insert into columns by name:


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

1 of 2 18/01/25, 12:46
Firefox about:srcdoc

ALTER TABLE Statement

The ALTER TABLE statement is used to modify the ALTER TABLE table_name
columns of an existing table. When combined with the
ADD column_name datatype;
ADD COLUMN clause, it is used to add a new
column.

DELETE Statement

The DELETE statement is used to delete records DELETE FROM table_name


(rows) in a table. The WHERE clause speci�es which
WHERE some_column = some_value;
record or records that should be deleted. If the
WHERE clause is omitted, all records will be
deleted.

UPDATE Statement

The UPDATE statement is used to edit records UPDATE table_name


(rows) in a table. It includes a SET clause that
SET column1 = value1, column2 = value2
indicates the column to edit and a WHERE clause
WHERE some_column = some_value;
for specifying the record(s).

Print Share

2 of 2 18/01/25, 12:46

You might also like