> I resolved with:
>CREATE TRIGGER insert_nameTable after insert on
>name_tabl begin
>update eeeeeeeeeeee set wwwwww = datetime('now','localtime')
>where rowid = new.rowid; end"
You don't have to fire a trigger for such default:
CREATE TABLE "test" (
"mydate" CHAR DEFAULT (datetime('now','localtime')),
"data" CHAR);
insert into test (data) values ('abc');
>What is the difference between "sqlite3.version" (typed on command
>line) and "SELECT
>sqlite_version()" because one gives a value like 2.4.1 and the other gives
>as the value 3.5.9 ?
An outdated command-line utility?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
