MySQL日历重复事件与自定义信息

在MySQL中实现日历重复事件和自定义信息，可以通过以下步骤进行：

1. 创建数据库和表结构：

CREATE DATABASE calendar;
USE calendar;

CREATE TABLE events (
  id INT AUTO_INCREMENT PRIMARY KEY,
  event_name VARCHAR(100),
  start_date DATETIME,
  end_date DATETIME,
  repeat_type ENUM('none', 'daily', 'weekly', 'monthly', 'yearly'),
  repeat_interval INT,
  custom_info VARCHAR(255)
);

2. 插入日历事件数据：

INSERT INTO events (event_name, start_date, end_date, repeat_type, repeat_interval, custom_info)
VALUES ('Meeting', '2022-01-01 09:00:00', '2022-01-01 10:00:00', 'none', NULL, 'Custom info for meeting');

INSERT INTO events (event_name, start_date, end_date, repeat_type, repeat_interval, custom_info)
VALUES ('Daily Event', '2022-01-02 10:00:00', '2022-01-02 11:00:00', 'daily', 1, 'Custom info for daily event');

INSERT INTO events (event_name, start_date, end_date, repeat_type, repeat_interval, custom_info)
VALUES ('Weekly Event', '2022-01-03 11:00:00', '2022-01-03 12:00:00', 'weekly', 1, 'Custom info for weekly event');

INSERT INTO events (event_name, start_date, end_date, repeat_type, repeat_interval, custom_info)
VALUES ('Monthly Event', '2022-01-04 12:00:00', '2022-01-04 13:00:00', 'monthly', 1, 'Custom info for monthly event');

INSERT INTO events (event_name, start_date, end_date, repeat_type, repeat_interval, custom_info)
VALUES ('Yearly Event', '2022-01-05 13:00:00', '2022-01-05 14:00:00', 'yearly', 1, 'Custom info for yearly event');

3. 查询日历事件数据：

-- 查询所有事件
SELECT * FROM events;

-- 查询今天的事件
SELECT * FROM events WHERE DATE(start_date) = CURDATE();

-- 查询重复事件
SELECT * FROM events WHERE repeat_type != 'none';

-- 查询自定义信息包含特定关键字的事件
SELECT * FROM events WHERE custom_info LIKE '%keyword%';

这样，你就可以在MySQL中实现日历重复事件和自定义信息的功能。根据实际需求，你可以根据具体的时间和重复类型来查询事件，并通过自定义信息字段来存储和检索相关信息。