List:General Discussion« Previous MessageNext Message »
From:Martijn Engler Date:April 28 2009 9:37pm
Subject:Re: Now() : SQL syntax error. But why?
View as plain text  
Can you please give the full table structure and query?

On Tue, Apr 28, 2009 at 23:18, Antonio PHP <php.antonio@stripped> wrote:
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'Created = NOW(),
> Updated = NOW()' at line 8
>
> 'Created' and 'Updated' are set to datetime (InnoDB).
>
> The same syntax works for some newly created tables... and gives no error.
>
> It's very strange. 'Now()' works for some tables, and it doesn't for some.
> (All set in phpmyadmin...)
>
> What could have caused this? Any similar experience?
>
> Please help~.
>
Thread
Now() : SQL syntax error. But why?Antonio PHP28 Apr
  • Re: Now() : SQL syntax error. But why?Martijn Engler28 Apr
  • Re: Now() : SQL syntax error. But why?Scott Haneda29 Apr
    • Re: Now() : SQL syntax error. But why?Antonio PHP29 Apr
      • Re: Now() : SQL syntax error. But why?Scott Haneda30 Apr
        • Re: Now() : SQL syntax error. But why?Antonio PHP1 May
          • Re: Now() : SQL syntax error. But why?Scott Haneda1 May