I have table/db I need to create that has a rectangle structure even
when normalized, but the difficulty is that the rows can have a large
number of column - over the max of what mysql can handle. If I put the
data in vertical format I lose a lot of functionality. If I split the

What industry naming standards are out there for database names of
columns/attributes?  I am not referring to specific names in various
dtd's, for example, but general naming standards.  This might include
whether to use _FLAG or IS_ for boolean types, for example.

as first I dont know practicaly nothing about databases so...
i have some dbf files created in 1993-94. Along with dbf files i got exe
file named "catalog" that works under dos, in which i can open dbf's.
Problem is that each dbf file contains 250-300 records and i can list

Hi, all:
Does there exist a tool to convert a Postgresql database to a MySQL
one? I recently had to switch webhosts for a forum I run due to
factors beyond my control and was hoping to keep all my users' old

I am not a programmer, I only work in a business office, but by
unfortunate incidents have been put in charge of updating/maintaining a
Visual Foxpro database with business information. (really ad hoc and
the person who set it up is long gone) I am currently having to travel

What is the best way to monitor a MySQL server to find slow SELECT
operations?

I maintain a website (<a>www.pdn.ac.lk/eng/pefaa</a>) it uses mysql &
php. i comleted before 1 week & it worked fine. But today morning the
search link (<a>www.pdn.ac.lk/eng/pefaa/search/</a>)prompt the failure
message that i put in the die part of the fuction mysql_db_query for

i ask about the stability of the database for big system database does
postgresql stable like oracle and when there is a power faliure oracle
solved this problem what about this problem (power faliure)in
postgresql db ?

I have a project to put together. My company keeps records of employee
regulatory testing. I want to put together a program that will track
employee testing.
The employee will log in, take the test which, only whether they passed or

Hello, can some one give me the size limite of a table in Postgres and
MysqL ?
thanks !

I have to migrate datatbase from MS-SQL to DB2 UDB. I need some
pointer where I can get the syntax difference between MS-SQL and DB2
UDB.
Thanks in advance,

I'm trying to run an update statement that'll get the smallest value
from one table and insert it into another.  The following update
statement does this (I think), but doesn't work on any version of MySQL
that I have access to (4.0 and 3.23):

I think If you're developing an object oriented application that
requires a relational database, you'll need to develop persistence
objects that are modeling against your database design and know how to
interact with different tables in the database. You can either develop

I have a large number of binary .NDB database files that I need to
access the contents of. Would anyone know of any utility (or
Access/Excel plugin) that can view the contents of these files or
failing that, details of the file format?

Best Regards,
I worked on Oracle for a long time, but I have a problem with it, it is
not cheap for bussiness..
Does anyone please knows any OpenSource Database powerful as Oracle,