城市区号表 mysql

CREATE TABLE city_area_codes (
    id INT AUTO_INCREMENT PRIMARY KEY,
    city_name VARCHAR(255) NOT NULL,
    area_code VARCHAR(10) NOT NULL
);

INSERT INTO city_area_codes (city_name, area_code) VALUES ('北京', '010'), ('上海', '021');

SELECT area_code FROM city_area_codes WHERE city_name = '北京';

UPDATE city_area_codes SET area_code = '011' WHERE city_name = '北京';

DELETE FROM city_area_codes WHERE city_name = '北京';

INSERT IGNORE INTO city_area_codes (city_name, area_code) VALUES ('北京', '010');

REPLACE INTO city_area_codes (city_name, area_code) VALUES ('北京', '010');