@SIDSQL

#SELECT * FROM employees LIMIT 3; --syntaxx 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)

#SELECT * from employees WHERE dept LIKE "%Acc%" --syntaxx 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',

#SELECT * FROM employees ORDER BY fname; --syntax #use for sorting CREATE table employees( emp_id INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50) NOT NULL, lname VARCHAR(50) NOT NULL,

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

-- create a table 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 em

SELECT REVERSE('HELLO'); #UPPER and LOWER select upper('abcdefghijklmnopqrstuvwxyz'); #UCASE select lower('ABCDEFGHIJKLMNOPQRSTUVWXYZ'); #LCASE CREATE table employees( emp_id INT PRIMARY KEY AUTO_INCREMENT, fname VARCHAR(50) NOT NULL,

#SELECT SUBSTRING ('HELL BUDDY', 1, 4); # IT WILL THORW ERROR SUBSTRING AND BRACKET HAVE SPACE BETWEEN #SUBSTRING: Extracts part of a string SELECT SUBSTRING('HELL BUDDY', 1, 4); SELECT SUBSTRING('HELL BUDDY',5, 4); SELECT SUBSTRING('HELL BUDDY',4)

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

#to modify the data and string #to get data systematic #SELECT CONCAT ('HEY',' Buddhi',' hello'); # method to concate and give space between them #SELECT CONCAT ('HEY',' ',' hello'); # free space for space between CREATE table employees( emp_i

-- create a table CREATE table employees( emp_id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL, desig VARCHAR(50) NOT NULL DEFAULT 'Probation', dept VARCHAR(50) NOT NULL ); INSERT into employees (emp_id,name,desig,dept)

-- create a table CREATE table employees( emp_id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL, desig VARCHAR(50) NOT NULL DEFAULT 'Probation', dept VARCHAR(50) NOT NULL ); INSERT into employees (emp_id,name,desig,dept)

-- alias #An alias in MySQL is a temporary name given to a table or column in a query to make it easier to read and work with #Use Cases: #Shorten long column/table names. #Improve query readability, especially when using complex queries. #Avoid am

#working on auto incremnet CREATE TABLE customer5( acc_n0 INT PRIMARY KEY AUTO_INCREMENT, # no need to write again and again name VARCHAR(50) NOT NULL, acc_type VARCHAR(50) NOT NULL DEFAULT 'SAVINGS' ); DESC customer5; INSERT INTO

-- create a table CREATE TABLE customer( acc_no INT PRIMARY KEY, name VARCHAR(40) NOT NULL, acc_type VARCHAR(50) NOT NULL DEFAULT 'SAVINGS' ); #DESC customer; INSERT INTO customer(acc_no,name,acc_type) VALUES (101,"SIDDHARTH", "CURRE

-- create a table create table customers1( id INT NOT NULL, -- name VARCHAR(199) NOT NULL, address VARCHAR(50) DEFAULT 'SONIMANDIR' ); #DESC #describe INSERT INTO customers1(id) VALUES (101); # throw error -- Field 'name' doesn't ha

#NOTE #SQL treats ' BADDMUNDA' and 'BADDMUNDA' as two different values due to the space #Table Creation CREATE table STUDENT( ID INT, NAME VARCHAR(100), SUBJECT VARCHAr(100), ADDRESS VARCHAR(100) );