With respect to database design and performance is it good to have more
tables with fewer records or with few tables having lots of records.
Anil

After reading Joe Celko's rant[1] about things varying from naming
conventions to normalisation, I'd like to know which are his personal pet
peeves and which are generally considered Bad Things. I agree with all his
points but two:

Is there a way to select strings where the wildcard is found elsewhere.
For example:
Say I pump a bunch of files into a database so I can analyze the data.
if file1.xml maps to a table with rows that contain this data

Hi SQL experts (I hope),
I am confronted with sth for which I have trouble thinking of an
answer w/o using subqueries. I'm sure it'll use MIN() & Group By - but
there I'll have to pass...

Firebird database fans!
Hello!
Lets try to make a new newsgroup called Firebird to deatache from the rest!
Any one outhere mail-me!  domnulbobo@yahoo.it

I've just publish the english version of a new website on which I'm
working since for 2 years now and was available in french for near one
year:
Kahuma is a new concept of web site whose purpose is to give people a

I am doing a comparison study between Oracle 7.3 and MySQL 4.0. If
anyone has any idea or links about this can you please help me out.
Expecting an earliest reply.
-Sabeena

I have been trying to use PostgreSQL and the manual does not explain
clearly enough how to make databases into different directories, or is
it even possible?
So, for example there are two users (Foo and Bar) in linux environment.

Hi;
I would like to help a volunteer organization out that gets a free mysql
 with their web site.
Right now, there entire database, 900 records, is in one big fat ms

I was previously using the old bytefx connector,  but have just
upgraded to the official release connector/net beta
Since doing so I am receiving the folowing :
Item has already been added. Key in dictionary: "read_only" Key being

First, i want to check for duplicate data in table. If found that have
duplicate data,the stored procedure will automatically generate a mail
to the client. Is it possible to do that? and what is the coding for
the stored procedure? Thanks

I've have a MySQL server that is used in conjunction with a PHP enabled
web-server, and ther are several users on the system.
In the past I've used the following SQL to create databases and users:

Just wondering if you have done this before in some
stored procedure...
Lets say we have customer table
CustID            CustName

i upgraded postgresql from 7.3 to 7.4 and noticed that SERIAL
exists but does not working. Example:
My table:
create table1(

I am currently learning Java (yes I know, it was about time to get
started). The book I use shows SQL examples reading some small databases
(4 columns, 5 rows). All these Java database SQL primitives are meant to
work only on JDBC-ODBC compliant databases (it is a 1997 book!). ...