TRUNCATE– Truncate a number to the specified number of decimal places.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.DATE– Stores data values in the format YYYY-MM-DD.VARCHAR– Variable-length strings that specify the maximum number of characters it stores (up to 65535).CHAR- Fixed-length character strings that specify the maximum number of characters it stores (up to 254 characters).DECIMAL- Exact decimal values specified in the format (M, D) the maximum number of digits for M is 65, while for D it is 35.Use MySQL data types to specify what kind of value the column will store. When creating columns in a table, you need to specify their name and data type. Working With Views in MySQLĬreate a view (virtual table) with the specified content: CREATE VIEW view_name ASĭelete a view: DROP VIEW view_name MySQL Data Types

Learn how to backup and restore a MySQL database.

Macbook pro cheat sheet pdf