MySQL sample code to get the total number of all tabular data in the database

SELECT 
    table_name AS 'Table',
    table_rows AS 'Rows'
FROM 
    information_schema.tables
WHERE 
    table_schema = 'your_database_name'
    AND table_type = 'BASE TABLE';

SELECT SUM(table_rows) 
FROM information_schema.tables 
WHERE table_schema = 'your_database_name';

DELIMITER // -- Set the new statement ending character to "//" so that ";" is used in the stored procedure without ending the definition of the entire stored procedure. 
CREATE PROCEDURE CountAllTableRows()  -- Create a name calledCountAllTableRowsStored procedures。
BEGIN
    -- Variable declaration part
    DECLARE done INT DEFAULT FALSE;  -- Declare a namedoneinteger variables，Used to mark whether the cursor has been read or not，The initial value isFALSE。
    DECLARE tbl_name VARCHAR(255);    -- Declare a nametbl_namestring variable，Used to store the table name currently processed。
    DECLARE row_count INT DEFAULT 0;  -- Declare a namerow_countinteger variables，Used to temporarily store row count（But it was not used in this process）。
    
    -- Cursor declaration part
    DECLARE cur CURSOR FOR  -- Declare a namecurCursor。
        SELECT table_name   -- Cursor querySQLStatement，frominformation_schema.tablesSelect the table name。
        FROM information_schema.tables 
        WHERE table_schema = 'your_database_name'  -- Qualified query database name（Need to be replaced with the actual database name）。
          AND table_type = 'BASE TABLE';  -- Select only the basic table（Exclude views, etc.）。
 
    -- Continue to process the processor at the end of the cursor
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;  -- When the cursor cannot read the data，set updoneforTRUE。
 
    -- Temporary statement part
    CREATE TEMPORARY TABLE IF NOT EXISTS temp_row_counts (  -- Create a name calledtemp_row_countsTemporary table（If it does not exist）。
        table_name VARCHAR(255),  -- Storage table name。
        row_count BIGINT  -- Store row count，useBIGINTTo support large tables。
    );
 
    -- Open the cursor
    OPEN cur;
 
    -- Read loop
    read_loop: LOOP  -- 定义一个名forread_loopThe cycle of。
        FETCH cur INTO tbl_name;  -- from游标中读取一个表名到tbl_namevariable。
        IF done THEN  -- Determine whether the reading is completed。
            LEAVE read_loop;  -- If the reading is complete，Leave the loop。
        END IF;
 
        -- Get the number of rows in the current table
        SET @s = CONCAT('SELECT COUNT(*) INTO @cnt FROM ', tbl_name);  -- Splicing dynamicsSQLStatement。
        PREPARE stmt FROM @s;  -- Prepare for execution dynamicsSQLStatement。
        EXECUTE stmt;  -- Execution dynamicsSQLStatement，The result is stored in@cntvariable中。
        DEALLOCATE PREPARE stmt;  -- Release dynamicsSQLStatement。
 
        -- Insert row count into temporary table
        INSERT INTO temp_row_counts (table_name, row_count) VALUES (tbl_name, @cnt);  -- Insert table name and row number into temporary table。
    END LOOP;
 
    -- Close cursor
    CLOSE cur;
 
    -- from临时表中选择结果
    SELECT * FROM temp_row_counts;  -- Query and display all records in the temporary table。
 
    -- Delete temporary tables
    DROP TEMPORARY TABLE IF EXISTS temp_row_counts;  -- Delete temporary tables（If there is）。
END // -- The stored procedure definition ends. 
DELIMITER ;  -- 将Statement结束符重置for默认的";"。

CALL CountAllTableRows();