70.808
Integrity Constraints in SQLite

Introduction

In this lesson, you will learn about how to specify referential and user-level constraints in SQLite.

Creating Tables

create table lessons (
  lname text not null,
  llength integer not null
);

Let’s add a few rows of data to the table so we can see how SQLite assigns a row id.

insert into lessons values
  ('Intro C++', 90),
  ('Intro Java', 90),
  ('SQL Joins', 60)

Conclusion

---

Files & Resources

All Files for Lesson 70.808

---

References

SQLite AUTOINCREMENT. SQLite Tutorial.

SQLite AUTOINCREMENT. SQLite Documentation.

Errata

None collected yet. Let us know.