Re: find any row with NULL

Johan De Meersman <[email protected]>
Newsgroups gmane.comp.db.mysql.general
Message-ID <[email protected]>
----- Original Message -----
> From: "Sándor Halász" <[email protected]>
> Subject: Re: find any row with NULL
> 
> from information_schema.columns where (table_schema, table_name,

You could, but information_schema queries can get pretty slow on large databases, especially so with InnoDB. Recent versions support explain on those queries, too, I believe.

-- 
Unhappiness is discouraged and will be corrected with kitten pictures.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.