Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- EAV (anti-pattern for most cases) CREATE TABLE product_attrs ( product_id INT, attr_name VARCHAR(50), attr_value VARCHAR(255) ); -- To get color and size, requires two JOINs -- Better: use JSON column or separate typed columns
Result
Open