是可能的在mysql重复相同的结果 [英] is to be posible in mysql repeat the same result

问题描述

我只能选择1个结果

例如: SELECT + FROM table1

ex: SELECT + FROM table1

我需要尝试很多结果，就是可能在此选择中添加任何单词，以相同的结果重复很多次.

I need try it with a lot of results, is to be possibe add any word in this select to repeat this a lot of times with the same result.

谢谢

推荐答案

您可以添加一些交叉联接.每增加一个交叉联接，结果的数量将乘以交叉联接表的大小.

You could add some cross joins in. Each additional cross join will multiply the number of results by the size of the cross joined table.

SELECT table1.*
FROM table1, 
INFORMATION_SCHEMA.COLUMNS c1, 
INFORMATION_SCHEMA.COLUMNS c2, 
INFORMATION_SCHEMA.COLUMNS c3, 
INFORMATION_SCHEMA.COLUMNS c4

这篇关于是可能的在mysql重复相同的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！