There are many methods for populating a MySQL database. This video demonstrates a simple manual method to insert rows, with attention to how to insert data when autoincrement columns are present, the use of single quotes, and entering integer, string and Boolean values into your table.You will also see examples of statements for selecting and displaying your data, as well as pitfalls to avoid when updating or deleting data.
- View Offline
- Exercise Files
In the previous movie, we learned the syntax that we use to create, read, …update and delete records in MySQL. Now let's start adding data to our …subjects table and take our new MySQL commands out for a test drive. …So as you can see I'm already inside MySQL and I've already got my database …created and my subject's table created. And those are the columns there, it says field. …Those are the columns that I've got to work with. …Let's try some of the SQL that we just learned. …So let's start by doing select and then asterisk from subjects. …That's the simplest command that we can do for a read.…
And it comes back and says there's nothing there. …I don't get anything back there are no rows inside the subjects table. …We have to add one. So let's try that with insert, sert into. …And then our subjects. And then you'll remember that in …parentheses we're going to provide the columns that we want to insert into. …Now, I'm going to leave the ID column off. …Remember it's going to auto increment that for us. …
- What is PHP?
- Installing and configuring PHP and MySQL
- Exploring data types
- Controlling code with logical expressions and loops
- Using PHP's built-in functions
- Writing custom functions
- Building dynamic webpages
- Working with forms and form data
- Using cookies and sessions to store data
- Connecting to MySQL with PHP
- Creating and editing database records
- Building a content management system
- Adding user authentication
Skill Level Beginner
PHP with MySQL Beyond the Basicswith Kevin Skoglund10h 26m Intermediate
1. PHP Overview
2. Mac Installation
3. Windows Installation
4. First Steps
5. Exploring Data Types
6. Control Structures: Logical Expressions
7. Control Structures: Loops
8. User-Defined Functions
10. Building Web Pages with PHP
11. Working with Forms and Form Data
12. Working with Cookies and Sessions
13. MySQL Basics
14. Using PHP to Access MySQL
15. Building a Content Management System (CMS)
16. Using Site Navigation to Choose Content
17. Application CRUD
18. Building the Public Area
19. Regulating Page Access
Next steps2m 4s
- 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.