O'Reilly logo

MySQL for Python by Albert Lukaszewski, PhD

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

Project: Web-based administration of MySQL

The project for this chapter will set the groundwork for the next several projects. We will write a program for administering MySQL remotely through a web interface. To be sure, more sophisticated applications like PHPMyAdmin exist. The value of creating one of your own is that you can extend it and change it in the future depending on your needs. Just creating the application is a good exercise as it leaves you with code that you can import into other applications at will and gives you a better understanding of the processes involved.

By the end of this project, we want a web application that will have the following aspects:

  • Ability to create MySQL statements for the following commands: CREATE, DROP, INSERT, ...

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