--创建视图 DROP VIEW IF EXISTS t_test ; CREATE VIEW t_test AS SELECT t.ID ID , from t_test1 t GROUP BY t.id