摘要: 数据分组:select column_name count(*) as new_name from table_name group by column_name 分组语法 having count(*)>= 100; 筛选组别语法 输入▼ SELECT vend_id, COUNT(*) AS n 阅读全文
posted @ 2020-05-18 14:50 摘苹果 阅读(119) 评论(0) 推荐(0) 编辑
摘要: 修改表列名:alter table table_name change column old_column_name new_column_name the_type_of_date ; sql聚集函数:select avg(`column_name`) as avg_column_name fro 阅读全文
posted @ 2020-05-18 14:23 摘苹果 阅读(178) 评论(1) 推荐(0) 编辑