CREATE TABLE student ( sno varchar(255) NOT NULL, sname varchar(255) NULL, ssex varchar(255) NULL, sage int NULL, sdept varchar(255) NULL)INSERT INTO student VALUES ('s001', '张三', '男', '20', '会计')INSERT INTO student VALUES ('s002', '张四', '女', '18', '保险')INSERT INTO student VALUES ('s003', '王五', '男', '20', '金融')INSERT INTO student VALUES ('s004', '赵六', '女', '20', '会计')INSERT INTO student VALUES ('s005', '孙七', '女', '18', '会计')INSERT INTO student VALUES ('s006', '钱八', '男', '19', '保险')INSERT INTO student VALUES ('s007', '黄九', '男', '20', '金融')INSERT INTO student VALUES ('s008', '方十', '女', '21', '会计')SELECT column_name [,column_name] FROM table1 [,table2] WHERE column_name OPERATOR (SELECT column_name [,column_name] FROM table1 [, table2 ] [WHERE])
select * from student where sage in (select sage from student where sage<19)
INSERT INTO table_name [ (column1 [, column2 ]) ] SELECT [ *|column1 [, column2] FROM table1 [, table2 ] [ WHERE VALUE OPERATOR ]insert into student_bak select sno,sname,ssex,sage,sdept from student where ssex='男'
UPDATE table SET column_name = new_value [ WHERE OPERATOR [ VALUE ] (SELECT COLUMN_NAME FROM TABLE_NAME) [ WHERE) ]假设我们有一份 student_bak 表作为 student表的备份。
下面的示例将 student_bak 表中性别为‘男’且在金融部门的员工年龄增加1岁
语句：
update student_bak set sage=sage+1 where sno in(select sno from student where ssex='男'and sdept='金融')查询执行结果如下
DELETE FROM TABLE_NAME [ WHERE OPERATOR [ VALUE ] (SELECT COLUMN_NAME FROM TABLE_NAME) [ WHERE) ]假设我们有一份 student_bak 表作为 student表的备份。
下面的示例将 student_bak 表删除性别为‘男’且在金融部门的员工
语句：
delete from student_bak where sno in (select sno from student where ssex='男'and sdept='金融')查询执行结果如下：
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31537575/viewspace-3145035/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
从一无所知到5分钟快速了解HBase
下一篇：
性能测试、压力测试和负载测试
请登录后发表评论
登录
全部评论
