在线管理数据库 类(16)
'ManDb.DelIndex "cexo255", "UserID" '删除表索引(表名,索引名)_
'ManDb.AddPRIMARYKEY "cexo255","id" '建立表主键(表名,主键字段名)
'ManDb.DelPRIMARYKEY "cexo255","id" '删除表主键(表名,主键字段名)_
'Response.Write ManDb.GetPrimaryKey("cexo255") '取表的主键(表名)
'ManDb.upColumn "cexo255","id","12345","id = '12'" '修改字段的值
'ManDb.Execute "insert空格into cexo255(id) values ('789')" '添加记录
'ManDb.Execute "Update cexo255 Set id = 'wxf' Where id = '789'" '修改记录
'ManDb.Execute "delete空格From cexo255 Where id = 'wxf'" '删除记录
ManDb.Execute("Select Count(*) From cexo255"):Response.Write ManDb.Count '统计记录个数
'If ManDb.CheckTable("StudInfo") THen Response.Write "StudInfo表存在!!!" Else Response.Write "StudInfo表不存在!!!"
'//-----------End--------------------------
Set ManDb = Nothing
%>
内容版权声明:除非注明,否则皆为本站原创文章。