AI Features

0% completed

All LessonsFree Lessons (6)

Introduction

Introduction Relational vs Non-Relational MySQL History & Architecture

Basic SQL

Exploring MySQL

Create Database

Temporary Table

Collations & Character Sets

Combining Conditions

Primary Key and Indexes

Aggregate Methods

Joins

Types of Joins Self Inner Join Inner Join Union Left and Right Joins Natural Join

Nested Queries

Nested Scalar Queries Nested Column Queries Nested Row Queries EXISTS Operator Correlated Queries

Multi Table Operations

Multi-Table Delete Multi-Table Update SELECT and INSERT REPLACE

Views

Creating a View Updating a View With Check Option Local & Cascaded Check Drop, Show, & Rename Views

Stored Procedures

What are Stored Procedures?Create, Delete, and Alter a Stored Procedure Variables Parameters Conditional Statements Iterative Statements Cursors Error Handling SIGNAL and RESIGNAL Stored Functions

Triggers

What are Triggers?Create and Delete a Trigger INSERT Triggers UPDATE Triggers DELETE Triggers Multiple Triggers

Miscellaneous

Transaction EXPLAIN Foreign Keys

Practice & Prep

Quiz 1 Quiz 2 Quiz 3 Quiz 4 Quiz 5 Quiz 6 Quiz 7 Quiz 8 Quiz 9 Quiz 10 Quiz 11 Quiz 12 Quiz 13 Quiz 14 Quiz 15 Quiz 16 Practice Set 1 Solution Practice Set 1 Practice Set 2 Solution Practice Set 2 Practice Set 3 Solution Practice Set 3 Practice Set 4 Solution Practice Set 4 Practice Set 5 Solution Practice Set 5 Practice Set 6 Solution Practice Set 6 Cheat Sheet

Epilogue

An Introductory Guide to SQL

TRUNCATE

This lesson discusses how to delete all the rows of a table using the TRUNCATE clause.

We'll cover the following...

Truncate
- Example Syntax

Truncate

In the previous lesson, we learned how to delete data using the DELETE statement. However, if we intend to ...