首页 >后端开发 >php教程 >PHP笔记,韩顺平php笔记_PHP教程

PHP笔记,韩顺平php笔记_PHP教程

WBOY
WBOY原创
2016-07-13 09:44:13859浏览

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 全选按这个会自动排版了

 

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/1049392.htmlTechArticlePHP笔记,韩顺平php笔记 Mysql ----------------------------------------------------------------------------- Mysql 改默认密码 update mysql.user set Password=PASSWORD('12...
声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn