摘要:
记录聚合调试相关
数据准备:
数据库准备:
create database test;
表结构准备:
CREATE TABLE IF NOT EXISTS `runoob_tb4`(
`runoob_id` INT AUTO_INCREMENT,
`runoob_title` VARCHAR(100) NOT NULL,
`runoob_author` VARCHAR(40) NOT NULL,
`submission_date` DATE,
PRIMARY KEY ( `runoob_id` )
)ENGINE=TIANMU;
插入数据:
INSERT INTO runoob_tb4
(runoob_title, runoob_author, submission_date)
VALUES
("LEARN-15", "STUDY-151", NOW());
聚合查询:
select runoob_id,