S

@SIDSQL

EXCERCISE 8

MySQL
1 year ago
create table Author( author_id Int Primary Key Auto_Increment , author_name Varchar(50) Not Null ); create table Books( book_id Int NOT Null AUTO_INCREMENT PRIMARY KEY , title Varchar(30) NOT NULL, ratings Decimal(5,2), au_i

TYPES OF RELATIONSHIPS - foriegn foreign left right inner cross jpins

MySQL
1 year ago
#join operation is used to combine rows from two or more tables based on a related column between them\ # cROSS jOIN --EVERY ROW FROM ONE TABLE WITH COMBINE EVERY ROW FROM ANOTHER TABLE # # # create table customers( cust_id Int auto_increment

HOW TO RENAME COLUMN AND TABLE NAME

MySQL
1 year ago
CREATE TABLE employees ( emp_id INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50) NOT NULL, lname VARCHAR(50) NOT NULL, desig VARCHAR(50) NOT NULL DEFAULT 'Probation', dept VARCHAR(50) NOT NULL, salary INT NOT NULL DEFAULT 25

How to add and reomve column ALTER

MySQL
1 year ago
#to add one more unique values in the coulmn (likewsie PhoneNumber) create table contact( name varchar(50), # named constraint mob varchar(50) UNIQUE, constraint mobno_less_than_10digits check (length(mob)>=10) #check (length(mob)>=

Unique and Check constriant

MySQL
1 year ago
#to add one more unique values in the coulmn (likewsie PhoneNumber) create table contact( name varchar(50), # named constraint mob varchar(50) UNIQUE, constraint mobno_less_than_10digits check (length(mob)>=10) #check (length(mob)>=

EXCERCISE 7

MySQL
1 year ago
CREATE TABLE employees ( emp_id INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50) NOT NULL, lname VARCHAR(50) NOT NULL, desig VARCHAR(50) NOT NULL DEFAULT 'Probation', dept VARCHAR(50) NOT NULL, salary INT NOT NULL DEFAULT 25

CASE TO APPLY CONDITIONS (not like ,not null)

MySQL
1 year ago
CREATE TABLE employees ( emp_id INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50) NOT NULL, lname VARCHAR(50) NOT NULL, desig VARCHAR(50) NOT NULL DEFAULT 'Probation', dept VARCHAR(50) NOT NULL, salary INT ); -- Inserting 10

BETWEEN (when we talk about range)

MySQL
1 year ago
CREATE TABLE employees ( emp_id INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50) NOT NULL, lname VARCHAR(50) NOT NULL, desig VARCHAR(50) NOT NULL DEFAULT 'Probation', dept VARCHAR(50) NOT NULL, salary INT NOT NULL DEFAULT 25

use of IN AND NOT

MySQL
1 year ago
CREATE TABLE employees ( emp_id INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50) NOT NULL, lname VARCHAR(50) NOT NULL, desig VARCHAR(50) NOT NULL DEFAULT 'Probation', dept VARCHAR(50) NOT NULL, salary INT NOT NULL DEFAULT 25

LOGICAL OPERAOTR AND || OR

MySQL
1 year ago
#WHEN WE DEAL WITH MULTPLE CONDITION #AND WHEN BOTH THE CONDITIO ARE TRUE #OR WHEN ANY OF THE STATEMENT IS TRUE CREATE TABLE employees ( emp_id INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50) NOT NULL, lname VARCHAR(50) NOT NULL,

RELATIONAL OPERATOR

MySQL
1 year ago
CREATE TABLE employees ( emp_id INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50) NOT NULL, lname VARCHAR(50) NOT NULL, desig VARCHAR(50) NOT NULL DEFAULT 'Probation', dept VARCHAR(50) NOT NULL, salary INT NOT NULL DEFAULT 25

DATE TIME DATETIME functions( CURDATE,CURTIME,NOW)

MySQL
1 year ago
#CURDATE() = yyyy-mm-dd #CURTIME()= hh:mm:ss #NOW() = yyyy-mm-dd hh:mm:ss select curdate(); select now();

DATE TIME DATETIME

MySQL
1 year ago
#DATE yyyy-mm-dd format #TIME HH:MM:SS #DATETIME yyyy-mm-dd HH:MM:SS CREATE TABLE PERSON( jd DATE, jt TIME, jdt DATETIME );

DECIMAL FLOAT DOUBLE

MySQL
1 year ago
#DECIMAL ( 5#TOTAL_DIGIT #, 2 #DIGITS AFTER DECIMAL) #float -upto -7 digits, takes 4 bytes of memory #double - upto - 15 digits , takes 8 bytes of memory CREATE table store ( pro_id INT PRIMARY KEY AUTO_INCREMENT, pro_name VARCHAR(50) NOT N

Excercise 5 5**

MySQL
1 year ago
CREATE TABLE employees ( emp_id INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50) NOT NULL, lname VARCHAR(50) NOT NULL, desig VARCHAR(50) NOT NULL DEFAULT 'Probation', dept VARCHAR(50) NOT NULL, salary INT NOT NULL DEFAULT 25

SUM AND AVG

MySQL
1 year ago
CREATE TABLE employees ( emp_id INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50) NOT NULL, lname VARCHAR(50) NOT NULL, desig VARCHAR(50) NOT NULL DEFAULT 'Probation', dept VARCHAR(50) NOT NULL, salary INT NOT NULL DEFAULT 25

MAX MIN

MySQL
1 year ago
#The MAX function in SQL returns the largest value from a selected column, while the MIN function returns the smallest value from a selected column. Both are often used with the GROUP BY clause to find the highest or lowest values within groups. CR

GROUP BY

MySQL
1 year ago
#GROUP BY ##SLECT dept FROM employees GROUP By dept; --syntaxx #The GROUP BY clause in SQL groups rows with the same values in specified columns so you can apply aggregate functions like COUNT or SUM to each group. CREATE TABLE employees ( emp

Excercise 4

MySQL
1 year ago
CREATE TABLE employees ( emp_id INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50) NOT NULL, lname VARCHAR(50) NOT NULL, desig VARCHAR(50) NOT NULL DEFAULT 'Probation', dept VARCHAR(50) NOT NULL, salary INT NOT NULL DEFAULT 25

Count() no of record ?

MySQL
1 year ago
create table employees( emp_id INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50) NOT NULL, lname VARCHAR(50) NOT NULL, desig VARCHAR(50) NOT NULL DEFAULT 'Probation', dept VARCHAR(50) NOT NULL ); INSERT into employees (emp_id,fn