// Basic SQL Commands
CREATE TABLE `book` (`book_id` INT NOT NULL AUTO_INCREMENT , `book_name` VARCHAR(50) NOT NULL , `book_price` INT(5) NOT NULL , `book_writter` VARCHAR(50) NOT NULL , PRIMARY KEY (`book_id`))
INSERT INTO `book` (`book_id`, `book_name`, `book_price`, `book_writter`) VALUES ('101', 'Bangla', '100', 'Sakib'), (NULL, 'English', '150', 'Tahmeed'), (NULL, 'Arabic', '200', 'Tamim')
SELECT *
FROM orderlist
SELECT DISTINCT Invoice
FROM orderlist
SELECT *
FROM orderlist
WHERE id = 25
SELECT *
FROM orderlist
WHERE Id = 10 AND Invoice = 'abcxyz'
SELECT *
FROM orderlist
WHERE Id = 10 OR Invoice = 'abcxyz'
SELECT *
FROM orderlist
WHERE NOT RefTrx = 'AAE0M3JW8Q'
SELECT *
FROM orderlist
ORDER BY Id ASC
SELECT *
FROM orderlist
ORDER BY Id DESC
INSERT INTO orderlist (`Id`,`Invoice`,`RefTrx`)
VALUES (1000, 'testInvoiceId', 'testRefTrx');
UPDATE orderlist
SET RefTrx = 'updatedRefId', Invoice = 4.1254
WHERE id = 5;
DELETE
FROM orderlist
WHERE Id = 7;
SELECT AVG(Amount)
FROM paystation
WHERE Payment_Method = 'bKash';
SELECT MIN(Amount)
FROM paystation
WHERE Payment_Method = 'bKash';
SELECT MAX(Amount)
FROM paystation
WHERE Payment_Method = 'bKash';
SELECT SUM(Amount)
FROM paystation
WHERE Payment_Method = 'bKash';
SELECT COUNT(Amount)
FROM paystation
WHERE Payment_Method = 'bKash';
SELECT *
FROM paystation
WHERE Customer_Mobile LIKE '015%';
SELECT *
FROM paystation
WHERE Customer_Mobile LIKE '%015%';
SELECT *
FROM paystation
WHERE Customer_Mobile LIKE '0_';
SELECT *
FROM paystation
WHERE Payment_Method IN ('Nagad', 'Rocket');
SELECT *
FROM paystation
WHERE Payment_Method IN ('Nagad', 'Rocket');
SELECT *
FROM paystation
WHERE Payment_Method IN (SELECT Payment_Method FROM anothertable);
SELECT *
FROM paystation
WHERE Amount BETWEEN 0 AND 505
SELECT Amount AS 'Temp table title'
FROM paystation
WHERE 1
SELECT table1.id, table2.name
FROM table1
INNER JOIN table2 ON table1.id = taabl2.id
SELECT table1.id, table2.name
FROM table1
LEFT JOIN table2 ON table1.id = taabl2.id
SELECT table1.id, table2.name
FROM table1
RIGHT JOIN table2 ON table1.id = taabl2.id
SELECT table1.id, table2.name
FROM table1
CROSS JOIN table2 ON table1.id = taabl2.id
SELECT id FROM table1
UNION
SELECT id FROM table2
ALTER TABLE paystation
ADD name varchar(255)
ALTER TABLE paystation
DROP COLUMN name;
ALTER TABLE paystation
MODIFY COLUMN Action varchar(255);