Keys and Constraints in MySQL

Primary Key

CREATE TABLE users (
  id INT PRIMARY KEY,
  name VARCHAR(100)
);

Foreign Key

CREATE TABLE orders (
  id INT,
  user_id INT,
  FOREIGN KEY (user_id) REFERENCES users(id)
);

UNIQUE

CREATE TABLE students (
  email VARCHAR(255) UNIQUE
);