PHP notes, Hanshunping PHP notes _php Tutorials

PHP notes, Hanshunping PHP notes

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

Mysql Change the default password
Update Mysql.user set Password=password (' 123456 ') WHERE user= ' root '
FLUSH Privileges

To understand MySQL's paradigm, inverse paradigm, mixed paradigm
and the establishment of an index.
CMD command line

Full-Text Indexing
------------------------------
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 Installation
net start MySQL startup service

Zend Code Style
----------------------------------------------------------------
Formatter {}

Ctrl+shift+f All selected Press this will be automatically formatted.

http://www.bkjia.com/PHPjc/1049392.html www.bkjia.com true http://www.bkjia.com/PHPjc/1049392.html techarticle php notes, Hanshunping PHP notes mysql-----------------------------------------------------------------------------mysql change default password Update Mysql.user set Password=password (' ...

