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, 1688🔥, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Where to find reference information and tutorials on MySQL database functions? I want to know how to...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...