课程: PHP with MySQL Essential Training: 1 The Basics

今天就学习课程吧!

今天就开通帐号,24,700 门业界名师课程任您挑!

Challenge: Pages table

Challenge: Pages table

(upbeat music) - [Instructor] It's time for another challenge assignment. So far in this chapter, we've been learning how to use MySQL to create tables and populate them with data. We've been doing that using our subjects table. Now your challenge assignment is do that same work, but with the pages table that we're also going to need. Let me walk you through the points you need to make sure you hit. First, start by logging completely out of MySQL, so that you can get a fresh start. Log into MySQL, make sure that you can do that confidently. You want to do that as the root user and supply the password. And then, once you're in there, make sure that you're using the correct database. So use the globe_bank database we already created and then create a table for pages. It's extremely helpful if you construct that table definition in a text editor and not try and do it from the command line. Do it in a text editor first where you have the ability to make revisions, to check for bugs, make…

内容