insert into 表名 (列名1,列名2.....)values (值1,值2......)
delete from 表名 where 条件
update 表名 set 列名1=表达式1,[列名2=表达式2.......]
select 目标列 from 表或视图名 in 数据库 where 条件
一个查询数据库例子:
<%Set rs= Server.CreateObject("ADODB.Recordset")
sql="select * from wysj order by id desc "
rs.open sql,conn,1,1
if rs.eof and rs.bof then
读出内容
end if%>
一个修改数据库例子:
<%Set rs= Server.CreateObject("ADODB.Recordset")
sql="select * from wysj where id=1"
rs.open sql,conn
if rs.eof and rs.bof then
rs("pic")=pic
rs.update
end if%>
一个插入数据的例子:
<%Set rs= Server.CreateObject("ADODB.Recordset")
sql="select * from wysj"
rs.open sql,conn
if rs.eof and rs.bof then
rs.addnew
rs("pic")=pic
rs.update
end if%>
set conn=server.createobject("adodb.connection")
'add
sql="insert into tableadd(id) values('001')"
conn.execute sql
'modi
sql="update tablemodi set id='001'"
conn.execute sql
'del
sql="delete from tablemodi where id='001'"
conn.execute sql