幫忙解釋一下以下查詢和刪除語句:

[liaojiqiang]

幫忙解釋一下以下查詢和刪除語句:
exec=”select * from guestbook where name=”’+name+”’ and tel=”+tel

exec=”delete * from guestbook where 編號=”&request.form(“ID”)


另外有一個問題,為什麼這些引號不是對稱的,能不能幫忙解釋一下這些引號的涵義

[pp4u]

"select * from guestbook where name='" + name + "' and tel=" + tel

"delete from guestbook where 編號=" & request.form("ID")

[liaojiqiang]

按照對稱性,為什麼不是這樣呢?
"select * from guestbook where name=' "+ name +"' and tel= '" + tel"' "

"delete from guestbook where 編號=' & request.form("ID")' "

[ttt2]

字符型需要 "'"

数字型不需要 "'"

[ryuginka]

exec=”select * from guestbook where name='”+name+”' and tel=”+tel

exec=”delete * from guestbook where 編號=”&request.form(“ID”)