Hey everyone, I'm working on a project that will let the users store their budget, and in the backbone I have a MySQL database. However, I'm not...

Alex

03-11-2007 10:25 PM
Ed Prochak

Hello Friends, I would like to know performance of Join. So give me your feedback on following two CASES. which one is good and why? Also explain me...

Mitul

03-09-2007 10:07 AM
Lennart

I've been trying all morning to figure out a way to display the number of days/months between CURDATE() and a future date (myqsl column). I've tried...

sorensong@gmail.com

03-07-2007 03:49 PM
yiata

Is there a way to quickly compare the table structures of the tables of two databases and see what's different? For example to see if the staging...

dterrors@hotmail.com

03-07-2007 10:34 AM
yiata

Thanks to all that are taking a look at this. I'm trying to create a query that will get some information from a main table as well as some...

andrewfsears@gmail.com

03-07-2007 10:11 AM
yiata

Hi, How do I manually code an atomic transaction, given the following scenario? 1. User need to pay a fine. 2. User log into the system. 3. User...

i676373@gmail.com

03-06-2007 04:11 PM
Ed Prochak

Hello! Does anyone know a good free gui tool for managing SQLite 2.x databases? The net is full of cool SQLite 3.x management tools like "SQLite...

Peteris Krumins

03-05-2007 05:21 PM
Peteris Krumins

Does anyone know of any database modeling tools for Mac OSX.

Josh

03-04-2007 09:48 PM
Josh

OASIS Symposium 2007. eBusiness and Open Standards: Understanding the Facts, Fiction, and Future. Being held 15 - 20 April at the Marriott Mission...

Symposium 2007

03-01-2007 08:48 PM
Symposium 2007

===================================================================== == CALL FOR PAPERS - * EXTENDED DEADLINE * ...

A. M. G. Solo

03-01-2007 06:07 AM
A. M. G. Solo

On Feb 27, 9:42 am, MI5Vic... (AT) mi5 (DOT) gov.uk wrote: QFT. Because they have no life -- they fail at life so they have nothing better to do...

industrial_one@hotmail.com

02-28-2007 09:46 AM
industrial_one@hotmail.com

Perhaps some kind soul could help me out with an SQL I have been trying all day to get to work, where one colum is just not summing up the way I want...

Rudolf Bargholz

02-28-2007 03:48 AM
Tonkuma

Hi I have got the requirement for the database that the fields that are search-able are not known up-front. In my mind I would need one column for...

Morten Simonsen

02-26-2007 02:41 PM
Ed Prochak

