In the mysql client, he used to show possible words when I click a tab. Somehow he is not working now. There is no matter to turn it on again. I am using mysql client 5.5 on CentOS 5.5.
found a solution.
in my.cnf file, add
[mysql] auto-rehash
add no-auto-rehash to disable autocomplete.
no-auto-rehash