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>