| 语句可以向表添加多行数据。这些多行数据是从已经存有这些数据的另一个表中选取的。本例中，向 pubhold 表中添加有关在加利福尼亚和德克萨斯州的出版商的数据。这些数据可从 publishers 表中获得。
INSERT pubhpold SELECT * FROM publishers
WHERE state = ''''CA'''' OR state = ''''TX''''
4，删除：
4.1，Delete语句联合删除：
DELETE FROM uu_SuiteToMinClassroomSect
WHERE min_classroom_sect_id IN
(SELECT min_classroom_sect_id
FROM uu_MinClassroomSect
WHERE min_classroom_id = ''''112'''')
二、视图使用细则
1，一个典型的视图
CREATE VIEW View_uuGroupTaxis
AS
SELECT uu_GroupInfo.group_id, uu_GroupInfo.group_name,
uu_GroupType.main_type, uu_GroupType.group_type_name,
uu_GroupInfo.group_icon_url, ISNULL
((SELECT COUNT(*)
FROM uu_GroupUser
WHERE uu_GroupInfo.group_id = uu_GroupUser.group_id), 0)
* 50 + ISNULL(uu_GroupInfo.fundCount, 0) + ISNULL
((SELECT COUNT(*)
FROM Dv_Topic
WHERE Dv_Topic.BoardID = uu_GroupInfo.subforum_id), 0) * 5 + ISNULL
((SELECT COUNT(*)
FROM uu_GroupPhotos
WHERE uu_GroupPhotos.group_id = uu_GroupInfo.group_id), 0)
* 10 + ISNULL(uu_GroupInfo.topic_account, 0)
* 2 + ISNULL(uu_GroupInfo.hit_account, 0) AS group_ActiveDegree,
ISNULL
((SELECT COUNT(*)
FROM uu_GroupUser
WHERE uu_GroupInfo.group_id = uu_GroupUser.group_id), 0)
&n 上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] 下一页 | 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 