mysql各个国家语言表

-- 创建国家语言表
CREATE TABLE country_language (
    country_id INT,
    language_code VARCHAR(5),
    language_name VARCHAR(50),
    is_official BOOLEAN,
    PRIMARY KEY (country_id, language_code)
);

-- 插入示例数据
INSERT INTO country_language (country_id, language_code, language_name, is_official)
VALUES
(1, 'en', 'English', TRUE),
(1, 'es', 'Spanish', FALSE),
(2, 'fr', 'French', TRUE),
(2, 'de', 'German', FALSE);

-- 查询示例
SELECT country_id, language_code, language_name, is_official
FROM country_language
WHERE country_id = 1;

-- 使用INSERT IGNORE
INSERT IGNORE INTO country_language (country_id, language_code, language_name, is_official)
VALUES (1, 'en', 'English', TRUE);

-- 使用ON DUPLICATE KEY UPDATE
INSERT INTO country_language (country_id, language_code, language_name, is_official)
VALUES (1, 'en', 'English', TRUE)
ON DUPLICATE KEY UPDATE language_name = VALUES(language_name);

SELECT language_code, language_name
FROM country_language
WHERE country_id = 1 AND is_official = TRUE;