MariaDB [toyu]> DELIMITER //
MariaDB [toyu]> 
MariaDB [toyu]> CREATE OR REPLACE PROCEDURE deptInfo(IN dCode VARCHAR(4), OUT numFaculty INT)
    -> BEGIN
    ->    --  Display some information.
    ->    SELECT d.deptName, d.SchoolCode, t1.n_majors, t2.n_minors
    ->    FROM department AS d INNER JOIN
    ->       (SELECT COUNT(stuId) AS n_majors
    ->       FROM student
    ->       WHERE major = dCode) AS t1 INNER JOIN
    ->       (SELECT COUNT(stuId) AS n_minors
    ->       FROM student
    ->       WHERE minor = dCode) AS t2
    ->    WHERE d.deptCode = dCode;
    -> 
    ->    -- MySQL does not direct sending output to console.
    ->    -- It is necessary to use a SQL statement.
    ->    SELECT 'Debuggin comment can be put here.';
    ->    SELECT CONCAT('Faculty in the department: ', dCode) AS faculty;
    -> 
    ->    SELECT *
    ->    FROM faculty AS f
    ->    WHERE f.deptCode = dCode;
    -> 
    ->    SELECT COUNT(f.facId) INTO numFaculty
    ->    FROM faculty AS f
    ->    WHERE f.deptCode = dCode;
    -> END //
Query OK, 0 rows affected (0.010 sec)

MariaDB [toyu]> 
MariaDB [toyu]> DELIMITER ;
MariaDB [toyu]> DELIMITER $$
MariaDB [toyu]> 
MariaDB [toyu]> CREATE OR REPLACE PROCEDURE deptInfo(IN dCode VARCHAR(4), OUT numFaculty INT)
    -> BEGIN
    ->    --  Display some information.
    ->    SELECT d.deptName, d.SchoolCode, t1.n_majors, t2.n_minors
    ->    FROM department AS d INNER JOIN
    ->       (SELECT COUNT(stuId) AS n_majors
    ->       FROM student
    ->       WHERE major = dCode) AS t1 INNER JOIN
    ->       (SELECT COUNT(stuId) AS n_minors
    ->       FROM student
    ->       WHERE minor = dCode) AS t2
    ->    WHERE d.deptCode = dCode;
    -> 
    ->    -- MySQL does not direct sending output to console.
    ->    -- It is necessary to use a SQL statement.
    ->    SELECT 'Debuggin comment can be put here.';
    ->    SELECT CONCAT('Faculty in the department: ', dCode) AS faculty;
    -> 
    ->    SELECT *
    ->    FROM faculty AS f
    ->    WHERE f.deptCode = dCode;
    -> 
    ->    SELECT COUNT(f.facId) INTO numFaculty
    ->    FROM faculty AS f
    ->    WHERE f.deptCode = dCode;
    -> END $$
Query OK, 0 rows affected (0.014 sec)

MariaDB [toyu]> 
MariaDB [toyu]> DELIMITER ;
MariaDB [toyu]> 
MariaDB [toyu]> SHOW CREATE PROCEDURE deptInfo;
+-----------+-----------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| Procedure | sql_mode                                            | Create Procedure                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | character_set_client | collation_connection | Database Collation |
+-----------+-----------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| deptInfo  | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`yue`@`localhost` PROCEDURE `deptInfo`(IN dCode VARCHAR(4), OUT numFaculty INT)
BEGIN
   
   SELECT d.deptName, d.SchoolCode, t1.n_majors, t2.n_minors
   FROM department AS d INNER JOIN
      (SELECT COUNT(stuId) AS n_majors
      FROM student
      WHERE major = dCode) AS t1 INNER JOIN
      (SELECT COUNT(stuId) AS n_minors
      FROM student
      WHERE minor = dCode) AS t2
   WHERE d.deptCode = dCode;

   
   
   SELECT 'Debuggin comment can be put here.';
   SELECT CONCAT('Faculty in the department: ', dCode) AS faculty;

   SELECT *
   FROM faculty AS f
   WHERE f.deptCode = dCode;

   SELECT COUNT(f.facId) INTO numFaculty
   FROM faculty AS f
   WHERE f.deptCode = dCode;
END | cp850                | cp850_general_ci     | utf8mb4_general_ci |
+-----------+-----------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
1 row in set (0.001 sec)

MariaDB [toyu]> SET @numFaculty = 0;
Query OK, 0 rows affected (0.002 sec)

MariaDB [toyu]> SET @dCode = 'CSCI';
Query OK, 0 rows affected (0.000 sec)

