Forum Replies Created

Viewing 1 - 2 of 2 posts
  • Wong

    Member
    January 22, 2021 at 7:33 pm

    For SQL, we can extract all column names from information_schema. Then concatenate the column names with ‘IS NULL’ in where clause to get the number.

    SET @query = CONCAT(

    'SELECT COUNT(*) FROM sakila.staff WHERE CONCAT(',

    (SELECT GROUP_CONCAT(COLUMN_NAME)

    FROM information_schema.COLUMNS

    WHERE TABLE_SCHEMA = 'sakila' AND

    TABLE_NAME = 'staff'),

    ') IS NULL');

    PREPARE CHECK_NULL from @query;

    EXECUTE CHECK_NULL;

    • This reply was modified 3 years, 10 months ago by  Wong.
  • Wong

    Member
    October 25, 2020 at 9:34 pm
    Up
    0
    Down

    <div>The table name string can be found here:

    <h3>Entrepreneur Immigration</h3>\r\n\r\n<table align="center"

    </div>

    We can use ‘table align’ as key word to look for it.

Viewing 1 - 2 of 2 posts
error: Content is protected !!