can anybody suggest any mechanism to map File system to Database. i am
working on a "Trash" module, its purpose is to store deleted items
until it is permanently deleted explicitly by the user from "Trash
can", it is operations are similar to Windows Recycle Bin and Linux

I want to know ,how can we compare MySQL and ORACLE?

I'm new to Sybase.
I have created an user defined data type in Sybase. This is
automatically getting created under DBO user.
If I use the UDT in temporary table, which I'm creating inside a

Hi, all.
I am working with Sybase AS IQ 12.6.
Situation - I have several tables, containing date fields:
table1(start_date, end _date, id1, id2)

For a long time I've resisted using the ANSI syntax for joins because:
1. They're VERY confusing when more than two tables are involved
2. They never seem to work
Now that SQL 2005 threatens the older, more logical syntax, I figured

From:  Dr. H. R. Arabnia
                C A L L   F O R   P A P E R S
                =============================
        The 2006 International Conference on Real-Time

I was searching in net and I can't find enough information about it:
for example I have 2 tables:
tableA (idA int PK, ...)
is in relation 1 to N with

I am studying DBMS after a gap of 11+ years. In my days we
used to program in xbase and sometime in the mid 90s came up
this idea of Database Connectivity(DBC) and Client/Server(C/S)
computing.

Sorry, the prior message was multi-posted.
Here's a cross-posted version.  Please disregard the other one.
Is there a way to create and encrypted database file?
What do people do when data security is important at the file level?  In

I'm trying to insert a string into a database and, via MySQL 4.1, write
it to a file and am having some difficulty.  Here's the SQL I use to
insert the string:
INSERT INTO some_table (some_id, some_text) VALUES (1,

Quick question. This trigger works fine (it just sets a themepark rides
status as closed when an accident has been inserted into the accident
table):
CREATE TRIGGER closeride

I have a couple of questions. If you dont know the answer could you
point me somewhere that has info on this type of basic stuff:
1.  I want to creat an assertion that states that IF A is 'yes' then B
and C are NOT NULL. (whereas if A is 'no' then null is acceptable for B

In MySQL, there are two ways to escape single quotes - \' and ''.  The
latter, unlike the former, is ANSI SQL compliant.
My question is...  on which platforms does \' work?  Does it only work
on MySQL, or does it work on others?  If it works on others, which

I need some ideas on a mySQL database design for a reservation system,
much like a doctor's office (hopefully without the long wait).
My client has 12 work areas. She wants her clients to be able to sign up
for sessions at these areas on-line. The clients will sign up for either

Dear group.
I have a problem i cannot solve myself, will appreciate any help / link
/ direction possible.
In need to add localization support and I am looking for some way to