List:MySQL++« Previous MessageNext Message »
From:Mike Naylor Date:May 30 2009 4: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
  • Re: ssqls and now()Warren Young30 May
    • Re: ssqls and now()Mike Naylor1 Jun
      • Re: ssqls and now()Warren Young1 Jun
        • Re: ssqls and now()Mike Naylor1 Jun
          • Re: ssqls and now()Warren Young1 Jun
            • Re: ssqls and now()Mike Naylor2 Jun
              • Re: ssqls and now()Mike Naylor2 Jun
              • Re: ssqls and now()Warren Young3 Jun
                • Re: ssqls and now()Mike Naylor3 Jun
                  • Re: ssqls and now()Warren Young3 Jun
                    • Re: ssqls and now()Mike Naylor1 Jul