CREATE TABLE animals (
     id MEDIUMINT NOT NULL ...

-- Generate private/public key pair
SET @priv = cr...

-- Set the encryption algorithm and digest type
SE...

SET @priv = create_asymmetric_priv_key('RSA', 2048...

SET @dig = create_digest('SHA512', 'The quick brow...

-- Generate DH shared symmetric secret
SET @dhp = ...

((MINX MINY, MAXX MINY, MAXX MAXY, MINX MAXY, MINX...

mysql> SELECT 1 = 0;
        -> 0
mysql> SELECT '0...

mysql> SELECT 1 <=> 1, NULL <=> NULL, 1 <=> NULL;
...

mysql> SELECT '.01' <> '0.01';
        -> 1
mysql>...

mysql> SELECT 2 BETWEEN 1 AND 3, 2 BETWEEN 3 and 1...

mysql> SELECT COALESCE(NULL,1);
        -> 1
mysql...

mysql> SELECT GREATEST(2,0);
        -> 2
mysql> S...

mysql> SELECT 2 IN (0,3,5,7);
        -> 0
mysql> ...

mysql> SELECT INTERVAL(23, 1, 15, 17, 30, 44, 200)...

mysql> SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNO...

mysql> SELECT 1 IS NOT UNKNOWN, 0 IS NOT UNKNOWN, ...

mysql> SELECT 1 IS NULL, 0 IS NULL, NULL IS NULL;
...

mysql> SELECT 1 IS NOT NULL, 0 IS NOT NULL, NULL I...

mysql> SELECT ISNULL(1+1);
        -> 0
mysql> SEL...

mysql> SELECT LEAST(2,0);
        -> 0
mysql> SELE...

mysql> SELECT NOT 10;
        -> 0
mysql> SELECT N...

mysql> SELECT 1 AND 1;
        -> 1
mysql> SELECT ...

mysql> SELECT 1 OR 1;
        -> 1
mysql> SELECT 1...

mysql> SELECT 1 XOR 1;
        -> 0
mysql> SELECT ...

mysql> SELECT @var1, @var2;
        -> NULL, NULL
...

mysql> SELECT @var1, @var2;
        -> NULL, NULL
...

mysql> SELECT CASE 1 WHEN 1 THEN 'one'
    ->     ...

mysql> SELECT IF(1>2,2,3);
        -> 3
mysql> SEL...

mysql> SELECT IFNULL(1,0);
        -> 1
mysql> SEL...

mysql> SELECT NULLIF(1,1);
        -> NULL
mysql> ...

mysql> SELECT 3*5;
        -> 15
mysql> SELECT 180...

mysql> SELECT 5 DIV 2, -5 DIV 2, 5 DIV -2, -5 DIV ...

mysql> SELECT ABS(2);
        -> 2
mysql> SELECT A...

mysql> SELECT ACOS(1);
        -> 0
mysql> SELECT ...

mysql> SELECT ASIN(0.2);
        -> 0.201357920790...

mysql> SELECT ATAN(2);
        -> 1.1071487177941
...

mysql> SELECT ATAN(-2,2);
        -> -0.7853981633...

mysql> SELECT CEILING(1.23);
        -> 2
mysql> S...

mysql> SELECT CONV('a',16,2);
        -> '1010'
my...

mysql> SELECT COT(12);
        -> -1.5726734063977...

mysql> SELECT CRC32('MySQL');
        -> 325939755...

mysql> SELECT DEGREES(PI());
        -> 180
mysql>...

mysql> SELECT EXP(2);
        -> 7.3890560989307
m...

mysql> SELECT FLOOR(1.23), FLOOR(-1.23);
        -...

mysql> SELECT LN(2);
        -> 0.69314718055995
m...

mysql> SELECT LOG(2);
        -> 0.69314718055995
...

mysql> SELECT LOG2(65536);
        -> 16
mysql> SE...

mysql> SELECT LOG10(2);
        -> 0.3010299956639...

mysql> SELECT MOD(234, 10);
        -> 4
mysql> SE...

mysql> SELECT PI();
        -> 3.141593
mysql> SEL...

mysql> SELECT POW(2,2);
        -> 4
mysql> SELECT...

mysql> SELECT RADIANS(90);
        -> 1.5707963267...

mysql> CREATE TABLE t (i INT);
Query OK, 0 rows af...

mysql> SELECT ROUND(-1.23);
        -> -1
mysql> S...

mysql> SELECT SIGN(-32);
        -> -1
mysql> SELE...

mysql> SELECT SIN(PI());
        -> 1.224606353822...

mysql> SELECT SQRT(4);
        -> 2
mysql> SELECT ...

mysql> SELECT TAN(PI());
        -> -1.22460635382...

mysql> SELECT TRUNCATE(1.223,1);
        -> 1.2
my...

mysql> SELECT ADDDATE('2008-01-02', 31);
        -...

mysql> SELECT ADDTIME('2007-12-31 23:59:59.999999'...

mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GM...

mysql> SELECT CURDATE();
        -> '2008-06-13'
m...

mysql> SELECT CURTIME();
+-----------+
| CURTIME()...

mysql> SELECT DATE('2003-12-31 01:02:03');
       ...

mysql> SELECT DATEDIFF('2007-12-31 23:59:59','2007...

mysql> SELECT DATE_ADD('2018-05-01',INTERVAL 1 DAY...

mysql> SELECT DATE_FORMAT('2009-10-04 22:23:00', '...

mysql> SELECT DAYNAME('2007-02-03');
        -> 'S...

mysql> SELECT DAYOFMONTH('2007-02-03');
        ->...

mysql> SELECT DAYOFWEEK('2007-02-03');
        -> ...

mysql> SELECT DAYOFYEAR('2007-02-03');
        -> ...

mysql> SELECT EXTRACT(YEAR FROM '2019-07-02');
   ...

mysql> SELECT FROM_DAYS(730669);
        -> '2000-...

mysql> SELECT FROM_UNIXTIME(1447430881);
        -...

mysql> SELECT DATE_FORMAT('2003-10-03',GET_FORMAT(...

mysql> SELECT HOUR('10:05:03');
        -> 10
mysq...

mysql> SELECT LAST_DAY('2003-02-05');
        -> '...

mysql> SELECT MAKEDATE(2011,31), MAKEDATE(2011,32)...

mysql> SELECT MAKETIME(12,15,30);
        -> '12:1...

mysql> SELECT MICROSECOND('12:00:00.123456');
    ...

mysql> SELECT MINUTE('2008-02-03 10:05:03');
     ...

mysql> SELECT MONTHNAME('2008-02-03');
        -> ...

mysql> SELECT NOW();
        -> '2007-12-15 23:50:...

mysql> SELECT PERIOD_ADD(200801,2);
        -> 200...

mysql> SELECT PERIOD_DIFF(200802,200703);
        ...

mysql> SELECT SEC_TO_TIME(2378);
        -> '00:39...

mysql> SELECT SUBTIME('2007-12-31 23:59:59.999999'...

mysql> SELECT TIME('2003-12-31 01:02:03');
       ...

mysql> SELECT TIMEDIFF('2000-01-01 00:00:00',
    ...

mysql> SELECT TIMESTAMP('2003-12-31');
        -> ...

mysql> SELECT TIMESTAMPADD(MINUTE, 1, '2003-01-02'...

mysql> SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','20...

mysql> SELECT TIME_FORMAT('100:00:00', '%H %k %h %...

mysql> SELECT TIME_TO_SEC('22:23:00');
        -> ...

mysql> SELECT TO_DAYS(950501);
        -> 728779
m...

mysql> SELECT TO_SECONDS(950501);
        -> 62966...

mysql> SELECT UNIX_TIMESTAMP();
        -> 1447431...

mysql> SELECT UTC_DATE(), UTC_DATE() + 0;
        ...

mysql> SELECT UTC_TIME(), UTC_TIME() + 0;
        ...

mysql> SELECT UTC_TIMESTAMP(), UTC_TIMESTAMP() + 0...

mysql> SELECT WEEK('2008-02-20');
        -> 7
mys...

mysql> SELECT WEEKDAY('2008-02-03 22:23:00');
    ...

mysql> SELECT WEEKOFYEAR('2008-02-20');
        ->...

mysql> SELECT YEARWEEK('1987-01-01');
        -> 1...

mysql> SELECT ASCII('2');
        -> 50
mysql> SEL...

mysql> SELECT CHAR(77,121,83,81,'76');
+----------...

mysql> SELECT CONCAT('My', 'S', 'QL');
        -> ...

mysql> SELECT CONCAT_WS(',','First name','Second n...

mysql> SELECT ELT(1, 'Aa', 'Bb', 'Cc', 'Dd');
    ...

mysql> SELECT EXPORT_SET(5,'Y','N',',',4);
       ...

mysql> SELECT FIELD('Bb', 'Aa', 'Bb', 'Cc', 'Dd', ...

mysql> SELECT FIND_IN_SET('b','a,b,c,d');
        ...

mysql> SELECT FORMAT(12332.123456, 4);
        -> ...

mysql> SELECT TO_BASE64('abc'), FROM_BASE64(TO_BAS...

mysql> SELECT X'616263', HEX('abc'), UNHEX(HEX('ab...

mysql> SELECT INSERT('Quadratic', 3, 4, 'What');
 ...

mysql> SELECT INSTR('foobarbar', 'bar');
        -...

mysql> SELECT LEFT('foobarbar', 5);
        -> 'fo...