Collections:
Using Column Default Values in MySQL
How To Specify Default Values in INSERT Statement in MySQL?
✍: FYIcenter.com
If a column is defined with a default value in a table, you can use the key word DEFAULT in the INSERT statement to take the default value for that column. The following tutorial exercise gives a good example:
mysql> INSERT INTO fyi_links VALUES (102, 'dba.fyicenter.com', NULL, 0, DEFAULT); Query OK, 1 row affected, 1 warning (0.01 sec) mysql> SELECT id, url, notes, counts, DATE(created) FROM fyi_links; +-----+-------------------+-------+--------+---------------+ | id | url | notes | counts | DATE(created) | +-----+-------------------+-------+--------+---------------+ | 101 | dev.fyicenter.com | NULL | 0 | 2006-04-30 | | 102 | dba.fyicenter.com | NULL | 0 | 2006-07-01 | +-----+-------------------+-------+--------+---------------+ 2 rows in set (0.00 sec)
⇒ Omitting Columns in INSERT Statements in MySQL
⇐ Inserting a New Row into a Table in MySQL
2018-01-16, 1553🔥, 0💬
Popular Posts:
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...