Rumah > Artikel > pembangunan bahagian belakang > 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 全选按这个会自动排版了