MariaDB [toyu]> CALL deptInfo(@dCode, @numFaculty);
+------------------+------------+----------+----------+
| deptName         | SchoolCode | n_majors | n_minors |
+------------------+------------+----------+----------+
| Computer Science | CSE        |        3 |        1 |
+------------------+------------+----------+----------+
1 row in set (0.006 sec)

+-----------------------------------+
| Debuggin comment can be put here. |
+-----------------------------------+
| Debuggin comment can be put here. |
+-----------------------------------+
1 row in set (0.007 sec)

+---------------------------------+
| faculty                         |
+---------------------------------+
| Faculty in the department: CSCI |
+---------------------------------+
1 row in set (0.009 sec)

+-------+--------+--------+----------+---------------------+
| facId | fname  | lname  | deptCode | rank                |
+-------+--------+--------+----------+---------------------+
|  1011 | Paul   | Smith  | CSCI     | Professor           |
|  1012 | Mary   | Tran   | CSCI     | Associate Professor |
|  1013 | David  | Love   | CSCI     | NULL                |
|  1014 | Sharon | Mannes | CSCI     | Assistant Professor |
+-------+--------+--------+----------+---------------------+
4 rows in set (0.010 sec)

Query OK, 1 row affected (0.016 sec)

MariaDB [toyu]> SELECT @dCode, @numFaculty;
+--------+-------------+
| @dCode | @numFaculty |
+--------+-------------+
| CSCI   |           4 |
+--------+-------------+
1 row in set (0.001 sec)

MariaDB [toyu]> 
MariaDB [toyu]> SET @dCode = 'ITEC';
Query OK, 0 rows affected (0.000 sec)

MariaDB [toyu]> CALL deptInfo(@dCode, @numFaculty);
+------------------------+------------+----------+----------+
| deptName               | SchoolCode | n_majors | n_minors |
+------------------------+------------+----------+----------+
| Information Technology | CSE        |        2 |        2 |
+------------------------+------------+----------+----------+
1 row in set (0.001 sec)

+-----------------------------------+
| Debuggin comment can be put here. |
+-----------------------------------+
| Debuggin comment can be put here. |
+-----------------------------------+
1 row in set (0.003 sec)

+---------------------------------+
| faculty                         |
+---------------------------------+
| Faculty in the department: ITEC |
+---------------------------------+
1 row in set (0.004 sec)

+-------+----------+-------+----------+-----------+
| facId | fname    | lname | deptCode | rank      |
+-------+----------+-------+----------+-----------+
|  1017 | Deborah  | Gump  | ITEC     | Professor |
|  1019 | Benjamin | Yu    | ITEC     | Lecturer  |
+-------+----------+-------+----------+-----------+
2 rows in set (0.005 sec)

Query OK, 1 row affected (0.008 sec)

MariaDB [toyu]> SELECT @dCode, @numFaculty;
+--------+-------------+
| @dCode | @numFaculty |
+--------+-------------+
| ITEC   |           2 |
+--------+-------------+
1 row in set (0.000 sec)

MariaDB [toyu]> CALL deptInfo('CINF', @numFaculty);
+------------------------------+------------+----------+----------+
| deptName                     | SchoolCode | n_majors | n_minors |
+------------------------------+------------+----------+----------+
| Computer Information Systems | CSE        |        2 |        3 |
+------------------------------+------------+----------+----------+
1 row in set (0.002 sec)

+-----------------------------------+
| Debuggin comment can be put here. |
+-----------------------------------+
| Debuggin comment can be put here. |
+-----------------------------------+
1 row in set (0.004 sec)

+---------------------------------+
| faculty                         |
+---------------------------------+
| Faculty in the department: CINF |
+---------------------------------+
1 row in set (0.006 sec)

+-------+--------+-------+----------+---------------------+
| facId | fname  | lname | deptCode | rank                |
+-------+--------+-------+----------+---------------------+
|  1015 | Daniel | Kim   | CINF     | Professor           |
|  1016 | Andrew | Byre  | CINF     | Associate Professor |
+-------+--------+-------+----------+---------------------+
2 rows in set (0.007 sec)

Query OK, 1 row affected (0.011 sec)

MariaDB [toyu]> SELECT @dCode, @numFaculty;
+--------+-------------+
| @dCode | @numFaculty |
+--------+-------------+
| ITEC   |           2 |
+--------+-------------+
1 row in set (0.001 sec)

