写一个sql语句,插入25条记录,类型有:bigint,varchar,varchar,varchar,smallint,varchar,datetime,varchar,datetime,varchar
时间: 2024-06-09 07:07:05 浏览: 6
假设你要插入的表名为 `myTable`,可以使用以下 SQL 语句插入 25 条记录:
```
INSERT INTO myTable (col1, col2, col3, col4, col5, col6, col7, col8, col9, col10)
VALUES
(1234567890, 'value1', 'value2', 'value3', 1, 'value4', '2021-01-01 00:00:00', 'value5', '2021-01-01 00:00:00', 'value6'),
(2345678901, 'value7', 'value8', 'value9', 2, 'value10', '2021-01-02 00:00:00', 'value11', '2021-01-02 00:00:00', 'value12'),
(3456789012, 'value13', 'value14', 'value15', 3, 'value16', '2021-01-03 00:00:00', 'value17', '2021-01-03 00:00:00', 'value18'),
(4567890123, 'value19', 'value20', 'value21', 4, 'value22', '2021-01-04 00:00:00', 'value23', '2021-01-04 00:00:00', 'value24'),
(5678901234, 'value25', 'value26', 'value27', 5, 'value28', '2021-01-05 00:00:00', 'value29', '2021-01-05 00:00:00', 'value30'),
(6789012345, 'value31', 'value32', 'value33', 6, 'value34', '2021-01-06 00:00:00', 'value35', '2021-01-06 00:00:00', 'value36'),
(7890123456, 'value37', 'value38', 'value39', 7, 'value40', '2021-01-07 00:00:00', 'value41', '2021-01-07 00:00:00', 'value42'),
(8901234567, 'value43', 'value44', 'value45', 8, 'value46', '2021-01-08 00:00:00', 'value47', '2021-01-08 00:00:00', 'value48'),
(9012345678, 'value49', 'value50', 'value51', 9, 'value52', '2021-01-09 00:00:00', 'value53', '2021-01-09 00:00:00', 'value54'),
(1234567890, 'value55', 'value56', 'value57', 10, 'value58', '2021-01-10 00:00:00', 'value59', '2021-01-10 00:00:00', 'value60'),
(2345678901, 'value61', 'value62', 'value63', 11, 'value64', '2021-01-11 00:00:00', 'value65', '2021-01-11 00:00:00', 'value66'),
(3456789012, 'value67', 'value68', 'value69', 12, 'value70', '2021-01-12 00:00:00', 'value71', '2021-01-12 00:00:00', 'value72'),
(4567890123, 'value73', 'value74', 'value75', 13, 'value76', '2021-01-13 00:00:00', 'value77', '2021-01-13 00:00:00', 'value78'),
(5678901234, 'value79', 'value80', 'value81', 14, 'value82', '2021-01-14 00:00:00', 'value83', '2021-01-14 00:00:00', 'value84'),
(6789012345, 'value85', 'value86', 'value87', 15, 'value88', '2021-01-15 00:00:00', 'value89', '2021-01-15 00:00:00', 'value90'),
(7890123456, 'value91', 'value92', 'value93', 16, 'value94', '2021-01-16 00:00:00', 'value95', '2021-01-16 00:00:00', 'value96'),
(8901234567, 'value97', 'value98', 'value99', 17, 'value100', '2021-01-17 00:00:00', 'value101', '2021-01-17 00:00:00', 'value102'),
(9012345678, 'value103', 'value104', 'value105', 18, 'value106', '2021-01-18 00:00:00', 'value107', '2021-01-18 00:00:00', 'value108'),
(1234567890, 'value109', 'value110', 'value111', 19, 'value112', '2021-01-19 00:00:00', 'value113', '2021-01-19 00:00:00', 'value114'),
(2345678901, 'value115', 'value116', 'value117', 20, 'value118', '2021-01-20 00:00:00', 'value119', '2021-01-20 00:00:00', 'value120'),
(3456789012, 'value121', 'value122', 'value123', 21, 'value124', '2021-01-21 00:00:00', 'value125', '2021-01-21 00:00:00', 'value126'),
(4567890123, 'value127', 'value128', 'value129', 22, 'value130', '2021-01-22 00:00:00', 'value131', '2021-01-22 00:00:00', 'value132'),
(5678901234, 'value133', 'value134', 'value135', 23, 'value136', '2021-01-23 00:00:00', 'value137', '2021-01-23 00:00:00', 'value138'),
(6789012345, 'value139', 'value140', 'value141', 24, 'value142', '2021-01-24 00:00:00', 'value143', '2021-01-24 00:00:00', 'value144'),
(7890123456, 'value145', 'value146', 'value147', 25, 'value148', '2021-01-25 00:00:00', 'value149', '2021-01-25 00:00:00', 'value150');
```
这里假设 `col1` 是 `bigint` 类型,`col2`、`col3`、`col4`、`col6` 和 `col8` 是 `varchar` 类型,`col5` 是 `smallint` 类型,`col7` 和 `col9` 是 `datetime` 类型,`col10` 是 `varchar` 类型。你需要将 `value1` 到 `value150` 替换成你需要插入的具体值。
相关推荐
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)