Skip to content
  • Blog (1)
  • About Us
  • Tags
  • Donations
1SMARTchicken - Code Made Easy
  • Tutorials (176)
  • Reference (2172)
  • Snippets (69)

Tag: MySQL Advanced Functions

1SMARTchicken - Code Made Easy

Tag: MySQL Advanced Functions

  • Tutorials (176)
  • Reference (2172)
  • Snippets (69)
  • Blog (1)
  • About Us
  • Tags
  • Donations
1SMARTchicken - Code Made Easy
  • Tutorials (176)
  • Reference (2172)
  • Snippets (69)
1SMARTchicken - Code Made Easy

Tag: MySQL Advanced Functions

  • Tutorials (176)
  • Reference (2172)
  • Snippets (69)
  • Home
  • MySQL Advanced Functions
SQL Reference

SQL – MySQL BIN() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL BIN() function returns a binary representation of a number, as a string value.

SQL Reference

SQL – MySQL BINARY Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL BINARY function converts a value to a binary string.

SQL Reference

SQL – MySQL CASE Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL CASE statement goes through conditions and will stop reading and return a value when the first condition in the list is met.

SQL Reference

SQL – MySQL CAST() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL CAST() function converts a value of any type into the specified datatype.

SQL Reference

SQL – MySQL COALESCE() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL COALESCE() function returns the first non-null value in a list.

SQL Reference

SQL – MySQL CONNECTION_ID() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL CONNECTION_ID() function returns the unique connection ID for the current connection.

SQL Reference

SQL – MySQL CONV() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL CONV() function converts a number from one numeric base system to another, and returns the result as a string value.

SQL Reference

SQL – MySQL CONVERT() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL CONVERT() function converts a value into the specified datatype or character set.

SQL Reference

SQL – MySQL CURRENT_USER() Function

August 12, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL CURRENT_USER() function returns the user name and host name for the MySQL account that the server used to authenticate the current client.

SQL Reference

SQL – MySQL DATABASE() Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL DATABASE() function returns the name of the current database. If there is no current database, this function returns NULL or “”.

SQL Reference

SQL – MySQL IF() Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / Conditional, MySQL, MySQL Advanced Functions

The MySQL IF() function returns a value if a condition is TRUE, or another value if a condition is FALSE.

SQL Reference

SQL – MySQL IFNULL() Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / Conditional, MySQL, MySQL Advanced Functions

The MySQL IFNULL() function returns a specified value if the expression is NULL.

SQL Reference

SQL – MySQL ISNULL() Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL ISNULL() function returns 1 (null) or 0 (not null) depending on whether an expression is NULL.

SQL Reference

SQL – MySQL LAST_INSERT_ID() Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL LAST_INSERT_ID() function returns the AUTO_INCREMENT id of the last row that has been inserted or updated in a table.

SQL Reference

SQL – MySQL NULLIF() Function

August 14, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL NULLIF() function compares two expressions and returns NULL if they are equal. Otherwise, the first expression is returned.

SQL Reference

SQL – MySQL SESSION_USER() Function

August 14, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL SESSION_USER() function returns the current user name and host name for the MySQL connection.

SQL Reference

SQL – MySQL SYSTEM_USER() Function

August 14, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL SYSTEM_USER() function returns the current user name and host name for the MySQL connection.

SQL Reference

SQL – MySQL USER() Function

August 15, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL USER() function returns the current user name and host name for the MySQL connection.

SQL Reference

SQL – MySQL VERSION() Function

August 15, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Advanced Functions

The MySQL VERSION() function returns the current version of the MySQL database, as a string.

or View All Tags

Tutorials

  • HTML Tutorials (40)
  • CSS Tutorials (45)
    • CSS Flexbox (12)
  • JavaScript Tutorials (6)
  • jQuery Tutorials (13)
  • PHP Tutorials (0)
  • SQL Tutorials (0)
  • Python Tutorials (72)
    • Python File Handling (4)
    • Python and MySQL (4)
  • WordPress Tutorials (0)

Reference

  • HTML Reference (244)
    • HTML Tags (107)
    • HTML Attributes (46)
    • HTML Events (76)
    • HTML Resources (15)
  • CSS Reference (309)
    • CSS Selectors (55)
    • CSS Properties (220)
    • CSS Functions (17)
    • CSS Resources (17)
  • JavaScript Reference (555)
    • JavaScript Selectors (7)
    • JavaScript Operators (12)
    • JavaScript Statements (17)
    • JavaScript Methods (284)
    • JavaScript Properties (162)
    • JavaScript RegExp (45)
    • JavaScript Resources (28)
  • jQuery Reference (220)
    • jQuery Selectors (54)
    • jQuery Methods (140)
    • jQuery Ajax Methods (16)
    • jQuery Properties (17)
    • jQuery Resources (9)
  • PHP Reference (460)
    • PHP Keywords (59)
    • PHP Functions (400)
    • PHP Constants (0)
    • PHP Resources (1)
  • SQL Reference (290)
    • SQL Keywords (59)
    • MySQL Functions (138)
    • SQL Server Functions (83)
    • SQL Resources (10)
  • Python Reference (94)
    • Python Methods (86)
    • Python Resources (8)
  • WordPress Reference (0)

Snippets

  • HTML Snippets (3)
  • CSS Snippets (12)
  • JavaScript Snippets (5)
  • jQuery Snippets (8)
  • PHP Snippets (1)
  • SQL Snippets (3)
  • Python Snippets (1)
  • WordPress Snippets (36)
1SMARTchicken - Code Made Easy

333 Washington Blvd.
Suite 126
Marina del Rey, CA 90292
United States

contact2025@1smartchicken.com

  • About Us
  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Search for Code:

or View All Tags

Copyright © 2025 1SMARTchicken | All Rights Reserved.