MariaDB [toyu]> 
MariaDB [toyu]> CALL deptInfo('CINF', @numFaculty);
+------------------------------+------------+----------+----------+
| deptName                     | SchoolCode | n_majors | n_minors |
+------------------------------+------------+----------+----------+
| Computer Information Systems | CSE        |        2 |        3 |
+------------------------------+------------+----------+----------+
1 row in set (0.001 sec)

+-----------------------------------+
| Debuggin comment can be put here. |
+-----------------------------------+
| Debuggin comment can be put here. |
+-----------------------------------+
1 row in set (0.002 sec)

+---------------------------------+
| faculty                         |
+---------------------------------+
| Faculty in the department: CINF |
+---------------------------------+
1 row in set (0.003 sec)

+-------+--------+-------+----------+---------------------+
| facId | fname  | lname | deptCode | rank                |
+-------+--------+-------+----------+---------------------+
|  1015 | Daniel | Kim   | CINF     | Professor           |
|  1016 | Andrew | Byre  | CINF     | Associate Professor |
+-------+--------+-------+----------+---------------------+
2 rows in set (0.005 sec)

Query OK, 1 row affected (0.007 sec)

MariaDB [toyu]> SELECT 'CINF', @numFaculty;
+------+-------------+
| CINF | @numFaculty |
+------+-------------+
| CINF |           2 |
+------+-------------+
1 row in set (0.000 sec)

MariaDB [toyu]> CALL deptInfo('CINF', 2);
ERROR 1414 (42000): OUT or INOUT argument 2 for routine toyu.deptInfo is not a variable or NEW pseudo-variable in BEFORE trigger
MariaDB [toyu]> DELIMITER //
MariaDB [toyu]> CREATE OR REPLACE PROCEDURE AddNewCourse(
    ->     IN course_id INT,
    ->     IN rubric CHAR(4),
    ->     IN course_number CHAR(4),
    ->     IN course_title VARCHAR(80),
    ->     IN credits TINYINT
    -> )
    -> BEGIN
    ->     INSERT INTO Course (courseId, rubric, number, title, credits)
    ->     VALUES (course_id, rubric, course_number, course_title, credits);
    -> -- add audit logic.
    ->      -- add alert..
    -> END //
Query OK, 0 rows affected (0.015 sec)

MariaDB [toyu]> DELIMITER ;
MariaDB [toyu]> CALL AddNewCourse(3009, 'CSCI', '4436', 'Systems Administration', 3);
Query OK, 1 row affected (0.013 sec)

MariaDB [toyu]> -- A simple function: no OUT or INOUT parameter passing mode. IN is the only acceptable parameter passing mode.
MariaDB [toyu]> DELIMITER //
MariaDB [toyu]> 
MariaDB [toyu]> CREATE OR REPLACE FUNCTION n_major(dCode varchar(4)) RETURNS INT
    -> READS SQL DATA
    -> BEGIN
    ->    DECLARE count INT DEFAULT 0;
    -> 
    ->    SELECT COUNT(*) INTO count
    ->    FROM student
    ->    WHERE major = dCode;
    -> 
    ->    RETURN count;
    -> END //
Query OK, 0 rows affected (0.011 sec)

MariaDB [toyu]> 
MariaDB [toyu]> DELIMITER ;
MariaDB [toyu]> 
MariaDB [toyu]> SHOW CREATE FUNCTION n_major;
+----------+-----------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| Function | sql_mode                                            | Create Function                                                                                                                                                                                                                             | character_set_client | collation_connection | Database Collation |
+----------+-----------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| n_major  | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`yue`@`localhost` FUNCTION `n_major`(dCode varchar(4)) RETURNS int(11)
    READS SQL DATA
BEGIN
   DECLARE count INT DEFAULT 0;

   SELECT COUNT(*) INTO count
   FROM student
   WHERE major = dCode;

   RETURN count;
END | cp850                | cp850_general_ci     | utf8mb4_general_ci |
+----------+-----------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
1 row in set (0.000 sec)

MariaDB [toyu]> 
MariaDB [toyu]> SELECT n_major('CSCI');
+-----------------+
| n_major('CSCI') |
+-----------------+
|               3 |
+-----------------+
1 row in set (0.002 sec)

MariaDB [toyu]> SELECT n_major('ITEC');
+-----------------+
| n_major('ITEC') |
+-----------------+
|               2 |
+-----------------+
1 row in set (0.000 sec)

