Collections:
Inserting a New Row into a Table in MySQL
How To Insert a New Row into a Table in MySQL?
✍: FYIcenter.com
To insert a new row into a table, you should use the INSERT INTO statement with values specified for all columns as shown in the following example:
mysql> INSERT INTO fyi_links VALUES (101, 'dev.fyicenter.com', NULL, 0, '2006-04-30'); 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 | +-----+-------------------+-------+--------+---------------+ 1 row in set (0.05 sec)
⇒ Using Column Default Values in MySQL
⇐ Creating a Test Table in MySQL
2018-01-16, 1454🔥, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...