Obtain _not null_ and with no _default value_ fields of a table (useful when you need an _INSERT_ test statement of a big table)

get_not_null_and_no_default_fields.sql

SELECT 
    COLUMN_NAME AS `Field`
FROM
    information_schema.COLUMNS
WHERE
    TABLE_SCHEMA = 'schemaName'
        AND TABLE_NAME = 'tableName'
        AND IS_NULLABLE = 'NO'
        AND (COLUMN_DEFAULT IS NULL
        OR COLUMN_DEFAULT = '')
LIMIT 200;