Indus DBMS Al syntaxes

-- CREATE DATABASE database_name;
-- USE database_name;
-- DROP DATABASE database_name;
-- CREATE TABLE table_name (column1_name column1_type constraints, column2_name column2_type constraints, ...);
-- DROP TABLE table_name;
-- RENAME TABLE old_table_name TO new_table_name;
-- TRUNCATE TABLE table_name;
-- INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);
-- UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
-- DELETE FROM table_name WHERE condition;
-- SELECT column1, column2, ... FROM table_name;
-- SELECT * FROM table_name;
-- SELECT column1, column2, ... FROM table_name WHERE condition;
-- SELECT column1, column2, ... FROM table_name ORDER BY column_name [ASC|DESC];
-- SELECT column1, column2, ... FROM table_name LIMIT number_of_rows;
-- SELECT COUNT(column_name) FROM table_name;
-- SELECT SUM(column_name) FROM table_name;
-- SELECT AVG(column_name) FROM table_name;
-- SELECT MAX(column_name) FROM table_name;
-- SELECT MIN(column_name) FROM table_name;
-- SELECT column_name, aggregate_function(column_name) FROM table_name GROUP BY column_name;
-- SELECT column_name, aggregate_function(column_name) FROM table_name GROUP BY column_name HAVING condition;
-- SELECT columns FROM table1 INNER JOIN table2 ON table1.column = table2.column;
-- SELECT columns FROM table1 LEFT JOIN table2 ON table1.column = table2.column;
-- SELECT columns FROM table1 RIGHT JOIN table2 ON table1.column = table2.column;
-- SELECT columns FROM table1 LEFT JOIN table2 ON table1.column = table2.column UNION SELECT columns FROM table1 RIGHT JOIN table2 ON table1.column = table2.column;
-- SELECT column_name FROM table_name WHERE column_name = (SELECT column_name FROM table_name WHERE condition);
-- SELECT column_name FROM (SELECT column_name FROM table_name) AS alias_name;
-- SELECT column_name FROM table1 UNION SELECT column_name FROM table2;
-- SELECT column_name FROM table1 UNION ALL SELECT column_name FROM table2;
-- CREATE INDEX index_name ON table_name(column_name);
-- DROP INDEX index_name ON table_name;
-- CREATE VIEW view_name AS SELECT columns FROM table_name WHERE condition;
-- DROP VIEW view_name;
-- START TRANSACTION;
-- COMMIT;
-- ROLLBACK;