MariaDB [toyu]> DELIMITER //
MariaDB [toyu]> 
MariaDB [toyu]> CREATE OR REPLACE FUNCTION n_major(dCode varchar(4)) RETURNS INT
    -> READS SQL DATA
    -> BEGIN
    ->    DECLARE count INT DEFAULT 0;
    -> 
    ->    SELECT COUNT(*)  -- INTO count
    ->    FROM student
    ->    WHERE major = dCode;
    -> 
    ->    RETURN count;
    -> END //
ERROR 1415 (0A000): Not allowed to return a result set from a function
MariaDB [toyu]> 
MariaDB [toyu]> DELIMITER ;
MariaDB [toyu]> SELECT "Hello, world";
+--------------+
| Hello, world |
+--------------+
| Hello, world |
+--------------+
1 row in set (0.000 sec)

MariaDB [toyu]> source createtoyu.sql
Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 9 rows affected (0.136 sec)

Query OK, 1 row affected (0.002 sec)

Database changed
Query OK, 0 rows affected, 1 warning (0.000 sec)

Query OK, 0 rows affected, 1 warning (0.000 sec)

Query OK, 0 rows affected, 1 warning (0.000 sec)

Query OK, 0 rows affected, 1 warning (0.000 sec)

Query OK, 0 rows affected, 1 warning (0.000 sec)

Query OK, 0 rows affected, 1 warning (0.000 sec)

Query OK, 0 rows affected, 1 warning (0.000 sec)

Query OK, 0 rows affected, 1 warning (0.000 sec)

Query OK, 0 rows affected, 1 warning (0.020 sec)

Query OK, 0 rows affected, 1 warning (0.031 sec)

Query OK, 0 rows affected, 1 warning (0.030 sec)

Query OK, 0 rows affected, 1 warning (0.026 sec)

Query OK, 0 rows affected, 1 warning (0.025 sec)

Query OK, 0 rows affected, 1 warning (0.030 sec)

Query OK, 0 rows affected, 1 warning (0.031 sec)

Query OK, 0 rows affected, 1 warning (0.027 sec)

Query OK, 0 rows affected (0.010 sec)

Query OK, 0 rows affected (0.010 sec)

Query OK, 0 rows affected (0.010 sec)

Query OK, 0 rows affected (0.010 sec)

Query OK, 0 rows affected (0.010 sec)

Query OK, 15 rows affected (0.004 sec)
Records: 15  Duplicates: 0  Warnings: 0

Query OK, 4 rows affected (0.009 sec)
Records: 4  Duplicates: 0  Warnings: 0

Query OK, 7 rows affected (0.005 sec)
Records: 7  Duplicates: 0  Warnings: 0

Query OK, 11 rows affected (0.009 sec)
Records: 11  Duplicates: 0  Warnings: 0

Query OK, 11 rows affected (0.010 sec)
Records: 11  Duplicates: 0  Warnings: 0

Query OK, 14 rows affected (0.011 sec)
Records: 14  Duplicates: 0  Warnings: 0

Query OK, 11 rows affected (0.005 sec)
Records: 11  Duplicates: 0  Warnings: 0

Query OK, 22 rows affected (0.005 sec)
Records: 22  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

MariaDB [toyu]> show databases;
+--------------------+
| Database           |
+--------------------+
| ctetinker          |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| swim               |
| test               |
| toyu               |
+--------------------+
8 rows in set (0.003 sec)

MariaDB [toyu]> -- Getting selected columns from information_schema
MariaDB [toyu]> SELECT table_name, table_type, row_format, table_rows, avg_row_length
    -> FROM information_schema.tables
    -> WHERE table_schema = 'information_schema'
    -> ORDER BY table_name DESC;
