mysqlÊÇÒÔ×Ô¶¯Ìá½»µÄģʽÔËÐеġ£
1¡¢ÊÂÎñµÄʹÓùرÕ×Ô¶¯Ìá½»¡£
set autocommit = 0;
2¡¢¿ªÊ¼ÊÂÎñ¡£
start transaction;
3¡¢Ìá½»Êý¾Ý
commit;
4¡¢ÊÂÎñ»Ø¹ö
rollback£»
ËæןüкÍɾ³ý²Ù×÷µÄ·¢Éú£¬Êý¾Ý½«»á±äµÃÖ§ÀëÆÆË飬ÐÞ¸´±íµÄmysqlÓï¾ä¡£
optimize table tablename »òÕß myisamchk -r table;
ÓëÊý¾Ý¿âµÄÁ´½Ó·½Ê½ÓÐÄÇЩ
mysql_connect(),mysqli_connect(), new mysqli(), odbc,mysql_pcontent()³¤Á¬½Ó
jdbc,adodb
´´½¨Ë÷Òý£º
1ÖÖ·½·¨ alter tableÔö¼ÓË÷Òý
alter table tableName add indexName(¡®×ֶΡ¯)£» ÆÕͨË÷Òý
alter table tableName add unique(¡®×ֶΡ¯)£» ΨһË÷Òý
alter table tableName add primary key(¡®×ֶΡ¯) Ö÷¼üË÷Òý
alter table tableName add fulltext(¡¯×ֶΡ¯) È«ÎÄË÷Òý
2ÖÖ·½·¨ create table tableName£¨£©;Óï¾äÖд´½¨Ë÷Òý
create table tableName(
primary key(id); //Ö÷¼üË÷Òý
index(username) //³£¹æË÷Òý
index(username,title,keywords) //¶à×ֶγ£¹æË÷Òý
fulltext( content ) //È«ÎÄË÷Òý
);
3ÖÖ·½·¨ create indexÓï¾ä±íÔö¼ÓË÷Òý
create index indexName on tableName(¡®×ֶΡ¯);
create unique index indexName on tableName(¡®×ֶΡ¯);
ɾ³ýË÷Òý2Öз½·¨£»
drop index indexName on tableName;
alter table tableName drop index indexName;
alter table tableName drop primary key;
ÒýÓô«µÝµÄÀí½â
ÎÒµÄÀí½âÊÇ£ºÒ»¸ö±äÁ¿¸³ÓèÁíÍâÒ»¸ö±äÁ¿µÄʱºòÇ°ÃæÓõ½&·ûºÅ£¬±íʾ°ÑÕâ¸ö±äÁ¿µÄÄÚ´æµØÖ·£¬´«µ½ÁíÍâ
Ò»¸ö²ÎÊýÖУ¬µ±ÐÞ¸ÄÕâ¸ö²ÎÊýʱ£¬±»´«µÝµÄ±äÁ¿ÖµÒ²·¢Ë͸ı䡣ÒýÓõĴ«µÝÏ൱ÓÚ¶Ôͬһ¸öµØÖ·½øÐÐÐ޸ġ£
ÃæÏò¶ÔÏóÖÐÓÐÄÇЩÄÚÖõķ½·¨¾ßÌåÓ÷¨¼òµ¥½éÉÜ:
__construct(); __destory(), __get(), __set(),__call(),__toString(),__class()£¬__clone;
¹¹Ô캯Êý£¬³õʼ»¯Öµ£¬ÏµÍ³×Ô¶¯ÔËÐУ»
Îö¹¹º¯Êý£¬ÔÚÔËÐнáÊøʱϵͳ×Ô¶¯µ÷ÓÃɾ³ý·ÏÆú±äÁ¿»òɾ³ýÒ»¸ö¶ÔÏó¡£
µ±±äÁ¿²»´æÔÚʱµ÷ÓÃ__get( $key );
Ϊ²»´æÔڵıäÁ¿¸³Öµµ÷ÓÃ__set($key, $value );
µ÷ÓÃÒ»¸ö¶ÔÏó²¢²»´æÔڵķ½·¨Ê±µ÷ÓÃ__call($method, array $args);
´òÓ¡Ò»¸ö¶ÔÏóµÄʱºò±»µ÷ÓÃ__toString();
µ±¶ÔÏñ±»¿Ë¡ʱµ÷ÓÃ__clone();
ÕýÔò±í´ïʽÖÐ×Ö·û¼¯ÓÐÄÇЩ£º
. »»ÐзûÒÔÍâµÄÈÎÒâÒ»¸ö×Ö·û
\w Æ¥ÅäÈκÎÒ»¸ö×Öĸ»òÕßÊý×Ö»òÕßÏ»®Ïß
\W Æ¥ÅäÒ»¸ö×Öĸ»òÕßÊý×Ö»òÕßÏ»®ÏßÒâÍâµÄ×Ö·û
\s Æ¥Åä¿Õ¸ñ£¬ÖƱí·û£¬»»Ò³·ûµÈ¿Õ°××Ö·ûµÄÆäÖÐÈÎÒâÒ»¸ö
\S ¿ÉÒÔÆ¥ÅäÈκÎÒ»¸ö¿Õ°××Ö·ûÒÔÍâµÄ×Ö·û
\d Æ¥Åä0-9Êý×Ö
\D Æ¥Åä·Ç×Ö·û
£¿{0,1}
+ {1,}
* {0,}
(),[],^,$
java scriptÖд´½¨Ò»¸ö¶ÔÏó£»
1£¬var object = new Object();
2, obejct = function(){}