use Perl

• one problem I do not need to worry about (Score:1)

  by link (3402)

  Now that I use mysql at $work these mysql behaviour s worry me a lot more but at least this is one mysqlism I'm not likely to fall into. I do not expect to be counting nulls in a not null table.
  • Re: (Score:1)

    by Adrian (66)

    We had some generic SQL that applied to several tables in similar ways.

    ... and goddamn it - it's just wrong to say a table is null and not null at the same time :-)
    • Re:one problem I do not need to worry about (Score:1)

      by link (3402) on 2007.03.12 10:41 (#53667) Homepage Journal

      Now that I work with mysql I plan to read
      http://sql-info.de/mysql/gotchas.html [sql-info.de] properly at some stage.
      
      At least this feature is documented in the mysql
      docs (but who ever reads the docs)
      
      "For DATE and DATETIME columns that are declared as NOT NULL, you can find the special date '0000-00-00' by using a statement like this:
      
      SELECT * FROM tbl_name WHERE date_column IS NULL
      
      This is needed to get some ODBC applications to work because ODBC does not support a '0000-00-00' date value."

      Reply to This

      Parent