On 16 Mar 2016, at 8:43am, Bernard McNeill <bm.email01 at gmail.com> wrote:
> If it is required to import NULL values into an Sqlite table field, can > this be done simply by arranging that the before and after delimiters for > that field are consecutive? No. Use one of these two methods. CREATE TABLE t(a,b,c) It is required that column b contains NULL Method 1: INSERT INTO t (a, c) VALUES (1, 3) In this method you do not name column 'b' in the INSERT command. Therefore column b is set to NULL. Method 2: INSERT INTO t (a, b, c) VALUES (1, NULL, 3) In this method you name column b and put NULL into it. Simon.
