| Thread | Last Post | Replies |
|
| mysql query | 30 Apr 2006 11:57 GMT | 2 |
need help My english is not good so ill be short. This is my database in mysql create table customers
|
| Database Design: fast access to transaction history | 29 Apr 2006 23:42 GMT | 6 |
I'm working on a project with information in many different tables in a database. We have tables like: Customers, CustomerTypes, Games, GameTypes, Events, EventTypes, EventSubTypes ... etc.
|
| Sorting just the resulting table in MySQL | 27 Apr 2006 16:38 GMT | 4 |
I am using PHP and MySQL. Suppose I have a table named "servicios" with 5 columns and 200 rows. If I want to get the whole table sorted by column 3 (suppose the field name is "nf") I use:
|
| E*Trade's database systems? | 26 Apr 2006 09:50 GMT | 1 |
Does anyone know what database vendor and middleware vendors are used at E*Trade? Does anyone know if E*Trade's IT functions are outsourced? And if so, to whom?
|
| Best way to keep songs in a DB | 24 Apr 2006 12:07 GMT | 9 |
What's the bets route to go for placing a large collection of mp3's into a DB? Each song will be linked to a particular user... Would you put all songs in one table? Or make multiple tables based on genre? Or maybe dynamically make a songs table for each user as needed?
|
| My Tricky Query | 23 Apr 2006 05:24 GMT | 2 |
I'm having trouble designing and efficient query in mssql and asp. Tables: Stockdata (id, companyID, date, price) Company(id, name, category)
|
| Cloudscape - usage of? | 22 Apr 2006 17:08 GMT | 5 |
Anyone using Cloudscape in production? Is it a viable platform or are IBM just dreaming?
|
| Splitting a column in a csv file | 22 Apr 2006 16:49 GMT | 6 |
I've tried to find information on this and also tried different csv file editors without luck. My problem is how can I break a column with a date 01122006 into three new columns DAY 01 MONTH 12 YEAR 2006?
|
| LIttle query help | 22 Apr 2006 15:53 GMT | 8 |
I am potentially building a music listening site and want the users to be able to place songs into their favorites list. Easy enough, stick the id of the song, from the songs table, into the users favorites. From this however, how would I go about selecting the songs that are ...
|
| Embedded database | 21 Apr 2006 20:46 GMT | 3 |
I need a *very* fast database for use with a dotnet 2 compact framework application. My requirements are 1) I need to be able to have the following table structure InstacedId (string or Guid + unique index)
|
| webserver asp | 19 Apr 2006 21:53 GMT | 1 |
io di solito ho fatto qualche cosa in php in locale... ora però ho dei file in Asp e devo creare un webserver in locale x leggere queste pagine... come posso fare? ke programma devo utilizzare?
|
| INTERVAL question | 19 Apr 2006 20:09 GMT | 13 |
I have a Transaction table using MySQL 4.0: Id (key), CustomerName, CreationTime (datetime). If the customer create a transaction, I consider that account is active. So how to get the number of customers that are 1 day active (at
|
| Performance/design query | 18 Apr 2006 15:55 GMT | 2 |
I have an existing database table (MEMBER_DATA) which contains general data related to a member in my application. I have a new requirement to persist certain 'exit' data when the member exits the group that he is currently subscribed to (i.e. the user is no
|
| A (hopefully simple) SQL DB design problem | 17 Apr 2006 03:57 GMT | 4 |
I'm pretty much a total newbie to DB design. I have a problem that is something like the following: I need to create a database of pet owners. For each pet owner, I can create a table with a unique id (int not null primary key in SQL parlance), the
|
| MySQL: 32bit C-style time_t value | 16 Apr 2006 19:40 GMT | 3 |
I have a table with a "Date" column, which is a 32 bit C-style time_t value, meaning the date when the value was relevant. The data are stored at a 1-hour granularity. So all the Date are multiples of 3600 (seconds per hour), for example, 1019782800, 1019782800, 1019786400.
|