I have a very simple join which is taking nearly a minute to execute. It uses the following two tables: CREATE TABLE `candidates` ( `id` integer...

battle.chris@gmail.com

02-26-2007 11:45 AM
greg.fenton

Hi all, Can some one please help me. I need to access this database (I have been told it's database) but I don't know how? It's coming from machine...

hasu

02-24-2007 07:24 PM
Lemming

Hi All, I have a few SQL backups restored from a set of backup files. The backup files have been removed from the drive because of some...

Query Builder

02-24-2007 07:11 PM
Lemming

Hello, let's say at table has columns A, B and C and I do: SELECT A, B, COUNT(*) FROM TABLE GROUP BY A, B so, we know that each result "record"...

metaperl

02-24-2007 10:17 AM
Tonkuma

Powered by J2EE, BIRT, Jasper, Spring Yellowfin International is proud to announce that MYstaff, a web based business solution for managing...

YellowfinTeam

02-22-2007 01:48 AM
YellowfinTeam

Anyone please tell me what is SUPER KEY and how it is differentiated from other keys like Candidate Keys and Minimal Keys.

Salman

02-21-2007 03:54 PM
Ed Prochak

Anyone please tell me what is SUPER KEY and how it is differentiated from Candidate Keys and Minimal Keys.

Salman

02-21-2007 03:23 PM
Salman

Extended Call for Papers Extended Submission Date: March 9, 2007 The 2007 International Conference on Communications in Computing:...

dauriol@oslab.khu.ac.kr

02-21-2007 04:41 AM
dauriol@oslab.khu.ac.kr

www.gcn.com/print/26_04/43146-1.html With about 10 months until the congressionally mandated deadline to put all federal contract and grant spending...

admin@neobasic.biz

02-21-2007 04:04 AM
admin@neobasic.biz

" sorry if this is off post ...will be my last" Thx in advance for your help and interest. i am an independant oil and gas consultant and have a...

Jerry in Oklahoma

02-19-2007 07:13 AM
strawberry

Hello, my database is not very big so I want to adopt this backup strategy: each 1 hour I want to clone the whole database 'mydatabase' to...

filippo

02-16-2007 05:45 PM
Gene Wirchenko

Hi Could the experts here point me to books or web links that show how one could use C# to connect to TimesTen database ? Or any workarounds to...

zw

02-16-2007 04:13 PM
zw

Hello, I don't use graphical tools during development. My current customer wishes graphical models. So I'd like to have a tool which can reverse...

Andreas Thiele

02-16-2007 01:03 PM
greg.fenton

mysql in c++ initialize error occurs a simple program is executed in redhat9.0 , using gcc 3.2.2 compiler version ... #include <stdio.h> #include...

yogesh

02-16-2007 12:59 PM
greg.fenton

Thanks to all that are taking a look at this. I'm trying to create a query that will get some information from a main table as well as some...

andrewfsears@gmail.com

02-14-2007 06:48 PM
andrewfsears@gmail.com

Suppose a database server - say MySQL, though I'd be interested in answers to my question for other systems too - and client are separated by a low...

Russell Wallace

02-14-2007 11:12 AM
Ed Prochak

Dear all, I have a question about a query I would improve (I know it is not the best). I have two tables: USER: DATA: I think they are quiet self...

Libra

02-12-2007 11:26 AM
--CELKO--

CONFERENCE PROGRAM AND KEYNOTE PRESENTERS HAVE JUST BEEN ANNOUNCED FOR OPEN PUBLISH...

Open Publish 2007

02-12-2007 11:00 AM
Open Publish 2007

Dear all. I believe this conference is appropriate for this community, especially for those whose research crosses communications with systems...

dauriol@oslab.khu.ac.kr

02-12-2007 03:14 AM
dauriol@oslab.khu.ac.kr

Hi everybody, I'm a designer with some basic database knowledge but I would like some suggestions on a database design problem that's really too...

Marco Q.

02-09-2007 05:52 AM
Marco Q.

Hi, I'm trying to write a java.sql.Date to a database and the minutes/ seconds etc. are not being written. I've seen and tested many examples found...

ddog

02-08-2007 08:21 PM
Lew

ddog wrote: You multi-posted this one to comp.databases as "Re: java.sql.Date value truncated using JDBC in MS-SQL Server". Follow-up set to cljp....

Lew

02-08-2007 08:21 PM
Lew

Hello. On April 1, 2007, a new concept in Computer Support will be rolled out across the United States and Europe. We believe that PC-VIP will...

PC-VIP

02-08-2007 11:58 AM
greg.fenton

Apologies for cross-postings. Please send to interested colleagues and students -- CALL FOR PAPERS - Deadline for submissions: 26 February 2007...

natty2006@gmail.com

02-08-2007 06:56 AM
natty2006@gmail.com

Hi All, I am trying to load my java classes into sybase 12.5.2. when I compile with target 1.1 it works. I need to work with jre 1.4. how can I...

DBArtisan

02-06-2007 02:20 PM
greg.fenton

I'm a somewhat educated newbie in advanced MySQL queries. I'm attempting to create a variety of "top 10" lists related to a database of meteorology...

PWX

02-05-2007 09:09 PM
PWX

NOTE: The deadline for draft paper submission is extended until February 12 2007, due to requests from many authors. www.PromoteResearch.org The...

john

02-05-2007 04:06 PM
john

Hi, I modeled a schema for a RDBMS but I am somewhat unsure it the modeling was right. The problems I ran into are that working with my...

Hilmar

02-05-2007 05:48 AM
Axel Hallez

Let's say I have a lil ole table like this: animal amount cat 12 dog 4 horse 90000 and let's say I want an output table that...

metaperl

02-04-2007 03:42 AM
Lennart

Hi everybody, the MonetDB team at CWI, The Netherlands is proud to announce a major release of its high-performance open-source XML database...

Martin.Kersten@cwi.nl

02-02-2007 05:56 PM
Martin.Kersten@cwi.nl

Does anyone know of a good data modeling mapping tool that integrates with CA's ERwin. I am looking for a tool that would define the sources and its...

todd.l.thompson@gmail.com

01-31-2007 01:44 PM
todd.l.thompson@gmail.com

One column in the base table and two columns in a VIEW. This ensures data integrity

--CELKO--

01-30-2007 04:42 PM
--CELKO--

I have a fast P4 Linux server with 2GB mem and yet running a simply SELECT such as: select part_number FROM catalog WHERE part_number LIKE 'HH%' on...

News

01-27-2007 04:35 PM
Paul

Hi, I need a very simple and lightweight 'database' that has to run in windows 2003, and i need to interface it with my own applications (written in...

Niel Darren

01-27-2007 04:31 PM
Paul

Suppose Adam has children named John(male), Jack(male) and Mary(female). What schema/query finds John's brothers and sisters based only on direct...

Neo

01-27-2007 04:27 PM
Paul

We currently use Sybase and DB Artisan (8.12) from Embarcadero on a PC runing Windows DB Artisan is overkill for my needs, as all I need is: 1 -...

usawargamer@yahoo.com

01-26-2007 02:51 PM
AlterEgo

Hi, I have received the following email from a colleague, and am quite frankly baffled by the idea. I am just wondering if anyone has any advice or...

DaFrizzler

01-24-2007 11:13 PM
Lew