Learn how adding rows to a table is accomplished using the INSERT INTO statement. Discover that columns may be specified in any order, and values may be added to some, all, or no columns in the statement.
- [Instructor] To add a row or rows to a table,…use the insert into statement.…For this lesson, we're going to use the test database,…and I'm gonna start by creating a simple table.…So I'll say create table, call the table test,…and give it integer,…and text,…and another text column.…And then I'll select * from test,…and when I press go, of course there's no rows in the table,…but we also didn't get an error,…so that means that we created the test table successfully.…
So now we have an empty table.…Now this is an actual database,…this is not a memory database, so I can't create it again.…Instead, what I'm going to do here…is I'm going to insert into--…We'll add some data, we'll add a row to the table,…so I'll say insert into test,…that's the name of the table, and give it some values.…Give it a one and a string,…and another string.…
And now when I select from it, we'll see we have one row…with values in each of the columns.…So that's the simple form of insert into.…You give it a values clause, and inside the parentheses…
- Understanding SQL terminology and syntax
- Creating new tables
- Inserting and updating data
- Writing basic SQL queries
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Understanding numeric types
- Using aggregate functions and transactions
- Automating data with triggers
- Creating views
- Defining functions in PHP
Skill Level Beginner
2. SQL Overview
3. Fundamental Concepts
7. Dates and Times
Dates and times1m 52s
11. Views and Subselects
12. Defined Functions
13. A Simple CRUD Application
- 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.