Is there a function to get the number of most occurences in a database?
Like, in a table, if i have values:
8
8

I'm experiencing performance problems with PostgreSQL 7.4.3 on a
OpenBSD 3.6 machine.
UPDATEs are taking 4-6 seconds on a table with 8845 rows (with 7195
affected rows). EXPLAIN tells me, that a Seq Scan is done with using a

I have following design for Shipment and Packaging
Shipment Item ---------* Packing Content *----------- Shipment Package
And Data requirement is :
Shipment Item

What's the easiest way to generate large test tables of random  (best within
specified parameters) data to be used in a MySQL db?
EMS Data Generator seemed *perfect*, but doens't on my system (Win XP, but
not all admin rights).

I've got a political (and technical question) I could use a hand with.
I developed (and maintain) an inventory system for a large company.  It has
over 150 regular users, one of which is bucking really hard for 5-10 "User
Defined Fields".  Read that as free-form text fields.

I am not very good at grasping things in my accounting systems class
such as creating flowchart and data-flow diagrams.  But, right now I'm
simply looking for some good tutorials or examples which *show* how to
get tables I guess into these normal forms.  Anybody know of any?

I'm putting "the key, the whole key, and nothing but the key, so help
me Codd" in a ppt slide and can't find an attribution for it.  Does
anyone know who should get the credit?  Thanks.  --dawn

Hi all, I'm trying to get started w/ web applications and thought I
should cover db design as well - figuring if my design was crappy my
web proj would be too. Could someone point me to or recommend database
resources that cover basic database design in the _real_ world. I have

I don't know how to formulate this question, so I try this and see
where it ends.
I want to create a database that will probably grow very big. How
should I do? My database is a Mysql DB and it will store free text

how to execute .sql files in mysql under linux
thanks in advance

I am currently using Erwin 4.0 Build 1338.  I have a consultant,
working offsite, who is using Erwin 4.1.2771.  My consultant friend has
made many changes in our db model and has since sent me the .er1 file.
Every time I try to open up the file I get a windows exception dialog.

Is there a maximum to how many attributes a table should have? I'm
implementing a user-based web-application for school. Should I, for
example, put all the user characteristics and preferences in one table or
should I split it in multiple tables.

I'm looking for a tool which should act like some kind of middleware/
logical layer bewtween the SQL server and the webbased user interface.
- It should be possible to easily create simple web forms (only data
input and output) without programming effort by "clicking" the fields

Oracle RAC and Data Guard Training
(By Gurus - Satisfaction Guaranteed or Money Back)
Are You
·    Career Conscious

Ignorant SQL question:
If I do a SELECT during a transaction, before COMMIT, does the select
sees whatever has been done earlier in the transaction?
Or in other words with something like: