Select Null,null,null,null,null,null,null,null-- Jynz | {keyword}' Union All

If the column count is wrong (e.g., the original query has 7 or 9 columns), the database will return an error.

NULL is used because it is compatible with almost any data type (string, integer, date, etc.), ensuring the query won't fail due to data type mismatches. If the column count is wrong (e

: Appends a new set of results to the original query's output. If the column count is wrong (e

2 COMMENTS :

  1. By Sarah E Mizen-Reese on

    Whoa! Exactly what we needed for our planning meeting!! Thank you for making this helpful reference!!

    Reply

Add a comment: