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 ...
Get Practical Web Technologies now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
