Home > Database Management
Database Management
Database Management forum discussing non-database specific SQL. Structured Query Language was designed to be a robust and standardized language for manipulating relational databases.
Dbms free ebook navathe
HI ! can anyone plz tell me the link from where i can download the free ebook in dbms by navathe..
plz help me ,,, need it urgentlyyyy
answer(2) view(948) status(

)
answer(0) view(43) status(

)
MS Access and LIKE Operator
Please .. I've been at this for 5 hours. No joke. I'm using Perl and DBI to operate an MS Access databse. All I'm trying to do is apply the damned LIKE operator to get some records and nothing is working at all.
I want to pull results fro...
answer(6) view(423) status(

)
answer(2) view(184) status(

)
web page on a cd??
I have been asked by a client to create a web site on a cd. that is not a problem, I dont hink, but the question is, when I make the pages on the cd, is there any way to have the home page automatically open when the cd is opened??? Will ...
answer(6) view(480) status(

)
Admin: Wrong forum description
I find that the forum description for this forum isn't perfect:
"This is for general questions about databases, including non-database specific SQL, or databases that don't currently have a forum."
First of all, all the other ...
answer(1) view(806) status(

)
Calculating sales ranking
I was wondering if anyone has some ideas on this. Based on a typical products/orders model I need to figure out the sales rank for a given product. Now, I can't imagine a query that can achieve this (this is to be realized on Oracle), so th...
answer(2) view(790) status(

)
Forum info
This forum was added in response to comments made in a thread in the Lounge forum here:
http://forums.devshed.com/showthrea...1181&forumid=26
Hope you guys find it to be useful.
answer(7) view(308) status(

)
Oracle SELECT INTO OUTFILE problem
Hello, I am using Oracle and trying to output the returned query data to a TAB Delimited file. I tried using
"SELECT columns FROM tables INTO OUTFILE 'dir/filename.txt' FIELDS TERMINATED BY '\t' WHERE conditions"
But Oracle...
answer(1) view(732) status(

)
Sybase and MySQL together
Hi,
Does anyone have any idea whether or not Sybase databases can be run side by side with MySQL? The Platform is Win2000Server with IS?
Thanks!
answer(1) view(802) status(

)
Want to convert Oracle SQL to MySql SQL
Hi there,
I've created a web application. I used windows 2000, Oracle, JSP & servlets to develop the application. But the real server where I want to deploy this application is a linux based machine with MySql database. I tried to de...
answer(4) view(887) status(

)
Database Driver so ASP can read it
I am trying to access the database via java using asp..
basically the java part accessing the database rather than asp
but when I get the the function that accesses the database i get a Classnotfound exception on the class.forname("...
answer(1) view(259) status(

)
answer(1) view(594) status(

)
Try this from a past degree exam paper....!
Hi, a work collegue gave me this to try from a final year degree exam paper as a challenge. If you think you can get your head round it go for it....Its a hard one. Here goes:
Write a query that lists the names of those suppliers who h...
answer(2) view(772) status(

)
Can I run MySQL/Apache/PHP/Perl from CD ROM?
I was wondering whether I can run Can I run MySQL/Apache/PHP/Perl from CD ROM? from CD ROM?
I need to give a presentation and don't want to carry my hdd along with me. Is there a way Except hosting the files on net to display the php scrip...
answer(10) view(76) status(

)
Books on database design
I was wondering if there a few good books on database design out there, or even just some good sites that discuss database design.
Chris
answer(3) view(294) status(

)
What is ODBC?
If I sound confused I am. A friend of mine told me I can create a Access file and then upload it to my server, use an ODBC connection to work with it. We where discussing this in the light of using this method instead of using a text file w...
answer(7) view(811) status(

)
Database re-construction: Help with elementary concepts.
Hi,
I'm new to the forum, MySql and PHP. I have a database setup where a user sends his/her info in a form that is mailed to me and I use another form to copy and paste that information into the database making it viewable to the world. ...
answer(1) view(963) status(

)
combining many rows into one
Please help me figure out a solution to this problem.
I have a table in Microsoft Access that tracks the amount of money received from various companies. In some cases there is more than one amount received from the same company. Here is...
answer(1) view(562) status(

)
Comparing Files Locally & Sitewide ??
Is there a tool out there similar to cuteftp's compare ? Instead of comparing one directory, I need to compare files from my server to my local drive *site wide* throughout many directories, is this possible ???
-Dreidle
answer(4) view(565) status(

)
MS Access doesn't export numbers properly
I have a MS Access database, and am exporting it to a txt file for import to MySQl.
One of the number column with auto decimal place holds numbers with 3dp. When I export it, the preview window shows them as 3dp as well, but the actual ...
answer(0) view(245) status(

)
More Food for Thought: database vs filesystem?
See comments about Microsofts plans to incorporate SQL server into Office, so that all user data is stored in a database, instead of files and directories. (yes, some of the comments are mine)
I think it's time GUI developers thought abo...
answer(13) view(108) status(

)
DBX - SQL queried XML DBMS in PHP
Hi, and though this might seem like self propaganda, I really think people might be interested in this:
A friend of mine and I have come up with a PHP script that we call DBX, and it is a small scale Database engine.
What's cool about...
answer(0) view(806) status(

)
Database normalisation challenge.... Please help!??!?!?!
Hi,
I am struggling with my final year project and need some help on my database structure.... Please can someone help!?!?!
I am trying to build a web portal using PHP and MySQL and have sucessfully built and integrated the pages that...
answer(2) view(676) status(

)
Easiest way to make database searchable?
Anyone have an idea how I can add a search function to a website that would search an MS Access 2000 database and display the results in HTML?
I don't want to use MySQL and PHP because I know next to nothing about scripting. What I do h...
answer(1) view(175) status(

)
the best way of mass mailing on a NT box
i'd like to discuss about the best way of mass mailing on a NT box.
Last month i had to code a "monthly news" module for a community site. And we were going to send +50K mails per at oncemonth with that module.
I found out t...
answer(3) view(719) status(

)
merging records
I am trying to combine 2+ records into 1, in the same table with the same id_# but different data in different columns.
Does anyone know how to write a query to do that?
Any help is greatly appreciated.
answer(6) view(234) status(

)
Am I in the right place? (Access97/VB)
I am updating an Access97 database for a funeral directors.
They have a new entry page to book in a new funeral appointment. On this page, they currently enter the date/time and the vehicle to be used.
What they would like now is a ...
answer(0) view(59) status(

)
Some database questions from a nOOb
I was wondering if anyone knew of any opensource projects similar to NOLA? Trying to do a few things here.
1: learn MySQL and Postgres.
2: Learn PHP
3: Actually build a stable database that works the way I need it.
I am having a har...
answer(3) view(337) status(

)
Replace IDs with corresponding names
I have a small tiny problem that I was hoping someone could help me with. Its Oracle... v8
I have a list of employees. Each employee belong to one workgroup, and each workgroup belong to one department. Each workgroup has got a workgrou...
answer(3) view(851) status(

)