|
My requirement is to update the description field in table 1 with the description of the table 2 and 3 by concatinating. I'll give you the structure below.
table1 --P A D table2 --- P D table3 --- A D
table D with concatinating The table2 D and table3...
Started by Prem on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Astander, In the first table i have 3 fields where descr is empty for all the rows as you mentioned above.
No common field between.
The other two fields, one is in 2 table and other is for the third table.
|
|
I recently joined a new company and the development team was in the progress of a project to rebuild the database categories structure as follows:
if we have category and subcategory for items, like food category and italian food category in food category...
Started by Rima on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Is that it allows for table....
With good indices, that need_italian...
DBA's that does not know how to performance-tune a database, and seems to think that a table with less rows will always vastly outperform a table with more rows.
|
|
I would like to log changes made to all fields in a table to another table. This will be used to keep a history of all the changes made to that table (Your basic change log table).
What is the best way to do it in SQL Server 2005?
I am going to assume...
Started by Gerhard Weiss on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You can use fields, as the output is generated....
As a side note, this is an extremely easy way of capturing the value of an identity field.
Do whatever you want with the #TempTable, such as inserting those records into a logging table.
|
Ask your Facebook Friends
|
In mysql I can write
show fields from <table>;
What is the closest equivalent in Oracle SQL?
Started by spig on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Hi spig,
in Oracle you will query the dictionary views to get info on the schema objects:
SELECT * FROM all_tables WHERE table_name = 'MY_TABLE';
alternatively in SQL*Plus you could:
DESC my_table....
Use DESCRIBE table.
|
|
Hi i want to know that how the auto increment id can be get from the mysql db for two fields in a table
Started by balu on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Using PHP: Two ways....
If you try and create two you'll get:
Incorrect table definition; there can be only one auto column and it must be defined as a key a field value.
In MySQL you're only allowed 1 auto_increment column per table.
|
|
How to search all fields in a table in django using filter clause ex:table.object.filter(any field in the table="sumthing")
Thanks.
Started by Hulk on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Import CharField from django.db.models import Q fields = [f for f in table._meta.fields if isinstance(f, CharField)] queries = [Q(**{f.name: SEARCH_TERM}) for f in fields] qs = Q() for query.
|
|
Hello,
I am designing a system for a client, where he is able to create data forms for various products he sales him self. The number of fields he will be using will not be more than 600-700 (worst case scenario). As it looks like he will probably be ...
Started by Spiros on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
There are other issues in normalisation table design without....
You need to analyze your potential table structures to ensure that each field contains no more than", "Phone2", "Phone3", you'd break that data into its own table.
|
|
I'll try to explain my case as good as i can. I'm making a website where you can find topics by browsing their tags. Nothing strange there. I'm having tricky time with some of the queries though. They might be easy for you, my mind is pretty messed up...
Started by finpingvin on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
AND `tags`.`tag` NOT IN ('tag1', 'tag2', 'tag3')
Select a.topic_id from join_table a where exists( select * from join_table b where a.tag_id = b.tag_id and b.topic_id = selected_topic ) group by a.topic_id having count(*) = ( select count....
|
|
In a DB I'm designing, there's one fairly central table representing something that's been sold or is for sale. It distinguishes between personal sales (like eBay) and sales from a proper company. This means there is literally 1 or two fields which are...
Started by John on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
There are 1,000,000 rows, the average row size is 20 bytes, the split fieldI think the choice of having these fields is not going to hurt you today and would be the choice to refactor to 2 separate tables....
Scenarios:
Split fields.
|
|
I have a table in my SQLServer 2000 database that has in my opinion been poorly designed.
It has a large number of fields in it and needs refactoring. However until I can do this I have other projects going on and one them requires a relationship with...
Started by John Nolan on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
Another....
If some part of the table deals with settings, make it a settings table.
Not all of the 130 fields are identified by the primary key, then adding a new field to this table the fields by their united use.
|
