MySQL is one of the most popular database management systems in recent times. Databases, as we all know, are used for storing data that's going to be used in the future when required. The data in a database can be secured through encryption and can be indexed for faster access. Where the volume of data is too high, a database management system is preferred over a traditional sequential and random file handling system. Storing data in a database is a very important task in any application.
This chapter is focused on understanding how table rows are managed in the database tables. In this chapter, you will learn about the following recipes:
- Displaying all the built-in tables in a default MySQL database
- Storing information into MySQL database
- Searching desired information in the database
- Updating information in the database
- Deleting data from the database using C
We will review the most commonly used functions in MySQL before we move on to the recipes. Also, ensure that you read Appendix B and Appendix C to install Cygwin and MySQL Server before implementing the recipes in this chapter.