在一个数据库表单中有以下字段 INSERT INTO notification(tenant_id(int),title(String),category(int),release_time(date),content(String),create_user(int),create_dept(int),create_time(date)) 请帮我生成十个用于插入的数据代码
时间: 2024-04-11 12:33:57 浏览: 17
根据您提供的表单字段,我为您生成了十个用于插入的数据代码示例:
```
INSERT INTO notification(tenant_id, title, category, release_time, content, create_user, create_dept, create_time)
VALUES
(1, 'Notification 1', 1, '2023-07-15', 'Content 1', 3, 5, '2023-07-12'),
(2, 'Notification 2', 2, '2023-07-16', 'Content 2', 4, 6, '2023-07-13'),
(3, 'Notification 3', 1, '2023-07-17', 'Content 3', 5, 7, '2023-07-14'),
(4, 'Notification 4', 3, '2023-07-18', 'Content 4', 6, 8, '2023-07-15'),
(5, 'Notification 5', 2, '2023-07-19', 'Content 5', 7, 9, '2023-07-16'),
(6, 'Notification 6', 1, '2023-07-20', 'Content 6', 8, 10, '2023-07-17'),
(7, 'Notification 7', 3, '2023-07-21', 'Content 7', 9, 11, '2023-07-18'),
(8, 'Notification 8', 2, '2023-07-22', 'Content 8', 10, 12, '2023-07-19'),
(9, 'Notification 9', 1, '2023-07-23', 'Content 9', 11, 13, '2023-07-20'),
(10, 'Notification 10', 3, '2023-07-24', 'Content 10', 12, 14, '2023-07-21');
```
请注意,这只是示例数据,您可以根据需要调整字段和值。确保在实际使用时,数据类型和格式与数据库表定义相匹配。