Tag: database

Types of Table Relationships

To create a good database, I have to know the relationship between tables. It is clear, the database I talking about is relationship database. There are three types of table relationships. One-to-one relationships One-to-many relationships Many-to-many relationships One-to-one relationships In a one-to-one relationship, a key will appear only once in a related table. It is

Main Features of MySQL

I choose MySQL as my program’s database. The main features of MySQL are: Speed Portability Ability to interface with any programming languare Price MySQL is a multithreaded server, meaning that each time a connection is made, a new server process is started. If you have to switch operating systems or languages mid-stream, use the mysqldump

PHP connect DBF file

DBF is very old format databse type. About 10 years ago, I use dBase which use DBF format. Now I will show you how to connect the DBF file from PHP script. 1) Add a system DSN in ODBC Data Source Administrator I have a source named dd.