随笔分类 - 数据库
摘要:CREATE TABLE `student` ( `name` varchar(20) NOT NULL DEFAULT '', `age` int(10) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin11.测试一select * from student; a 5a 5c 0用distinct过滤掉两列都相同的记录select distinct name,age from student;返回a 5c 02.测试二将表student的数据改为如下:select * from student;c 2c 5se
阅读全文