ÎÒÔÚ×öÒ»¸ö¹¤³Ì£¬ÀïÃæµÄactionÅäÖö¼Ã»ÓÐresult£¨ÈçÏ£©,ÔÚBlogIndexActionÖзµ»ØÖµÓС°index¡±¡¢¡°blogmain¡±µÈµÈ
<struts>
<package name="index" extends="default" namespace="/">
<action name="blog" class="com.teacherclub.busine ......
MYSQL Õâ¸ö´íÎóÔõô½â¾ö°¡¡£¡£ÇóÖú
Õâ¸ö´íÎó¸ãÎÒµÄDZ̳ÂÛ´ò²»¿ªÇÒIISµ¼³£Ò²²»ÖªÊDz»ÊÇÒòΪËûÒýÆðµÄ
ʼþÀàÐÍ: ´íÎó
ʼþÀ´Ô´: MySQL
ʼþÖÖÀà: ÎÞ
ʼþ ID: 100
ÈÕÆÚ: &nbs ......
mysqlÖв»ÔÊÐíÔÚÓï¾äÖУ¬ÏÈÖ´Ðб¾±íµÄselect£¬È»ºóÔÙdeleteµÄ²Ù×÷£¬¾ÍÊÇÕâ¸öÒâ˼°É
DELETE from quanxian WHERE uid IN (
SELECT r.uid
from `username` AS u, quanxian AS r
WHERE u.system_id = r.uid
AND u.state !=1
)
±¨´íÈçÏÂ
#1093 - You can't specify target table & ......
±íÖÐÓÐDATE»òTIMESTAMP×Ö¶Î,ÎÒÏë°´ÕÕ¸Ã×Ö¶ÎÿÖÜÒ»¸ö·ÖÇø¡£ÈçºÎ×öµ½£¿
SQL code:
mysql> CREATE TABLE netxuning (
-> id INT NOT NULL,
-> mydate DATE
-> )
-> PARTITION BY RANGE (YEARWEEK(mydate)) (
-> PARTITION p0 VALUES LESS THAN (200901),
-> ......
ÎÊÌâÃèÊö£º
Êý¾Ý¿âÖдæµÄÖÐÎÄÈ«²¿¶¼ÂÒÂ룬µ«ÊǶÁȡ֮ºóÔÚÒ³ÃæÖ®ºóÏÔʾµÄȴûÓÐÎÊÌ⣡
ÇëÎÊÕâÊÇÄÄÀï³öÁËÎÊÌ⣡£¿
set names 'gbk' »òÕßÄãµÄ×Ö·û¼¯¡£
°´ÕÕÏÂÌùÖеķ½·¨¼ì²éһϣ¬»òÕßÌṩÄãµÄ show create table , show variables
http://blog. ......
ÓÃDTS½«sql2000µÄÊý¾Ýµ¼Èëµ½MySQLÖУ¬mysqlµÄODBCÇý¶¯ÊÇ 3.51µÄ°æ±¾£¬½á¹ûµ¼½øMySQLµÄ±íÃûÈ«ÊÇÂÒÂ룬
MySQLµÄÊý¾Ý¿â×Ö·û¸ñʽÊÇutf-8µÄ£¬mysql°æ±¾ÊÇ5.0µÄ£¬ÌýÍøÉÏ˵Óà MySQL ODBC 5.1µÄÇý¶¯°æ±¾¾Í²»»á³öÏÖÂÒÂ룬½á¹ûÎÒ×°ÉÏÖ®ºóÁ¬»ù±¾µÄÊý¾ÝÔ´¶¼´´½¨²»³É¹¦£¬Ã¿´Î¶¼Êǵã»÷OKºó£¬ËÀ»ú£¬Ã»·´Ó¦À²¡£
¸÷λ´óÏ ......