SELECT
*
FROM (
SELECT
regexp_split_to_table('a,b,c', ',') a) AS aa
CROSS JOIN (
SELECT
regexp_split_to_table('1,3', ',') b) AS bb;结果如下：
| a | b |
|---|---|
| a | 1 |
| a | 3 |
| b | 1 |
| b | 3 |
| c | 1 |
| c | 3 |
了解 工作生活心情记忆 的更多信息
订阅后即可通过电子邮件收到最新文章。
好记性不如烂笔头
SELECT
*
FROM (
SELECT
regexp_split_to_table('a,b,c', ',') a) AS aa
CROSS JOIN (
SELECT
regexp_split_to_table('1,3', ',') b) AS bb;结果如下：
| a | b |
|---|---|
| a | 1 |
| a | 3 |
| b | 1 |
| b | 3 |
| c | 1 |
| c | 3 |
订阅后即可通过电子邮件收到最新文章。