SQL
共 11 篇文章
SQL整理十一
学生信息表:studentinfo +----+---------+-------+ |name kecheng fenshu |张三 语文 81 |张三 数学 75 |李四 语文 76 |李四 数学 90 |王五 语文 81 |王五 数学 100 |王五 英语 90 +----+---------+-------+ SQL: +-----------------------------------------------------+ DROP TABLE IF EXISTS `studentinfo`; CREATE TABLE `studentinfo` ( `Id` int(11) …
2009-07-07 15:26 · SQL
SQL整理十
项目表:project 合同表:hetong 收款表:inmoney SQL: +---------------------------------------------------------------------------------+ create table project(id varchar(10),name varchar(10)); create table hetong(id varchar(10),projectid varchar(10),hetongkuan varchar(10)); create table inmoney(id varchar(10),he…
2009-07-07 15:14 · SQL
SQL整理九
+---------------------------------------------------------------------------------------+ 球队信息表:tb_team CREATE TABLE IF NOT EXISTS `tb_team` ( `team_id` int(11) NOT NULL auto_increment COMMENT 'KEY', `team_name` varchar(50) NOT NULL COMMENT '球队名称', `team_coach` varchar(20) default NULL COMMENT '教练'…
2009-07-07 08:30 · SQL
SQL整理八
结构表:TabTest +-------+--------+ |t_Code t_Name | | 1 a | | 2 b | | 11 c | +-------+--------+ SQL: +-----------------------------------------------------------+ Create table TabTest(t_Code varchar(10),t_Name varchar(10)); insert into TabTest values('1','a'); insert into TabTest values('2','b'); inser…
2009-07-06 15:46 · SQL
SQL整理七
图书信息表:books +------+---------+ bookid bookname | | 1 a | | 2 b | | 3 v | | 4 d | | 5 f | | 6 g | | 7 h | | 8 j | | 9 k | | 10 l | | 11 r | | 12 t | +------+---------+ SQL: +-----------------------------------------+ DROP TABLE IF EXISTS `books`; CREATE TABLE `books` ( `bookid` int(11) NOT NULL defa…
2009-07-06 15:11 · SQL
SQL整理六
员工业绩表:inwork +----+------------+----------+------------+ | id sname smoney sprovice +----+------------+----------+------------+ | 1 zhangsan 2098 A +----+------------+----------+------------+ | 2 lishi 3000 B +----+------------+----------+------------+ | 3 wangwu 6789 C +----+------------+---------…
2009-07-06 11:12 · SQL
SQL整理五
学生信息表:tab1 +------+--------+-----+ |name class score +------+--------+-----+ | 张三 法学02班 59 +------+--------+-----+ | 李四 公商00班 69 +------+--------+-----+ | 王五 法学02班 95 +------+--------+-----+ | 马六 公商00班 65 +------+--------+-----+ | 阿一 法学02班 88 +------+--------+-----+ | 阿洒 公商00班 66 +------+--------+-…
2009-07-04 11:37 · SQL
SQL整理四
学生表:xstudent +-------+------+------+----------+-------+ |(学生ID) (名字) (性别) (生日) (班级) +-------+------+------+----------+-------+ |xsid xsnm xssex xsbirthday sclass +-------+------+------+----------+-------+ |108 曾华 男 09/01/77 95033 +-------+------+------+----------+-------+ |105 匡明 男 10/02/75 95031 +…
2009-07-04 11:13 · SQL
SQL整理三
产品信息表:product +--+-----+-------+------+ |id| name| p_name| p_num| +--+-----+-------+------+ |1 | A | 商品甲 | 2 | +--+-----+-------+------+ |2 | B | 商品乙 | 4 | +--+-----+-------+------+ |3 | C | 商品丙 | 1 | +--+-----+-------+------+ |4 | A | 商品丁 | 2 | +--+-----+-------+------+ |5 | B | 商品丙 | 5 | +--+----…
2009-07-04 08:42 · SQL
SQL整理二
显示下表年度为季度,算出总计 表income +----+------+---------+-----------+ | id | year | quarter | amount | +----+------+---------+-----------+ | 1 | 2004 | 1 | 2328.00 | | 2 | 2004 | 2 | 3822.00 | | 3 | 2004 | 3 | 7071.00 | | 4 | 2004 | 4 | 8931.00 | | 5 | 2005 | 1 | 2633.00 | | 6 | 2005 | 2 | 3910.00 | | 7 | 200…
2009-07-03 21:05 · SQL
SQL整理一
部门信息:dept +------+-----------+------------+ |deptno| deptname |deptlocation| +------+-----------+------------+ | 1 |designing | workin121 | +------+-----------+------------+ | 2 | coding | workin123 | +------+-----------+------------+ | 3 | testing | workin125 | +------+-----------+------------+ | …
2009-07-03 17:22 · SQL