Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- SUBSTR(3987654321, (@cnt := @cnt + 1), 1) AS SplitDigits
- -- from any table has rows greater than or equal to 10
- FROM (SELECT NULL FROM INFORMATION_SCHEMA.TABLES LIMIT 10) A
- CROSS JOIN (SELECT @cnt := 0) B
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement