How to insert new records into a table in MySQL
To insert a new row of data into a current table in MySQL:
INSERT INTO table_name
VALUES (value1, value2, value3, ...);
If you want to insert a new record for some specific columns:
INSERT INTO table_name (col1, col2, col3, ...)
VALUES (value1, value2, value3, ...);
To insert multiple records:
INSERT INTO table_name
VALUES
(value1_1, value2_1, value3_1, ...)
(value1_2, value2_2, value3_2, ...)
(value1_3, value2_3, value3_3, ...)
;
In TablePlus, you can insert a new record into the table directly from its GUI tool with a spreadsheet-like view:
Double-click on an empty row at the end of the current table or click + Row button at the bottom to insert a row.
When you finish adding values, press Cmd + S to commit changes to the server.
Need a good GUI Tool for MySQL? TablePlus is a modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.
Not on Mac? Download TablePlus for Windows.
On Linux? Download TablePlus for Linux
Need a quick edit on the go? Download TablePlus for iOS.
