Inserts
Adding a
row to a
table is one of the more
straightforward concepts in SQL. You have already seen several
examples of it in this book. MySQL supports the standard SQL
INSERT
syntax:
INSERT INTOtable_name
(column1
,column2
,...
,columnN
) VALUES (value1
,value2
,...
,valueN
)
Under this syntax, you specify the columns followed by the values to populate those columns for the new row. When inserting data into numeric fields, you can insert the value as is; for all other fields, you must wrap them in single quotes. For example, to insert a row of data into a table of addresses, you might issue the following command:
INSERT INTO addresses (name, address, city, state, phone, age) VALUES('Irving Forbush', '123 Mockingbird Lane', 'Corbin', 'KY', '(800) 555-1234', 26)
In addition, the
escape
character—\
, by default—enables you to
escape single quotes and other literal instances of the escape
character:
# Insert info for the directory Stacie's Directory which # is in c:\Personal\Stacie INSERT INTO files (description, location) VALUES ('Stacie\'s Directory', 'C:\\Personal\\Stacie')
MySQL allows you to leave out the column names as long as you specify
a value for every column in the table in the order they were
specified in the table’s CREATE
call. If you want to use the default values for a column, however,
you must specify the names of the columns for which you intend to
insert nondefault data. For example, if the earlier
files
table had contained a column called
size
, the default ...
Get Managing & Using MySQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.