On Donnerstag, 20. September 2012 15:16:29, 叶艳红 wrote:
> insert into history (mdwkup,macdup,mdate,mdwkmd) SELECT
> (select count(*) FROM fxj where mdwkup=1),
> (select CURDATE()),
> (select round(avg(mdwkmd),2) from fxj) where datetime('now',
> 'localtime')>15:00
>
> The sql command could not run
Seems like you're missing the value for the second column to insert
(macdup)...
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
