Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Natural key: email as PK CREATE TABLE users (email VARCHAR(255) PRIMARY KEY, name VARCHAR(100)); -- Problem: if email changes, all FK references break -- Surrogate key: stable ID CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, email VARCHAR(255) UNIQUE, name VARCHAR(100) );
Result
Open