O'Reilly logo

Practical Web Technologies by V. Lau, P. K. Yuen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

18.1. Creating databases and tables with SQL

18.1.1. Designing databases with tables

In this section, we will show you how to use MySQL databases to design tables on the Web. Some information regarding the data type differences among Microsoft Access, Oracle, and MySQL is also provided. In general the MySQL package is assumed to be installed on a remote machine called www.pwt-ex.com. Inside the MySQL server, we also assume a database called personnel and a table called people in early sections of this chapter.

You can refer to section 17.2 of Chapter 17 to see how to install MySQL, connect to the MySQL server, and create databases. Once you have registered a database such as personnel on your local machine, you can control it using the Web ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required