Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW()

[Michael Orlitzky]

On 12/28/2012 01:44 AM, Joseph wrote:
> I'm not a PHP programmer but I'll try to explain my problem.
> I've create table in my php database:
>
> DROP TABLE IF EXISTS visual_verify_code;
> CREATE TABLE visual_verify_code (
>    oscsid varchar(32) NOT NULL,
>    code varchar(6) NOT NULL,
>    dt TIMESTAMP(12) NOT NULL DEFAULT NOW(),
>    PRIMARY KEY (oscsid)
> );
>

Looks fine.


> It worked OK, after few days I backup my database and try to restore it, but it keeps complaining on the "dt":
> ERROR 1067 (42000) at line 38009: Invalid default value for 'dt'
>
> so the database is dropped but never restored. The backup data base contain:
>
> create table visual_verify_code (
>    oscsid varchar(32) not null ,
>    code varchar(6) not null ,
>    dt timestamp default 'CURRENT_TIMESTAMP' not null ,
>    PRIMARY KEY (oscsid)
> );


CURRENT_TIMESTAMP shouldn't be quoted. How are you backing up the database?