Join Bill Weinman for an in-depth discussion in this video Inserting rows, part of MySQL Essential Training (2014).
…The insert into statement is used to add a row or rows to a table.…We'll select the scratch database here for this lesson.…And I'm going to start by creating a temporary table.…I'll just call it test.…And we'll give it a couple of columns here.…A INT, b TEXT and c TEXT.…And now we'll insert a row into the table.…INSERT INTO.…So, I'm typing all of these.…
Statements and I'm going to execute them all at once.…So we're going to insert into test values one this…right here and then we'll use a select statement to view what's in the table.…Which should be one row.…Now when I press the go button it will…create the table and insert a row into the table.…And then display it with the select.…And there is the row that we created.…So the insert into statement resulted in a new row in the table.…And that's this statement right here, the second one.…
The values clause is used to list the data values for the new row.…So it says values and then in parentheses here it has those values for…the new row, One, this one right here, and there they are in the table.…
- Writing queries
- Creating and updating databases and tables
- Using MySQL built-in functions
- Sorting and filtering data
- Updating tables with triggers
- Working with subselects and views
- Creating and using a stored function
Skill Level Beginner
1. Installing and Configuring the Test Environment
2. Basic Syntax
3. Creating a Database
4. MySQL Data Types
5. MySQL Functions
8. Subselects and Views
9. Stored Routines
10. PHP's PDO Interface with MySQL
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.