- 浏览: 2895 次
- 性别:
- 来自: 北京
最新评论
文章列表
select * from tab;
create table table_name (id varchar2(2) primary key, name varchar(10) not null, sex varchar2(1) default '0')
drop table table_name
select * from table_name where ... group by ... having ... order by ... limit ...
delete from table_name where ....
insert into table_name values ...
JSP3个标签
<%@ page language="java" import="java.util.*" pageEncoding="utf-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ include file="\/base.jsp" %>
JSP6个动作指令
<jsp:include page="path& ...
如果要对数据库中某一列数据进行分类。一般有3中写法:
(比如现在有张商品表protable,表中有3个字段商品序号id,商品名称name,商品价格price。需求是:price大于10的商品名称后面要加上B的后缀,price小于1的后面加上S的后缀,位于价格中间的加上M的后缀)
1 union all方法
select
*
from
(
select name||'S' newname from protable where price < 1
union all select name||'M' newname from protab ...