mysql> set @a=1; Query OK, 0 rows affected (0.00 sec) mysql> select @a:=@a*a as x from inno limit 70; +----------------------+ | x | +----------------------+ | 1 | | 2 | | 6 | | 24 | | 120 | | 720 | | 5040 | | 40320 | | 362880 | | 3628800 | | 39916800 | | 479001600 | | 6227020800 | | 87178291200 | | 1307674368000 | | 20922789888000 | | 355687428096000 | | 6402373705728000 | | 121645100408832000 | | 2432902008176640000 | | -4249290049419214848 | | -1250660718674968576 | | 8128291617894825984 | | -7835185981329244160 | | 7034535277573963776 | | -1569523520172457984 | | -5483646897237262336 | | -5968160532966932480 | | -7055958792655077376 | | -8764578968847253504 | | 4999213071378415616 | | -6045878379276664832 | | 3400198294675128320 | | 4926277576697053184 | | 6399018521010896896 | | 9003737871877668864 | | 1096907932701818880 | | 4789013295250014208 | | 2304077777655037952 | | -70609262346240000 | | -2894979756195840000 | | 7538058755741581312 | | -7904866829883932672 | | 2673996885588443136 | | -8797348664486920192 | | 1150331055211806720 | | -1274672626173739008 | | -5844053835210817536 | | 8789267254022766592 | | -3258495067890909184 | | -162551799050403840 | | -8452693550620999680 | | -5270900413883744256 | | -7927461244078915584 | | 6711489344688881664 | | 6908521828386340864 | | 6404118670120845312 | | 2504001392817995776 | | 162129586585337856 | | -8718968878589280256 | | 3098476543630901248 | | 7638104968020361216 | | 1585267068834414592 | | -9223372036854775808 | | -9223372036854775808 | | 0 | | 0 | | 0 | | 0 | | 0 | +----------------------+ 70 rows in set (0.00 sec) mysql> set @a=1.0; Query OK, 0 rows affected (0.00 sec) mysql> select @a:=@a*a as x from inno limit 70; +---------------------------------------------------------------------+ | x | +---------------------------------------------------------------------+ | 1.0 | | 2.0 | | 6.0 | | 24.0 | | 120.0 | | 720.0 | | 5040.0 | | 40320.0 | | 362880.0 | | 3628800.0 | | 39916800.0 | | 479001600.0 | | 6227020800.0 | | 87178291200.0 | | 1307674368000.0 | | 20922789888000.0 | | 355687428096000.0 | | 6402373705728000.0 | | 121645100408832000.0 | | 2432902008176640000.0 | | 51090942171709440000.0 | | 1124000727777607680000.0 | | 25852016738884976640000.0 | | 620448401733239439360000.0 | | 15511210043330985984000000.0 | | 403291461126605635584000000.0 | | 10888869450418352160768000000.0 | | 304888344611713860501504000000.0 | | 8841761993739701954543616000000.0 | | 265252859812191058636308480000000.0 | | 8222838654177922817725562880000000.0 | | 263130836933693530167218012160000000.0 | | 8683317618811886495518194401280000000.0 | | 295232799039604140847618609643520000000.0 | | 10333147966386144929666651337523200000000.0 | | 371993326789901217467999448150835200000000.0 | | 13763753091226345046315979581580902400000000.0 | | 523022617466601111760007224100074291200000000.0 | | 20397882081197443358640281739902897356800000000.0 | | 815915283247897734345611269596115894272000000000.0 | | 33452526613163807108170062053440751665152000000000.0 | | 1405006117752879898543142606244511569936384000000000.0 | | 60415263063373835637355132068513997507264512000000000.0 | | 2658271574788448768043625811014615890319638528000000000.0 | | 119622220865480194561963161495657715064383733760000000000.0 | | 5502622159812088949850305428800254892961651752960000000000.0 | | 258623241511168180642964355153611979969197632389120000000000.0 | | 12413915592536072670862289047373375038521486354677760000000000.0 | | 608281864034267560872252163321295376887552831379210240000000000.0 | | 30414093201713378043612608166064768844377641568960512000000000000.0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | +---------------------------------------------------------------------+ 70 rows in set (0.00 sec) mysql>