Mysql ±í½á¹¹
MYSQLÖÐÐ޸ıí½á¹¹ALTERÓ÷¨
ALTER TABLE Result ADD xinlinDoc longblob;
ALTER TABLE Result ADD xinlinDocName varchar(50);
ÆäËüʵÀý£º
CREATE TABLE t1(a INTEGER,b CHAR(10)); // ´´½¨µÄ±ít1¿ªÊ¼
ALTER TABLE t1 RENAME t2; // ÖØÃüÃû±í£¬´Ót1µ½t2
ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20); // ΪÁ˸ıäÁÐa£¬´ÓINTEGER¸ÄΪTINYINT NOT NULL(Ãû×ÖÒ»Ñù)£¬²¢ÇҸıäÁÐb£¬´ÓCHAR(10)¸ÄΪCHAR(20)£¬Í¬Ê±ÖØÃüÃûËü£¬´Ób¸ÄΪc£º
ALTER TABLE t2 ADD d TIMESTAMP; // Ôö¼ÓÒ»¸öÐÂTIMESTAMPÁУ¬ÃûΪd
ALTER TABLE t2 ADD INDEX (d), ADD PRIMARY KEY (a); // ÔÚÁÐdÉÏÔö¼ÓÒ»¸öË÷Òý£¬²¢ÇÒʹÁÐaΪÖ÷¼ü
ALTER TABLE t2 DROP COLUMN c; // ɾ³öÁÐc
ALTER TABLE t2 ADD c INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD INDEX (c); // Ôö¼ÓÒ»¸öеÄAUTO_INCREMENTÕûÊýÁУ¬ÃüÃûΪc¡£×¢Ò⣬ÎÒÃÇË÷ÒýÁËc£¬ÒòΪAUTO_INCREMENTÖù±ØÐë±»Ë÷Òý£¬²¢ÇÒÁíÍâÎÒÃÇÉùÃ÷cΪNOT NULL£¬ÒòΪË÷ÒýÁ˵ÄÁв»ÄÜÊÇNULL¡£µ±ÄãÔö¼ÓÒ»¸öAUTO_INCREMENTÁÐʱ£¬×Ô¶¯µØÓÃ˳ÐòÊý×ÖÌîÈëÁÐÖµ¡£
Ïà¹ØÎĵµ£º
1 1 Linux Red Hat 7.2 °²×°
¡¡¡¡Red Hat Linux 7.2µÄ°²×°¹âÅ̹²ÓÐÁ½ÕÅ£ºµÚÒ»ÕÅ¿ÉÒÔÖ±½Ó´Ó¹âÅÌÆô¶¯£¬°üº¬Á˴󲿷ֵÄÈí¼þ°üºÍһЩ°²×°¹¤¾ß£»µÚ¶þÕŹâÅ̳ýÁ˸½¼ÓµÄÈí¼þ°üÍ⣬Ö÷ÒªÊÇÔ´Âë¡¢Ô¤ÀÀ°æÈí¼þµÈ¡£
¡¡¡¡Red Hat Linux 7.2µÄ°²×°½çÃæ·Ç³£ÓѺã¬×óÃæÓм´Ê±Ï꾡µÄ°ïÖúÐÅÏ¢£¬ÓÒÃæÊÇÑ¡ÏÍêȫ֧³ÖÊó±ê²Ù×÷¡£
¡¡¡¡½« ......
1¡¢mysql_connect()-½¨Á¢Êý¾Ý¿âÁ¬½Ó {3RY4HVT?
¸ñʽ£º Fv n:V\eb
resource mysql_connect([string hostname [:port] [:/path/to/socket] [, string username] [, string password]]) _I;+p eq
Àý£º 1(V>8}zn
$conn = @mysql_connect("localhost", "username", "password") or dir(" ......
Õ⼸Ìì°²×°ÁËһ̨linux·þÎñÆ÷¡£±¾À´Ò»Î»Í¦¼òµ¥¸öÊ£¬Ã»Ïëµ½ÕÛÌÚÁ˺ü¸Ìì¡£
Ê×ÏÈÊÇ °²×° AS4.4
·þÎñÆ÷ÊÇÁªÏë R520 G6£¬±¾ÒÔΪŪ¸öаæµÄunbuntu¾ÍÄÜÇý¶¯ÆðÀ´£¬Ã»Ïëµ½ÉÏÀ´¾ÍÓöµ½ÁËÂé·³¡£Ð°æµÄlinux»¹ÊÇû°ì·¨Çý¶¯ÆðÀ´£¬ÁªÏëËæ»ú¸øµÄÇý¶¯×î¸ß¾Íµ½AS4.4£¬Ã»°ì·¨Ö»ºÃÕÒÕÒAS4.4 °²×°ÁË¡£
Ê×ÏȹâÅÌÆô¶¯ ÊäÈë linux dd&nb ......
TomCat6.0Êý¾Ý¿âÁ¬½Ó³ØÅäÖÃʵÀý(mysqlÊý¾Ý¿â)
TomCat6.0Êý¾Ý¿âÁ¬½Ó³ØÅäÖÃÓм¸ÖÖ·½Ê½£¬ÔÚÕâÀïÎÒÖ»½éÉÜÆäÖеÄÒ»ÖÖ¹©´ó¼Ò²Î¿¼£º
ÏÂÃæÎÒ°ÑÅäÖùý³Ì·Ö³ÉÈý¸ö²½ÖèÀ´Íê³É£º
µÚÒ»²½£ºÔÚÄã°²×°TomCatµÄĿ¼ÏÂÕÒµ½context.xmlÅäÖÃÎļþ¡££¨ÀýÈ磺D:\Tomcat 6.0\conf\context.xml£©È»ºó´ò¿ªcontext.xml£¬ÔÚ±êÇ©<context>< ......
select id from message where author_id in (select followed_id from Relation where follower_id=1) order by id desc ºÍ ·Ö±ðÖ´ÐÐ $userlist = select followed_id from Relation where follower_id=1 ÔÙ select id from message where author_id in ($userlist) order by id desc ¾¹È»ÓÐÁ½¸öÊýÁ ......