In this section we're going to walk through how to implement the full set of CRUD features into your database.
This guide examines how to create new records in a database by leveraging the INSERT INTO command in SQL. Additionally, we'll build out a seed script that will populate all three tables, including the foreign key records.
This guide walks through a basic introduction to querying for all records in SQL databases. Additionally, we'll discuss best practices for building a SELECT statement.
This guide walks through how to build a SQL query that utilizes the where, and, or commands in order to specify the records that should be returned.
When you don't want to return a full result set from a query, SQL's LIMIT and offset tools allow you control the records returned. Additionally, the offset parameter allows you to implement features such as pagination in an application.
This guide explains how to update records in SQL, including how to integrate SQL's where, and, or clauses to select specific records to change.
Whenever you're working with experimental scripts, it is a good idea to reserve the right to revert a query, such as updating a database record, or set of database records. In this guide we're going to examine how to leverage MySQL's BEGIN and ROLLBACK commands in order to give our script the ability to revert back to a previous stage.
This guide walks through how to query for unique records in a SQL database by leveraging the distinct filter.
In this guide you'll learn how to set the sort order for a database query in MySQL. Additionally, we'll discuss how to leverage the CAST() function so that we can order non traditional data types.
This lesson walks through how to delete records from a MySQL database. Additionally, you'll learn how to add BEGIN and ROLLBACK commands to allow you to revert back to a previous state.
devCamp does not support ancient browsers.
Install a modern version for best experience.