随笔分类 -  数据库

摘要: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 阅读全文
posted @ 2012-07-05 09:39 jia58960 阅读(8657) 评论(0) 推荐(0)