3/29/2023 0 Comments Sql queries xteam codes channelsYou can save the cheat sheet in PDF format by clicking the Download MySQL Cheat Sheet button below. This article includes a one-page MySQL commands reference sheet. NULLIF – If the first argument is equal to the second argument, the result returns NULL (if not, it returns the first argument).IFNULL – Return the first argument if it is NOT NULL (or the second if it is).IF – Return a value based on a specified condition.CASE – A case operator that allows you to add if-else logic to a query.IS_NOT_NULL – Test for NOT NULL values.BETWEEN.AND – Value is within the specified range.>= – Value is greater than or equal to.TRIM– Return a string without any prefixes or suffixes. ![]() LOG– Returns the natural logarithm of a specified number.BIN– Return a binary representation of a number.ASCII– Return ASCII value of left-most character.The number of transaction that a Channel can handle, at a point of time. TRUNCATE– Truncate a number to the specified number of decimal places. The number of transaction that a Channel can handle, at a point of time. ![]() DATE_FORMAT – Format a date based on the specified format.DATE_SUB – Subtract a time/date interval from a data value.DATE_ADD – Add a time/date interval to a date value.DAY– Return the day of the month of the specified date.DATEDIFF– Calculate the number of days between two dates.Some of the most commonly used MySQL functions include: These functions allow you to manipulate data. MySQL comes with many built-in functions. Note: Instead of setting up a separate MySQL server, you can also deploy MySQL in a Docker container. TEXT– Stores character strings, typically those with in a longer form (up to 65535 characters).DATETIME– Contains both date and time, but has a range from 00:00:01' UTC to ' 03:14:07' UTC. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |