随笔分类 -  SQL

摘要:Holedox EatingTime Limit: 4000/2000 MS (Java/Others)Memory Limit: 32768/32768 K (Java/Others)Total Submission(s): 2341Accepted Submission(s): 792Problem DescriptionHoledox is a small animal which can be considered as one point. It lives in a straight pipe whose length is L. Holedox can only move alo 阅读全文
posted @ 2013-05-23 19:09 剑不飞 阅读(262) 评论(0) 推荐(0)
摘要:create table dept(dname char(7),loc char(4),id number(7) primary key);//建表desc dept;//查找表所具有的属性alter table dept add ddate date;//修改table表 dept 增加名为当ddate属性为date的属性组select * from dept;//选择所有表元素alter table dept drop column ddate;//删除dept 中在ddate列insert into dept (dname,loc,ddate)values('12',&# 阅读全文
posted @ 2013-04-08 14:59 剑不飞 阅读(341) 评论(0) 推荐(0)