How can we encrypt and decrypt a data presented in a table using MySQL?

You can use functions: AES_ENCRYPT() and AES_DECRYPT()
like:
AES_ENCRYPT(str, key_str)
AES_DECRYPT(crypt_str, key_str)