SQL：多值属性

SQL中的多值属性及其应用

sql
CREATE TABLE Users (
    UserID INT PRIMARY KEY,
    UserName VARCHAR(50),
    Skills VARCHAR(255) -- 多值属性
);
INSERT INTO Users (UserID, UserName, Skills) 
VALUES 
    (1, 'John Doe', 'Programming, Database Design, Project Management'),
    (2, 'Jane Smith', 'Graphic Design, UI/UX, Front-end Development');

sql
CREATE TABLE Articles (
    ArticleID INT PRIMARY KEY,
    Title VARCHAR(100),
    Content TEXT,
    Tags VARCHAR(255) -- 多值属性
);
INSERT INTO Articles (ArticleID, Title, Content, Tags)
VALUES 
    (1, 'Exploring SQL Joins', 'In this article, we delve into the world of SQL joins...', 'SQL, Database'),
    (2, 'Web Development Best Practices', 'Learn the best practices for web development...', 'Web Development, Coding Standards');