Timeline for The Smart Person's Mirage
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 7, 2015 at 23:10 | comment | added | jimmy23013 | @Ben But recursive ways doesn't always look good. I'll not fix my answer by changing the dialect because there is already an Oracle SQL answer. | |
| Mar 7, 2015 at 19:27 | comment | added | Ben | As far as I'm aware MySQL is the only SQL dialect that doesn't have an easy row-generator option. Most can just use a recursive common table expression. | |
| Mar 7, 2015 at 2:30 | comment | added | DanielST | Just self join it if you need more rows. | |
| Mar 7, 2015 at 2:25 | comment | added | jimmy23013 |
@slicedtoad SELECT DISTINCT help_keyword_id FROM mysql.help_relation WHERE help_keyword_id>0 AND help_keyword_id<=100 also worked. But if 100 is changed to 10000, both will be broken.
|
|
| Mar 6, 2015 at 17:17 | comment | added | DanielST |
You can use variables in mysql. SELECT @i:= (@i + 1) FROM mysql.help_relation, (SELECT @i:=0) v WHERE @i < 100;
|
|
| Mar 5, 2015 at 1:12 | history | edited | jimmy23013 | CC BY-SA 3.0 |
added 32 characters in body
|
| Mar 5, 2015 at 0:45 | history | answered | jimmy23013 | CC BY-SA 3.0 |