PHP notes, Han Shunping php notes_PHP tutorial

PHP notes, Han Shunping php notes

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

Mysql change default password
update mysql.user set Password=PASSWORD('123456') WHERE User='root'
FLUSH PRIVILEGES

Learn about MYSQL's paradigm, anti-paradigm, mixed paradigm
and index creation
cmd command line

Full text index
--------------------------------
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
------------------------------------------------ ------------------------------------
ApachebinApacheMonitor.exe

#mysqld

------------------------------------------------- -----
mysqld install install
net start mysql start service

zend coding style
----------------------------------------- -----------------------
formatter ｛｝

Ctrl shift f Select all and press this to automatically format the layout