Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Auto-increment (simple, fast joins, but not globally unique) id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY -- UUID (globally unique, good for distributed systems) id CHAR(36) PRIMARY KEY DEFAULT (UUID()) -- Composite natural key (when combination is naturally unique) PRIMARY KEY (order_id, line_number)
Result
Open