From the course: Learning phpMyAdmin

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Inserting data manually

Inserting data manually

From the course: Learning phpMyAdmin

Start my 1-month free trial

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…

Contents