List:MySQL++« Previous MessageNext Message »
From:Mike Naylor Date:May 30 2009 6:55pm
Subject:ssqls and now()
View as plain text  
For example...

create table stock (
    id int auto_increment,
    updated timestamp default current_timestamp
);

stock.id = 0; // as expected, id is interted with the next auto  
increment value.
stock.updated = <some kind of null value>; // some way of causing  
current_timestamp to be inserted

I've tried various combinations of mysqlpp:DateTime::now(), but  
without success, so I'd be very grateful to anyone who can tell me me  
the correct syntax.

Mike.

Thread
ssqls and now()Mike Naylor30 May 2009
  • Re: ssqls and now()Warren Young30 May 2009
    • Re: ssqls and now()Mike Naylor1 Jun 2009
      • Re: ssqls and now()Warren Young1 Jun 2009
        • Re: ssqls and now()Mike Naylor1 Jun 2009
          • Re: ssqls and now()Warren Young1 Jun 2009
            • Re: ssqls and now()Mike Naylor2 Jun 2009
              • Re: ssqls and now()Mike Naylor2 Jun 2009
              • Re: ssqls and now()Warren Young3 Jun 2009
                • Re: ssqls and now()Mike Naylor3 Jun 2009
                  • Re: ssqls and now()Warren Young3 Jun 2009
                    • Re: ssqls and now()Mike Naylor1 Jul 2009