+---------------------------------------+-------------+------------+------------+----------------+
| table_name                            | table_type  | row_format | table_rows | avg_row_length |
+---------------------------------------+-------------+------------+------------+----------------+
| VIEWS                                 | SYSTEM VIEW | Page       |       NULL |              0 |
| user_variables                        | SYSTEM VIEW | Fixed      |       NULL |           6630 |
| USER_STATISTICS                       | SYSTEM VIEW | Fixed      |       NULL |            567 |
| USER_PRIVILEGES                       | SYSTEM VIEW | Fixed      |       NULL |           2314 |
| TRIGGERS                              | SYSTEM VIEW | Page       |       NULL |              0 |
| TABLE_STATISTICS                      | SYSTEM VIEW | Fixed      |       NULL |           1181 |
| TABLE_PRIVILEGES                      | SYSTEM VIEW | Fixed      |       NULL |           2700 |
| TABLE_CONSTRAINTS                     | SYSTEM VIEW | Fixed      |       NULL |           2504 |
| TABLESPACES                           | SYSTEM VIEW | Fixed      |       NULL |           6951 |
| TABLES                                | SYSTEM VIEW | Fixed      |       NULL |          14841 |
| SYSTEM_VARIABLES                      | SYSTEM VIEW | Page       |       NULL |              0 |
| STATISTICS                            | SYSTEM VIEW | Fixed      |       NULL |           5753 |
| SQL_FUNCTIONS                         | SYSTEM VIEW | Fixed      |       NULL |            194 |
| SPATIAL_REF_SYS                       | SYSTEM VIEW | Fixed      |       NULL |           7691 |
| SESSION_VARIABLES                     | SYSTEM VIEW | Fixed      |       NULL |           6340 |
| SESSION_STATUS                        | SYSTEM VIEW | Fixed      |       NULL |           6340 |
| SCHEMA_PRIVILEGES                     | SYSTEM VIEW | Fixed      |       NULL |           2507 |
| SCHEMATA                              | SYSTEM VIEW | Fixed      |       NULL |           3464 |
| ROUTINES                              | SYSTEM VIEW | Page       |       NULL |              0 |
| REFERENTIAL_CONSTRAINTS               | SYSTEM VIEW | Fixed      |       NULL |           4814 |
| PROFILING                             | SYSTEM VIEW | Fixed      |       NULL |            308 |
| PROCESSLIST                           | SYSTEM VIEW | Page       |       NULL |              0 |
| PLUGINS                               | SYSTEM VIEW | Page       |       NULL |              0 |
| PARTITIONS                            | SYSTEM VIEW | Page       |       NULL |              0 |
| PARAMETERS                            | SYSTEM VIEW | Page       |       NULL |              0 |
| OPTIMIZER_TRACE                       | SYSTEM VIEW | Page       |       NULL |              0 |
| KEY_COLUMN_USAGE                      | SYSTEM VIEW | Fixed      |       NULL |           4637 |
| KEY_CACHES                            | SYSTEM VIEW | Fixed      |       NULL |            659 |
| KEYWORDS                              | SYSTEM VIEW | Fixed      |       NULL |            194 |
| INNODB_TRX                            | SYSTEM VIEW | Fixed      |       NULL |           4530 |
| INNODB_TABLESPACES_SCRUBBING          | SYSTEM VIEW | Fixed      |       NULL |           2020 |
| INNODB_TABLESPACES_ENCRYPTION         | SYSTEM VIEW | Fixed      |       NULL |           2012 |
| INNODB_SYS_VIRTUAL                    | SYSTEM VIEW | Fixed      |       NULL |             17 |
| INNODB_SYS_TABLESTATS                 | SYSTEM VIEW | Fixed      |       NULL |           1215 |
| INNODB_SYS_TABLESPACES                | SYSTEM VIEW | Fixed      |       NULL |           2102 |
| INNODB_SYS_TABLES                     | SYSTEM VIEW | Fixed      |       NULL |           2060 |
| INNODB_SYS_SEMAPHORE_WAITS            | SYSTEM VIEW | Fixed      |       NULL |          60189 |
| INNODB_SYS_INDEXES                    | SYSTEM VIEW | Fixed      |       NULL |            618 |
| INNODB_SYS_FOREIGN_COLS               | SYSTEM VIEW | Fixed      |       NULL |           1748 |
| INNODB_SYS_FOREIGN                    | SYSTEM VIEW | Fixed      |       NULL |           1752 |
| INNODB_SYS_FIELDS                     | SYSTEM VIEW | Fixed      |       NULL |            594 |
| INNODB_SYS_DATAFILES                  | SYSTEM VIEW | Fixed      |       NULL |          12007 |
| INNODB_SYS_COLUMNS                    | SYSTEM VIEW | Fixed      |       NULL |            610 |
| INNODB_MUTEXES                        | SYSTEM VIEW | Fixed      |       NULL |          24017 |
| INNODB_METRICS                        | SYSTEM VIEW | Fixed      |       NULL |           3003 |
| INNODB_LOCK_WAITS                     | SYSTEM VIEW | Fixed      |       NULL |            599 |
| INNODB_LOCKS                          | SYSTEM VIEW | Fixed      |       NULL |          31244 |
| INNODB_FT_INDEX_TABLE                 | SYSTEM VIEW | Fixed      |       NULL |           1054 |
| INNODB_FT_INDEX_CACHE                 | SYSTEM VIEW | Fixed      |       NULL |           1054 |
| INNODB_FT_DELETED                     | SYSTEM VIEW | Fixed      |       NULL |              9 |
| INNODB_FT_DEFAULT_STOPWORD            | SYSTEM VIEW | Fixed      |       NULL |             56 |
| INNODB_FT_CONFIG                      | SYSTEM VIEW | Fixed      |       NULL |           1163 |
| INNODB_FT_BEING_DELETED               | SYSTEM VIEW | Fixed      |       NULL |              9 |
| INNODB_CMP_RESET                      | SYSTEM VIEW | Fixed      |       NULL |             25 |
| INNODB_CMP_PER_INDEX_RESET            | SYSTEM VIEW | Fixed      |       NULL |           1755 |
| INNODB_CMP_PER_INDEX                  | SYSTEM VIEW | Fixed      |       NULL |           1755 |
| INNODB_CMPMEM_RESET                   | SYSTEM VIEW | Fixed      |       NULL |             29 |
| INNODB_CMPMEM                         | SYSTEM VIEW | Fixed      |       NULL |             29 |
| INNODB_CMP                            | SYSTEM VIEW | Fixed      |       NULL |             25 |
| INNODB_BUFFER_POOL_STATS              | SYSTEM VIEW | Fixed      |       NULL |            257 |
| INNODB_BUFFER_PAGE_LRU                | SYSTEM VIEW | Fixed      |       NULL |           6669 |
| INNODB_BUFFER_PAGE                    | SYSTEM VIEW | Fixed      |       NULL |           6852 |
| INDEX_STATISTICS                      | SYSTEM VIEW | Fixed      |       NULL |           1743 |
| GLOBAL_VARIABLES                      | SYSTEM VIEW | Fixed      |       NULL |           6340 |
| GLOBAL_STATUS                         | SYSTEM VIEW | Fixed      |       NULL |           6340 |
| GEOMETRY_COLUMNS                      | SYSTEM VIEW | Fixed      |       NULL |           4244 |
| FILES                                 | SYSTEM VIEW | Fixed      |       NULL |           4022 |
| EVENTS                                | SYSTEM VIEW | Page       |       NULL |              0 |
| ENGINES                               | SYSTEM VIEW | Fixed      |       NULL |            731 |
| ENABLED_ROLES                         | SYSTEM VIEW | Fixed      |       NULL |            387 |
| COLUMN_PRIVILEGES                     | SYSTEM VIEW | Fixed      |       NULL |           2893 |
| COLUMNS                               | SYSTEM VIEW | Page       |       NULL |              0 |
| COLLATION_CHARACTER_SET_APPLICABILITY | SYSTEM VIEW | Fixed      |       NULL |            195 |
| COLLATIONS                            | SYSTEM VIEW | Fixed      |       NULL |            231 |
| CLIENT_STATISTICS                     | SYSTEM VIEW | Fixed      |       NULL |            386 |
| CHECK_CONSTRAINTS                     | SYSTEM VIEW | Page       |       NULL |              0 |
| CHARACTER_SETS                        | SYSTEM VIEW | Fixed      |       NULL |            384 |
| APPLICABLE_ROLES                      | SYSTEM VIEW | Fixed      |       NULL |            979 |
| ALL_PLUGINS                           | SYSTEM VIEW | Page       |       NULL |              0 |
+---------------------------------------+-------------+------------+------------+----------------+
79 rows in set (0.084 sec)

MariaDB [toyu]> SELECT table_name, table_type, row_format, table_rows, avg_row_length
    -> FROM information_schema.tables
    -> WHERE table_schema = 'toyu'
    -> ORDER BY table_name DESC;
+------------+------------+------------+------------+----------------+
| table_name | table_type | row_format | table_rows | avg_row_length |
+------------+------------+------------+------------+----------------+
| student    | BASE TABLE | Dynamic    |         11 |           1489 |
| school     | BASE TABLE | Dynamic    |          4 |           4096 |
| grade      | BASE TABLE | Dynamic    |         15 |           1092 |
| faculty    | BASE TABLE | Dynamic    |         11 |           1489 |
| enroll     | BASE TABLE | Dynamic    |         22 |            744 |
| department | BASE TABLE | Dynamic    |          7 |           2340 |
| course     | BASE TABLE | Dynamic    |         11 |           1489 |
| class      | BASE TABLE | Dynamic    |         14 |           1170 |
+------------+------------+------------+------------+----------------+
8 rows in set (0.001 sec)

MariaDB [toyu]> notee