ɾ³ýoracle±í¼Ç¼£¬²åÈëºÃÏñ³ö´í£¬ÎÒÕâ¾ä´íÔÚÄÇÀ

SQL code:

INSERT INTO user.userl(uin,cn,passwd_md5,regip,usertype,regdate,userfrom,enabled,OTHER_EMAIL,QUESTION,ANSWER_MD5,NICKNAME,SN)VALUES(user.userl.NEXTVAL,'"&UserNamea&"','"&password&"','"&ip&"',0,SYSDATE,'china','Y','"&email&"','"&quest&"','"&anster&"','"&name&"','"&num&"')"


ÉÏÃæÊÇÎÒ²åÈëµ½±íÀïµÄ¼Ç¼µÄÓï¾ä
ÏÖÔÚÎÒÏëɾ³ý±íÀïËùÒԼǼ£¬µ«ÊDz»Ó°ÏìÒÔºó²åÈ룡

ÎÒʹÓà
SQL code:
delete from userl


²åÈëºÃÏñ³ö´í£¡¾Í¸Ð¾õuserl±í²»ÄÜÕý³£¹¤×÷ÁË£¬ÇëÎÊ´íÔÚÄÇÀ

---

ÒýÓÃ

SQL codeINSERTINTOuser.userl(uin,cn,passwd_md5,regip,usertype,regdate,userfrom,enabled,OTHER_EMAIL,QUESTION,ANSWER_MD5,NICKNAME,SN)VALUES(user.userl.NEXTVAL,'"&UserNamea&"','"&password&"','"&ip&"',0,SYSDATE,'china','Y','"&email&"','"&quest&"','"&anster&"','"&name&"','"&num&"')"

ÉÏÃæÊÇÎÒ²åÈëµ½±íÀïµÄ¼Ç¼