![]() ![]() ROLLBACK: restores a database to the last committed stateĭata types specify the type of data that an object can contain, such as numeric data or character data.COMMIT: used to save a transaction within the database permanently.SELECT: used to select and return data (query) from a database.REVOKE: used to remove previously granted user permissions for accessing database objects.GRANT: used to assign user permissions to access database objects.DELETE: used to delete a row (record) from a database table.UPDATE: used to modify an existing row (record) in a database table.INSERT: used to insert a new row (record) in a database table. ![]() ALTER: used to modify a database objectĭata Manipulation Language (DML) Commands.CREATE: creates a new database object, such as a table. ![]() We can group commands into the following categories of SQL statements: Data Definition Language (DDL) Commands SQL is a database language that’s used to query and manipulate data in a database, while also giving you an efficient and convenient environment for database management. But for now, let’s dive into this SQL commands cheat sheet.ĭownload Hackr.io’s SQL Cheat Sheet PDF here. Looking to learn SQL from scratch, or want to know the difference between SQL and MySQL? You should definitely check out the rest of our SQL content. Plus, we’ve broken it down into 11 essential SQL topics to help you get the most from this SQL query cheat sheet. Whether you need a quick reference for major SQL concepts before an interview, or you want to level-up your existing SQL skills, our SQL cheat sheet is the ideal starting point. Robert Johns | Co-author SQL Cheat Sheet for Quick Reference ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |