SQL statements are the individual commands you use to interact with the database. Each statement tells the database what action to perform \u2014 from retrieving data to modifying the structure.<\/p>\n\n\n\n
A SQL statement<\/strong> is a complete instruction made up of one or more clauses. These statements can be grouped into several categories based on their purpose:<\/p>\n\n\n\n Every SQL statement has:<\/p>\n\n\n\n Example:<\/p>\n\n\n\n SQL statements are the individual commands you use to interact with the database. Each statement tells the database what action to perform \u2014 from retrieving data to modifying the structure. \u270d\ufe0f What Are SQL Statements? A SQL statement is a complete instruction made up of one or more clauses. These statements can be grouped into […]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,979],"class_list":["post-3898","cposts","type-cposts","status-publish","hentry","category-notes","category-sql"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/3898","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=3898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=3898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
SELECT<\/code>)<\/li>\n\n\n\nINSERT<\/code>, UPDATE<\/code>, DELETE<\/code>)<\/li>\n\n\n\nCREATE<\/code>, ALTER<\/code>, DROP<\/code>)<\/li>\n\n\n\nGRANT<\/code>, REVOKE<\/code>)<\/li>\n\n\n\nCOMMIT<\/code>, ROLLBACK<\/code>, SAVEPOINT<\/code>)<\/li>\n<\/ul>\n\n\n\n\u2699\ufe0f Common SQL Statements Overview<\/h2>\n\n\n\n
Category<\/th> Statement<\/th> Purpose<\/th> Example<\/th><\/tr><\/thead> DQL<\/td> SELECT<\/code><\/td>Retrieve data from tables<\/td> SELECT * FROM employees;<\/code><\/td><\/tr>DML<\/td> INSERT<\/code><\/td>Add new records<\/td> INSERT INTO employees (name) VALUES ('Alice');<\/code><\/td><\/tr><\/td> UPDATE<\/code><\/td>Modify existing records<\/td> UPDATE employees SET age = 30 WHERE id = 1;<\/code><\/td><\/tr><\/td> DELETE<\/code><\/td>Remove records<\/td> DELETE FROM employees WHERE age < 20;<\/code><\/td><\/tr>DDL<\/td> CREATE TABLE<\/code><\/td>Create a new table<\/td> CREATE TABLE employees (id INT, name VARCHAR(50));<\/code><\/td><\/tr><\/td> ALTER TABLE<\/code><\/td>Change table structure<\/td> ALTER TABLE employees ADD COLUMN salary INT;<\/code><\/td><\/tr><\/td> DROP TABLE<\/code><\/td>Delete a table<\/td> DROP TABLE employees;<\/code><\/td><\/tr>DCL<\/td> GRANT<\/code><\/td>Give permissions to users<\/td> GRANT SELECT ON employees TO user1;<\/code><\/td><\/tr><\/td> REVOKE<\/code><\/td>Remove permissions<\/td> REVOKE SELECT ON employees FROM user1;<\/code><\/td><\/tr>TCL<\/td> COMMIT<\/code><\/td>Save all changes in a transaction<\/td> COMMIT;<\/code><\/td><\/tr><\/td> ROLLBACK<\/code><\/td>Undo changes since last COMMIT<\/td> ROLLBACK;<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n\ud83e\udde9 Statement Syntax Basics<\/h2>\n\n\n\n
\n
SELECT<\/code>, INSERT<\/code>)<\/li>\n\n\n\nWHERE<\/code>, ORDER BY<\/code>)<\/li>\n\n\n\n;<\/code>)<\/li>\n<\/ul>\n\n\n\nSELECT name, age\nFROM employees\nWHERE age > 25\nORDER BY age DESC;<\/code><\/code><\/pre>\n\n\n\n\ud83d\udca1 Tips to Remember<\/h2>\n\n\n\n
\n
\ud83e\udde0 Quick Recap<\/h2>\n\n\n\n
Key Point<\/th> Details<\/th><\/tr><\/thead> SQL Statement<\/td> Command instructing database action<\/td><\/tr> Categories<\/td> DQL, DML, DDL, DCL, TCL<\/td><\/tr> End with semicolon<\/td> Marks completion of statement<\/td><\/tr> Write clear and readable<\/td> Use uppercase commands and formatting<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"