Dyntex.net Support Centre: MySQL Reference Manual p.439

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

Chapter 6: MySQL Language Reference 439 & Bitwise AND mysql> SELECT 29 & 15; -> 13 The result is an unsigned 64-bit integer. ^ Bitwise XOR mysql> SELECT 1 ^ 1; -> 0 mysql> SELECT 1 ^ 0; -> 1 mysql> SELECT 11 ^ 3; -> 8 The result is an unsigned 64-bit integer. << Shifts a longlong (BIGINT) number to the left: mysql> SELECT 1 << 2; -> 4 The result is an unsigned 64-bit integer. >> Shifts a longlong (BIGINT) number to the right: mysql> SELECT 4 >> 2; -> 1 The result is an unsigned 64-bit integer. ~ Invert all bits: mysql> SELECT 5 & ~1; -> 4 The result is an unsigned 64-bit integer. BIT_COUNT(N) Returns the number of bits that are set in the argument N: mysql> SELECT BIT_COUNT(29); -> 4 6.3.6.2 Miscellaneous Functions DATABASE() Returns the current database name: mysql> SELECT DATABASE(); -> 'test' If there is no current database, DATABASE() returns the empty string. USER() SYSTEM_USER() SESSION_USER() Returns the current MySQL user name:

MySQL Reference Manual

Our Partners

SpiritHost - web hosting for spiritual and education sites
SpiritHit.com - Religious and Spiritual Portal

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide