BITWISE OPERATIONS IN MYSQL

Hi IT knowledge lovers.. you are was choice the right blog.. because this is blog to fill IT knowledge.. Yoa are can to learn and taken many IT knwledge in here.. You must reading my article, I sure want add your knowledge…

Likely this article,I want discuss about IT knowlede, and still DATABASE using MYSQL. And now, I want giving you tutorial about “BITWISE OPERATIONS”. You will know and taken of knowledge it ?? let’s do read my article… have fun friends to read this article…

To be found 5 (five) bitwise operation in MYSQL, that is :

|            :           Bitwise OR

&           :          Bitwise AND

<<        :           Left Shift

>>        :          Right Shift

~          :           inverse, negation

A. DATABASE()

>> This is function for take name of database is active

B. USER()

>> This is function for take user is active

C. PASSWORD

>> This is function for making enkripsi at one particular string.

D. ENCODE

>> This is function to do enkripsi at one particular string "str "by use of password

E. DECODE

>> This is function for describe a string by use of password

F. MD5

>> Describe a string by use of method md5. By use of this function a string can't be described. So a lot of programmers utilizes makings deep this password.

G. LAST_INSERT_ID

>> For this subsequent function is utilized to take' id' processes deep last insert, where is its table contains field who gets character' auto increment'. Auto increment is alone is field that its deliberate for, but field that not we entry, but field that automatic will filled by number that do ever increase

H. VERSION

>> This function not just after often we utilize in table's makings, since this function just give information to us MYSQL version that we utilize

Ok.. just it..

I hope you understand…

If you do not understand, please leave a comments

See you laters