nNCfKmkA

1begin;
2update t_info set gender=1 where c_score > 85;
3	
4begin;
5insert into t_info(c_id,c_class_no,c_score,c_name,gender) values (4,99,50,'gap',1);
6	
7DROP TABLE IF EXISTS `t_info`;
8CREATE TABLE `t_info` (
9  `c_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
10  `c_class_no` int(11) NOT NULL DEFAULT '-1',
11  `c_score` int(11) NOT NULL DEFAULT '0',
12  `c_name` varchar(25) NOT NULL,
13  `gender` tinyint(4) NOT NULL COMMENT '0 male, 1 female',
14  PRIMARY KEY (`c_id`),
15  KEY `idx_name_score` (`c_name`,`c_score`),
16  KEY `idx_score` (`c_score`)
17) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
18
19INSERT INTO `t_info` 
20VALUES 
21(1,1,60,'no1',0),
22(2,2,60,'no2',0),
23(3,3,60,'no3',0),
24(6,4,78,'gap',1),
25(7,5,95,'no5',0),
26(10,8,87,'jianhaiqing',0),
27(11,36,20,'no20',0),
28(14,13,100,'no13',0),
29(20,21,120,'no21',0),
30(21,24,83,'no87-2',0);