tabela
CREATE TABLE USERS (
USR_ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
USR_TYPE_USRT_ID INTEGER UNSIGNED NOT NULL,
USR_Nick VARCHAR(15) UNIQUE NOT NULL,
USR_PASS VARCHAR(15) NOT NULL,
USR_CreateDate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
USR_LastModifyDate VARCHAR(11) NULL,
USR_LastLoginDate VARCHAR(11) NULL,
USR_LastFailedDate VARCHAR(11) NULL,
USR_WrongPassCount INTEGER UNSIGNED NULL,
USR_MustChanePassword INTEGER UNSIGNED NULL,
USR_ActiveByUser INTEGER UNSIGNED NULL,
USR_Active INTEGER UNSIGNED NULL,
PRIMARY KEY(USR_ID),
);
bez FOREIGN KEY(USR_TYPE_USRT_ID) REFERENCES USR_TYPE(USRT_ID)
zapytanie
INSERT INTO `sklep`.`users` (
`USR_ID` ,
`USR_Nick` ,
`USR_PASS` ,
`USR_CreateDate` ,
`USR_LastModifyDate` ,
`USR_LastLoginDate` ,
`USR_LastFailedDate` ,
`USR_WrongPassCount` ,
`USR_MustChanePassword` ,
`USR_ActiveByUser` ,
`USR_Active`
)
VALUES (
NULL , 'gienek', 'hassslo',
CURRENT_TIMESTAMP , '', NULL , NULL , NULL , NULL , NULL , NULL
);
wynik
nie wiem jak ty ale ja tam widzę w USR_CreateDate wartość '2010-12-12 1402'