db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Unique index

A unique index refuses duplicate keys, and building one over existing data fails if the data already holds duplicates. The customers table has emails that differ only in letter case.

task

Add a unique index on lower(email); the existing duplicates make it fail. Read the error.

hints