[thelist] [MySQL] date_add

[Paul Bennett]

> 3.23.53??  Uh, because you haven't sacrificed a chicken to placate the
restless spirits of the undead? That's WAG #1.  :-)

So I should be running mysql with the '-chicken' flag? :)
Yea, we've requested an upgrade - unfortunately we're on a shared server for at least a few more months until the powers that be get containerisation working so we can run whatever we like...

> WAG #2 -- are your sure StartDate is a date or datetime, not a
> timestamp?

StartDate is a datetime with the default 'all zeroes' value. Initially I thought I'd need to switch it to a date type, but I don't think that will make a difference. Not according to the docs anyway...


>..on the table? And can you show the CREATE TABLE for 'petition'?

Sure thing:
-------------------------------------------
CREATE TABLE `petition` (
  `id` int(11) NOT NULL auto_increment,
  `FirstName` varchar(100) NOT NULL default '',
  `LastName` varchar(100) NOT NULL default '',
  `StreetAddress` varchar(100) NOT NULL default '',
  `Suburb` varchar(100) NOT NULL default '',
  `City` varchar(100) NOT NULL default '',
  `Phone` varchar(100) NOT NULL default '',
  `Email` varchar(100) NOT NULL default '',
  `Representing` enum('individual','organisation') NOT NULL default 'individual',
  `OrganisationName` varchar(200) NOT NULL default '',
  `Title` varchar(200) NOT NULL default '',
  `Subject` text NOT NULL,
  `BackgroundInformation` text NOT NULL,
  `StartDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `Duration` tinyint(4) NOT NULL default '0',
  `Status` tinyint(4) NOT NULL default '0',
  `StatusComments` mediumtext NOT NULL,
  `PresentedTo` enum('Council','Performance Review Committee','Regulatory Processes Committee') default NULL,
  `PresentedDate` datetime default NULL,
  `PresentedResponse` mediumtext,
  `declineComments` mediumtext NOT NULL,
  `Verified` enum('y','n') NOT NULL default 'n',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;