This lecture1s about reading data from a
Apuntes
This lecture's about reading data from a MySQL database. MySQL's one of the most widely used open source databases, and it's widely used because it's, partially because it's free but also because it works really well. And it's, again, widely used in Internet-based applications. Data are structured in databases, and then the databases, within each database, there's a series of tables. And then within the tables, there a series of fields. So, you can think of each table sort of as the data set, and each field as, say, one of the calms of that data set. So, each row in the database is called a record. If you want to know a little bit more about MySQL structure, you can look at the the Wikipedia page, or there's quite extensive documentation at MySQL.com. So, here's an example structure that you would get for a particular database. So, what you have is here this is a database of employees. And so, what you might have here are several different tables that are all linked together. So, for example, you might have the departments that the employees are employed in, the employees themselves. You might have information about their salaries in a different table, and you might have informatio...
Estudia con juegos interactivos
Sube tus apuntes y genera flashcards, examenes y mas con IA
Empezar gratis