Programming & Development / April 11, 2025

How to Represent Mali's Regions and Capital District in Java and SQL Using ISO 3166-2 Codes

Mali regions Java enum Mali ISO 3166-2 ML SQL Mali regions ML administrative divisions Mali backend data Spring Boot Mali regions Mali Java SQL Bamako code Mali Mali regional codes

🇲🇱 Java Enum: Mali’s Regions

Mali is divided into 10 regions and 1 capital district (Bamako) according to ISO 3166-2:ML. Here's the Java enum representation:

java

public enum MaliRegion {
    BAMAKO("ML-BKO"),
    GAO("ML-7"),
    KAYES("ML-1"),
    KIDAL("ML-8"),
    KOULIKORO("ML-2"),
    MOPTI("ML-5"),
    SEGOU("ML-4"),
    SIKASSO("ML-3"),
    TOMBOUCTOU("ML-6"),
    MENAKA("ML-9"),
    TAOUDENIT("ML-10");

    private final String code;

    MaliRegion(String code) {
        this.code = code;
    }

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

CREATE TABLE mali_regions (
    id SERIAL PRIMARY KEY,
    name VARCHAR(64) NOT NULL,
    code VARCHAR(8) NOT NULL UNIQUE
);

INSERT INTO mali_regions (name, code) VALUES
('Bamako', 'ML-BKO'),
('Gao', 'ML-7'),
('Kayes', 'ML-1'),
('Kidal', 'ML-8'),
('Koulikoro', 'ML-2'),
('Mopti', 'ML-5'),
('Segou', 'ML-4'),
('Sikasso', 'ML-3'),
('Tombouctou', 'ML-6'),
('Menaka', 'ML-9'),
('Taoudenit', 'ML-10');

✅ Summary

This setup provides a complete and ISO-compliant list of Mali's 10 regions and its capital district, ready to use in Java backends and SQL databases.



Comments

No comments yet

Add a new Comment

NUHMAN.COM

Information Technology website for Programming & Development, Web Design & UX/UI, Startups & Innovation, Gadgets & Consumer Tech, Cloud Computing & Enterprise Tech, Cybersecurity, Artificial Intelligence (AI) & Machine Learning (ML), Gaming Technology, Mobile Development, Tech News & Trends, Open Source & Linux, Data Science & Analytics

Categories

Tags

©{" "} Nuhmans.com . All Rights Reserved. Designed by{" "} HTML Codex