Scribd
Upload
4 views3 pages

SQL Notes

The document provides a tutorial on basic MySQL commands for creating databases and tables, inserting, selecting, updating, and deleting records. It includes examples of creating a 'CUSTOMERS' table with various data types and executing SQL queries for data manipulation. The document serves as a guide for beginners to understand fundamental MySQL operations.

Uploaded by

choisoohi493
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
4 views3 pages

SQL Notes

The document provides a tutorial on basic MySQL commands for creating databases and tables, inserting, selecting, updating, and deleting records. It includes examples of creating a 'CUSTOMERS' table with various data types and executing SQL queries for data manipulation. The document serves as a guide for beginners to understand fundamental MySQL operations.

Uploaded by

choisoohi493
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

S.

Subesh MySQL Esoft - Kegalle

CREATE DATABASE DatabaseName;

Create database dbEsoft;


SHOW DATABASES;

CREATE TABLE table_name(


column1 datatype,
column2 datatype,
column3 datatype,
.....
columnN datatype,
PRIMARY KEY( one or more columns )
);

CREATE TABLE CUSTOMERS (


ID INT NOT NULL,
NAME VARCHAR (20) NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR (25) ,
SALARY DECIMAL (18, 2),
PRIMARY KEY (ID)
);

INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)


VALUES (value1, value2, value3,...valueN);

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)


VALUES (1, 'Ramesh', 32, 'Ahmedabad', 2000.00 );

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)


VALUES (2, 'Khilan', 25, 'Delhi', 1500.00 );

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)


VALUES (3, 'kaushik', 23, 'Kota', 2000.00 );

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)


VALUES (4, 'Chaitali', 25, 'Mumbai', 6500.00 );

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)


VALUES (5, 'Hardik', 27, 'Bhopal', 8500.00 );

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)


VALUES (6, 'Komal', 22, 'MP', 4500.00 );

1
[Link] MySQL Esoft - Kegalle

SELECT column1, column2, columnN FROM table_name;

SELECT * FROM table_name;


SELECT ID, NAME, SALARY FROM CUSTOMERS;

SELECT column1, column2, columnN


FROM table_name
WHERE [condition]

SELECT ID, NAME, SALARY


FROM CUSTOMERS
WHERE SALARY > 2000;

SELECT ID, NAME, SALARY


FROM CUSTOMERS
WHERE NAME = 'Hardik';

SELECT column1, column2, columnN


FROM table_name
WHERE [condition1] AND [condition2]...AND [conditionN];

SELECT ID, NAME, SALARY


FROM CUSTOMERS
WHERE SALARY > 2000 AND age < 25;

SELECT column1, column2, columnN


FROM table_name
WHERE [condition1] OR [condition2]...OR [conditionN]

SELECT ID, NAME, SALARY


FROM CUSTOMERS
WHERE SALARY > 2000 OR age < 25;

2
[Link] MySQL Esoft - Kegalle

UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE [condition];

UPDATE CUSTOMERS
SET ADDRESS = 'Pune'
WHERE ID = 6;

UPDATE CUSTOMERS
SET ADDRESS = 'Pune', SALARY = 1000.00;

DELETE FROM table_name


WHERE [condition];

DELETE FROM CUSTOMERS


WHERE ID = 6;

DELETE FROM CUSTOMERS;

You might also like