» Home » tables » Page 1
Join two tables and get newest entry in two tables depends on the updated date of two tables in MySQL
by compcons in Databases

I have fixedassets and fixedassets_history tables.


In the fixedassets table, there are id, purchase_date, purchase_price, updated_date.


In fixedassets_history table, there are fixedassets_id, description, updated_date.


<

Django: Setting up database code tables (aka reference tables, domain tables)?
by codelurker in Development Tools & Services

Often times applications will need some database code tables (aka reference tables or domain tables or lookup tables). Suppose I have a model class called Status with a field called name that could hold values like:


Canceled
Pending
InProgress
Complete

Where and at what point would I setup these values in Django? Its like a one time operation


How to create a DB that holds all my tables (tables from ASPNETDB and my other tables)?
by robvp in Programming Languages

The way I understood it, a project being developed in VWD 2008 Express, unlike in the VS2008, can only access one DB. So, I guess I need absolutely to locate all my tables in a unique DB. By tables, I mean: tables I create for my application as well as the default ones created by the framework (ASPNETDB).


Here's my connection string (Do I need to modify it????)


<co

Merge tables by inserting null values for columns where no value can be derived from the merging tables?
by redblacktree in Databases

I have two different tables and i decided to merge them into one table...


the birth table has


id, name, country, birthday_date,
description, link


the death table has


id, name, country, death_date,
description, link


and i want to merge them into a single table with the structure


id, name, country, bdate,


MySQL: UPDATE query joining 3 tables runs long (15M row tables, indexed)
by Shantanu in Databases

I have 15M rows in 3 tables (one table is the original CSV import, the other two are normalized versions of that CSV + some other data).


I need to simply update one field from the original CSV table. The update query joining these tables has now run for 30 hours on my quad-core-8GB-ssd box.


Is this normal? Is there a better way to perform this simple update?
Tab

I need to create a view that unions all tables based on their prefix (new tables added monthly)
by kamyar in Databases

The integration software that my client is using is pulling over ISAM files from a RMS system and creating lots of tables that all have identical schemas, but nonetheless the software they use doesn't support merging them together.


Here's some example table names:


SOME_TABLE_XYZ_2012OCT
SOME_TABLE_ABC_2012OCT
SOME_TABLE_LMN_2012OCT
SOME_TABLE_XYZ_2012NOV
MySQL Get latest record by date from mutiple tables with values from lookup tables
by tayles in Coding

I want to get the latest MainNumber, Serial, BarType and Notes for a given MainNumber, if they exist. Note that BarType is stored in a lookup table and referenced with BarID.


Unreason came up with this:


SELECT @MainNumber, COALESCE(n.Notes, 'None')
FROM numbers
LEFT JOIN notes n ON numbers.MainNumber = n.MainNumber
LEFT JOIN note

How do I Convert Work Tables to Conference Room Tables by Adding a Wood Table Top?
by FuzzyHornet in Business
You can create a table in almost any size and shape by simply using a solid base and placing a wood table top over it. The base you use should be sturdy and big enough to support the weight of the table top, but not so big that a person would hit his knees on it when he pulls up a chair. Find two old desks in your office and a wooden table top. You will have an attractive and impressive-looking co

MySQL joins of small tables with huge tables in complex query - how consuming they are?
by Pug in Databases

Let's suppose that database is big. I have a very complex query for search results page. In the below query, you can see that I retrieve from user_profile table some attribute value ids, the education is one attribute for example. When I have value id for attribute education, I retrieve label name for this id from array (php code) where id is array key.


public static $education

ORACLE: can we create global temp tables or any tables in stored proc?
by mikko in Databases

below is the stored proc I wrote:


create or replace procedure test005
as
begin
CREATE GLOBAL TEMPORARY TABLE TEMP_TRAN
(
COL1 NUMBER(9),
COL2 VARCHAR2(30),
COL3 DATE
) ON COMMIT PRESERVE ROWS
/
INSERT INTO TEMP_TRAN VALUES(1,'D',sysdate);
INSERT INTO TEMP_TRAN VALUES(2,'I',sysdate);
INSERT INTO TEMP_TRAN VALUES(3

Next
Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .