PHP筆記，韓順平php筆記_PHP教程

PHP筆記，韓順平php筆記

Mysql
-----------------------------------------------------------------------------

Mysql 改預設密碼
update mysql.user set Password=PASSWORD('123456') WHERE User='root'
FLUSH PRIVILEGES

去瞭解下MYSQL的範式、反範式、混合範式
還有索引的建立
cmd命令列

全文索引
------------------------------
alter tabletable_reg_c addfulltext(catalog)

repair table tablename quick

select * from table_reg_c where match(`catalog`) against('2 in boolean mode')

select* fromtable_reg_c wherematch(`catalog`) against(2)

UPDATE`infinite_class`.`table_reg_c`SET`catalog`= '0,10000,20000,30000'WHERE`table_reg_c`.`id`= 3;

explainSELECT*FROM`table_reg_c`WHEREmatch(catalog)against('20000')

explain SELECT * FROM `table_reg_c` WHERE match(catalog) against('20000')

#Apache
------------------------------------------------------------------------------
Apache\bin\ApacheMonitor.exe

#mysqld

----------------------------------------------------
mysqld install 安裝
net start mysql 啟動服務

zend 代碼風格
----------------------------------------------------------------
formatter ｛｝

ctrl+shift+f 全選按這個會自動排版了

http://www.bkjia.com/PHPjc/1049392.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/1049392.htmlTechArticlePHP筆記，韓順平php筆記 Mysql ----------------------------------------------------------------------------- Mysql 改預設密碼 update mysql.user set Password=PASSWORD('12...

