国产成人精品亚洲日本在线_欧美精品v国产精品v_亚洲欧洲日韩国产一区二区三区_亚洲乱码一二三四区

-- 創(chuàng)建2023年每個(gè)月的分表
CREATE TABLE log_202301 (
  id INT PRIMARY KEY AUTO_INCREMENT,
  content TEXT,
  create_time DATETIME
) ENGINE=InnoDB;

CREATE TABLE log_202302 LIKE log_202301;
-- ...以此類推創(chuàng)建其他月份的表

CREATE TABLE logs (
  id INT PRIMARY KEY AUTO_INCREMENT,
  content TEXT,
  create_time DATETIME
) ENGINE=InnoDB
PARTITION BY RANGE (TO_DAYS(create_time)) (
  PARTITION p202301 VALUES LESS THAN (TO_DAYS('2023-02-01')),
  PARTITION p202302 VALUES LESS THAN (TO_DAYS('2023-03-01')),
  PARTITION p_other VALUES LESS THAN MAXVALUE
);

CREATE TABLE user_data (
  id INT PRIMARY KEY,
  name VARCHAR(50),
  uid INT
) ENGINE=InnoDB
PARTITION BY HASH (uid)
PARTITIONS 10; -- 分成10個(gè)表

-- 核心信息表（常用字段）
CREATE TABLE user_core (
  id INT PRIMARY KEY AUTO_INCREMENT,
  username VARCHAR(50),
  email VARCHAR(100),
  create_time DATETIME
) ENGINE=InnoDB;

-- 擴(kuò)展信息表（不常用/大字段）
CREATE TABLE user_extra (
  user_id INT PRIMARY KEY,
  bio TEXT, -- 大文本字段
  avatar BLOB, -- 頭像二進(jìn)制數(shù)據(jù)
  FOREIGN KEY (user_id) REFERENCES user_core(id)
) ENGINE=InnoDB;

-- 只查核心信息（快速）
SELECT username, email FROM user_core WHERE id = 1;

-- 需要擴(kuò)展信息時(shí)關(guān)聯(lián)
SELECT c.username, e.bio 
FROM user_core c
JOIN user_extra e ON c.id = e.user_id
WHERE c.id = 1;