表中有个字段utc,有个空字段date,现在想把utc转化为年月日的格式并插入相应的date字段
alter table data412044770 add date varchar(32) DEFAULT NULL;
INSERT INTO data412044770 (date) SELECT (SELECT FROM_UNIXTIME(utc, '%Y年%m月%d')from data412044770 );
执行后发现错误
[SQL]INSERT INTO data412044770 (date) SELECT (SELECT FROM_UNIXTIME(utc, '%Y年%m月%d')from data412044770 );
[Err] 1242 - Subquery returns more than 1 row