single flat mysql database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
isaac_cm
Forum Commoner
Posts: 44
Joined: Wed May 17, 2006 8:47 am

single flat mysql database

Post by isaac_cm »

Hello,
Is it possible to create a single flat file mysql database ?

Thanks
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: single flat mysql database

Post by califdon »

isaac_cm wrote:Hello,
Is it possible to create a single flat file mysql database ?

Thanks
What do you mean? A database is not a simple text file, but if you mean can you have a single table in a database, of course the answer is Yes.
isaac_cm
Forum Commoner
Posts: 44
Joined: Wed May 17, 2006 8:47 am

Re: single flat mysql database

Post by isaac_cm »

No I mean like codegear interbase , firebird or sqlite
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: single flat mysql database

Post by califdon »

isaac_cm wrote:No I mean like codegear interbase , firebird or sqlite
Those are not mysql databases. You asked, "Is it possible to create a single flat file mysql database ? "
isaac_cm
Forum Commoner
Posts: 44
Joined: Wed May 17, 2006 8:47 am

Re: single flat mysql database

Post by isaac_cm »

maybe you did not understand me
I mean is there a feature in mysql to create single flat file db ?
"Is it possible to create a single flat file mysql database ? "
you miss the word "mysql"
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: single flat mysql database

Post by califdon »

isaac_cm wrote:maybe you did not understand me
I mean is there a feature in mysql to create single flat file db ?
"Is it possible to create a single flat file mysql database ? "
you miss the word "mysql"
I think we are not understanding each other.

MySQL is a relational database engine. Like every other relational database engine, it works with Tables. A database with one Table is sometimes referred to as a "flat file", meaning that it has no related Tables. But "flat file" is not a well defined term in database technology, and some people interpret it to mean a simple ASCII text file. If you are trying to ask, "can MySQL create an ASCII text file, such as a CSV (comma separated values) file?", the answer is that you can export data in CSV format, but then, it is not a MySQL file, it is a CSV text file. This is why you are having a problem getting an answer. You are asking a question using terms that have different meanings in the database world.
Post Reply