LUNAR
Search notes
Dashboard
Browse
Home
/
2. Semester
/
Python Advanced
/
SW13
/
notes
notes
md
See Source
Fullscreen
# SQL ## Querries ### CRUD operations - **Create**: `INSERT INTO <table_name> (column1, column2) VALUES (value1, value2);` - **Read**: `SELECT column1, column2 FROM <table_name> WHERE condition;` - **Update**: `UPDATE <table_name> SET column1 = value1, column2 = value2 WHERE condition;` - **Delete**: `DELETE FROM <table_name> WHERE condition;` ## Relational Database Relational databases have the ability to have multiple connected tables that share information about the same entity.