Collections:
DEFAULT() - Table Column Default Value
How to obtain the default value of a table column using the DEFAULT() function?
✍: FYIcenter.com
DEFAULT(col) is a MySQL built-in function that returns the default value of a given table column. For example:
CREATE TABLE MyTable (Weight FLOAT, Height FLOAT DEFAULT 1.7); INSERT INTO MyTable (Weight) VALUES (70); INSERT INTO MyTable (Weight, Height) VALUES (72, DEFAULT(Height)+0.1); SELECT Weight, Height, DEFAULT(Height) FROM MyTable; -- +--------+--------+-----------------+ -- | Weight | Height | DEFAULT(Height) | -- +--------+--------+-----------------+ -- | 70 | 1.7 | 1.7 | -- | 72 | 1.8 | 1.7 | -- +--------+--------+-----------------+
Note that calling DEFAULT() on a column that has no default value may get NULL or error. For example,
SELECT Weight, Height, DEFAULT(Weight) FROM MyTable; -- +--------+--------+-----------------+ -- | Weight | Height | DEFAULT(Weight) | -- +--------+--------+-----------------+ -- | 70 | 1.7 | NULL | -- | 72 | 1.8 | NULL | -- +--------+--------+-----------------+ SELECT DEFAULT(name) FROM mysql.help_topic; ERROR 1364 (HY000): Field 'name' doesn't have a default value
Reference information of the DEFAULT() function:
DEFAULT(col): val Returns the default value of a given table column. Arguments, return value and availability: col: Required. The table column to be examined. val: Return value. The default value of the column. Available since MySQL 4.0.
⇒ EXTRACTVALUE() - Extracting Text Content from XML
⇐ CONVERT() - Character Set Conversion
2023-12-19, 226🔥, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...