Home Ebook MYSQL Cheat Sheet Free Download

MYSQL Cheat Sheet Free Download

by Unallocated Author

 

Download free MYSQL cheat sheet by David Child

Free Download: MYSQL Cheat Sheet 

MySQL Data Types

 

CHAR String       (0 - 255)

VARCHAR String    (0 - 255)

TINYTEXT String   (0 - 255)

TEXT String       (0 - 65535) 

BLOB String       (0 - 65535)

MEDIUMTEXT String (0 - 16777215)

MEDIUMBLOB String (0 - 16777215)

LONGTEXT String   (0 - 429496­7295)

LONGBLOB String   (0 - 429496­7295)

TINYINT x Integer (-128 to 127)

SMALLINT x Integer(-32768 to 32767)

MEDIUMINT x Integer (-8388608 to 8388607)

INT x Integer     (-2147­483648 to 214748­3647)

BIGINT x Integer  (-9223­372­036­854­775808 to 922337­203­685­477­5807)

FLOAT Decimal     (precise to 23 digits)

DOUBLE Decimal    (24 to 53 digits)

DECIMAL "­DOU­BLE­" stored as string

DATE              YYYY-MM-DD

DATETIME          YYYY-MM-DD HH:MM:SS

TIMESTAMP         YYYYMM­DDH­HMMSS

TIME              HH:MM:SS

ENUM              One of preset options

SET               Selection of preset options

 

MySQL Mathem­atical Functions

ABS     COS

SIGN    SIN

MOD     TAN

FLOOR   ACOS

CEILING ASIN

ROUND   ATAN, ATAN2

DIV     COT

EXP     RAND

LN      LEAST 

LOG, LOG2, LOG10 GREATEST 

POW     DEGREES 

POWER   RADIANS 

SQRT    TRUNCATE

PI

 

MySQL Date and Time Functions

DAYOFWEEK DATE_SUB

WEEKDAY ADDDATE

DAYOFMONTH SUBDATE

DAYOFYEAR EXTRACT 

MONTH TO_DAYS

DAYNAME FROM_DAYS

MONTHNAME DATE_F­ORMAT

QUARTER TIME_F­ORMAT

WEEK CURREN­T_DATE

YEAR CURREN­T_TIME

YEARWEEK NOW

HOUR SYSDATE

MINUTE UNIX_T­IME­STAMP

SECOND FROM_U­NIXTIME

PERIOD_ADD SEC_TO­_TIME

PERIOD­_DIFF TIME_T­O_SEC

DATE_ADD

 

MySQL Miscel­laneous Functions

BIT_COUNT    DES_EN­CRYPT

DATABASE     DES_DE­CRYPT

USER LAST  _ I­NSE­RT_ID

SYSTEM­_USE   FORMAT

SESSIO­N_USER VERSION

CURREN­T_USER CONNEC­TION_ID

PASSWORD     GET_LOCK

OLD_PA­SSWORD RELEAS­E_LOCK

ENCRYPT      IS_FRE­E_LOCK

DECODE       BENCHMARK

MD5          INET_NTOA

SHA1         INET_ATON

AES_EN­CRYPT  FOUND_ROWS

AES_DE­CRYPT  STRCMP

 

MySQL String Functions

 

ASCII       SUBSTRING

ORD         MID

CONV        SUBSTRING_INDEX

BIN         LTRIM

OCT         RTRIM

HEX         TRIM

CHAR        SOUNDEX

CONCAT      SPACE

CONCAT_WS   REPLACE

LENGTH      REPEAT

CHAR_LENGTH REVERSE

BIT_LENGTH  INSERT

LOCATE      ELT

INSTR       FIELD

LPAD        LCASE

RPAD        UCASE

LEFT LOAD  _FILE

RIGHT       QUOTE

 

MySQL Grouping Functions

 

AVG           MAX

BIT_AND       STD

BIT_OR        STDDEV

COUNT         SUM

GROUP_­CONCAT  VARIANCE

MIN

 

Free Download: MYSQL Cheat Sheet

You may also like

2 comments

shahid sohail April 21, 2016 - 2:20 pm

HELLO Admin
great approaches and very excellent topic
keep it up
very useful

prince gupta November 24, 2015 - 4:27 am

Techigniters

Comments are closed.

Latest Hacking News

Privacy Preference Center

Necessary

The __cfduid cookie is used to identify individual clients behind a shared IP address and apply security settings on a per-client basis.

cookie_notice_accepted and gdpr[allowed_cookies] are used to identify the choices made from the user regarding cookie consent.

For example, if a visitor is in a coffee shop where there may be several infected machines, but the specific visitor's machine is trusted (for example, because they completed a challenge within your Challenge Passage period), the cookie allows Cloudflare to identify that client and not challenge them again. It does not correspond to any user ID in your web application, and does not store any personally identifiable information.

__cfduid, cookie_notice_accepted, gdpr[allowed_cookies]

Advertising

DoubleClick by Google refers to the DoubleClick Digital Marketing platform which is a separate division within Google. This is Google’s most advanced advertising tools set, which includes five interconnected platform components.

DoubleClick Campaign Manager: the ad-serving platform, called an Ad Server, that delivers ads to your customers and measures all online advertising, even across screens and channels.

DoubleClick Bid Manager – the programmatic bidding platform for bidding on high-quality ad inventory from more than 47 ad marketplaces including Google Display Network.

DoubleClick Ad Exchange: the world’s largest ad marketplace for purchasing display, video, mobile, Search and even Facebook inventory.

DoubleClick Search: is more powerful than AdWords and used for purchasing search ads across Google, Yahoo, and Bing.

DoubleClick Creative Solutions: for designing, delivering and measuring rich media (video) ads, interactive and expandable ads.

doubleclick

Analytics

The _ga is asssociated with Google Universal Analytics - which is a significant update to Google's more commonly used analytics service. This cookie is used to distinguish unique users by assigning a randomly generated number as a client identifier. It is included in each page request in a site and used to calculate visitor, session and campaign data for the sites analytics reports. By default it is set to expire after 2 years, although this is customisable by website owners.

The _gat global object is used to create and retrieve tracker objects, from which all other methods are invoked. Therefore the methods in this list should be run only off a tracker object created using the _gat global variable. All other methods should be called using the _gaq global object for asynchronous tracking.

_gid works as a user navigates between web pages, they can use the gtag.js tagging library to record information about the page the user has seen (for example, the page's URL) in Google Analytics. The gtag.js tagging library uses HTTP Cookies to "remember" the user's previous interactions with the web pages.

_ga, _gat, _gid