MySQL中每个派生表都要有自己的别名（Every derived table must have its own alias）解决

1.今天操作测试数据库的时候报了个错 “Every derived table must have its own alias”
搜索字段为

UPDATE sku SET updatetime=now(),groupid = (SELECT groupid FROM (SELECT MAX(groupid) AS groupid FROM sku) )+1 WHERE skuid  in ('');

2.告诉我们派生表都要有自己的别名，然后我们都知道"派生表"就是由搜索数据库表得出来的临时表
即由：SELECT MAX(groupid) AS groupid FROM sku，这一句得出来的临时表要起别名

3.那就稍微修改一下,添加个 AS s 得

UPDATE sku SET updatetime=now(),groupid = (SELECT s.groupid FROM (SELECT MAX(groupid) AS groupid FROM sku)  AS s)+1 WHERE skuid  in ('');

4.添加以后执行就没问题了，以防自己忘记记录一下，顺便帮帮有需要的同学复习