At the last line, add
1) Open Terminal
2) To hide the hidden files, key in the below:
defaults write com.apple.finder AppleShowAllFiles TRUE
3) To display the hidden files, key in the below:
defaults write com.apple.finder AppleShowAllFiles FALSE
MySQL by default requires minimum of 4 alphabets to perform a search.
Here is a way to modify the minimum number on CentOS:
# mysql -u root
# nano /etc/my.cnf
add the below line and save it, the number indicate the minimum length for the search, here we put 3.
# service mysqld restart
rebuild the fulltext index of sql and it should work.
About this idea, you won't usually think about it until you really need it. Here is an example where you need it:
Assume you have a `table` with primary key `id` and you have `id` value 1 to 10000 stored in that table. When you are going up adds every `id` by 1, you may write
update `table` set `id`