From the course: Learning phpMyAdmin
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Inserting data manually
- We've created a table called cars in the up_and_running database but it doesn't yet have any data in it. Because phpMyAdmin knows the structure of the table, you can use it as a simple content management system to insert records manually. I've currently got the structure of the cars table displayed in phpMyAdmin. To start adding records, just click the Insert tab at the top. This displays a form where you can insert the values manually. The first column, car_id, was defined as an auto-increment column so we need to leave the Value field blank. The next available number will be inserted automatically when you submit the form. The next column, make_id, will hold the foreign key from a table that hasn't yet been created. The default value is set to 0 so it should've been populated automatically here and just leave it at that. Now, we do need to create a value for yearmade. On the left here, we've got a drop-down menu called Function. If you open that, you've got a list of all the MySQL…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Choosing the right column types6m 6s
-
(Locked)
Collation, character sets, and storage6m 2s
-
(Locked)
Defining a table8m 19s
-
(Locked)
Amending the table structure5m 55s
-
(Locked)
Inserting data manually5m
-
(Locked)
Using the Browse tab7m 21s
-
(Locked)
Copying a column definition to another table with central columns7m 24s
-
-
-
-
-
-
-