Search Results

Search found 8603 results on 345 pages for 'altering tables'.

Page 163/345 | < Previous Page | 159 160 161 162 163 164 165 166 167 168 169 170  | Next Page >

• When to use which mysql partitioning model

  - by Industrial

  Ok guys, just starting out with partitioning some tables in mySQL. There's a couple of different ways describing this, but what I cant find is a more practical approach. - Which type of data does each way of partitioning have the best effect on? Or doesn't it really matter?

  Read the article

• mysql query for getting all messages that belong to user's contacts

  - by aharon

  So I have a database that is setup sort of like this (simplified, and in terms of the tables, all are InnoDBs): Users: contains based user authentication information (uid, username, encrypted password, et cetera) Contacts: contains two rows per relationship that exists between users as (uid1, uid2), (uid2, uid1) to allow for a good 1:1 relationship (must be mutual) between users Messages: has messages that consist of a blob, owner-id, message-id (auto_increment) So my question is, what's the best MySQL query to get all messages that belong to all the contacts of a specific user? Is there an efficient way to do this?

  Read the article

• Setting SQL Relationships For LINQ Queries

  - by Soo

  I have two tables that I'm trying to create a relationship between so I can write nice LINQ queries that don't require join. Widgets WidgetId WidgetDescription Orders OrderId WidgetId OrderDate What I want to be able to do is create a LINQ query that does something similar to: var result = from x in db.Widgets Where x.Orders.OrderDate == "5/11/2010" select x; I can't seem to get intellitext to pick up the other database despite creating a relationship in SQL server. Are there any additional steps I need to take to make this work?

  Read the article

• Auto Generate Objects in DBIx::Class ORM in Perl

  - by Sam

  Hello, I started learning DBIx::class and I reach the point where you have to create the Objects that represents tables. Should this classes be created manually ( hard coding all the fields and relationships.....) or there is a way to generate them automatically using the database schema. I read something about loaders, but i did not know where they are really used. Please advice. Thanks

  Read the article

• Db2 sql dump tools

  - by adisembiring

  I am searching for tools to dump db2 tables (like sqlyog or MySQL browser in MySQL). Can you suggest me some? Thanks

  Read the article

• Replacing ORM schema without dropping the entire data

  - by Udi

  Hey, I'm using OpenJPA as a JPA provider. Is there a way in which I can recreate the database tables (When an entity changes) without dropping the entire data? When an entity changes, I drop and create every table in the store, and obviously lose the data within. Is there a tool or product to keep the data somehow? Thanks, Udi

  Read the article

• Convert a Delphi example using TDatabase and local paradox table to server storage

  - by Brian Frost

  I am looking at the Developer Express Quantum Grid example 'IssueList' which is a useful bug reporting and tracking application that's almost ready to go out of the box. It uses a TDatabase component with several paradox (.db) tables. Is it simple to rejig the TDatabase settings to use a database on a shared machine so that several of us can access it together across the network? If so, what would be the steps needed please?

  Read the article

• pyamf flex google app engine

  - by mydiscogr

  Hi to all, I've just made a little server amf on gae and pyAmf ( now down?). Well I've also made a client in flex 4 and all works well. Now I'd like to add an authentication method, and I know that there a method in flex to authenticate using RemoteObject.setCredentials(username:String, password:String, charset:String = null):void Now I don't understand how use this in client side and server side, where register user, should I create user tables? there's a book what is the way to use AMF with flex? thanks

  Read the article

• What sort of Circular Dependencies does Oracle allow?

  - by Neil

  Hi all, I am creating test cases and I need to cover circular dependencies. So far I have been able to create two tables such that Table A has a FK to B and B has a FK to A. What other circular dependencies exist / are allowed between objects? I tried to create cycles between Views but Oracle successfully rejected that.

  Read the article

• Sql query listing Fathers and childs with joins, how to distinct them?

  - by DaNieL

  Having those tables: table_n1: | t1_id | t1_name | | 1 | foo | table_n2: | t2_id | t1_id | t2_name | | 1 | 1 | bar | I need a query that gives me two result: | names | | foo | | foo / bar | But i cant figure out the right way. I wrote this one: SELECT CONCAT_WS(' / ', table_n1.t1_name, table_n2.t2_name) AS names FROM table_n1 LEFT JOIN table_n2 ON table_n2.t1_id = table_n1.t1_id that works for an half: this only return the 2° row (in the example above): | names | | foo - bar | This query return the 'father' (table_n1) name only when it doesnt have 'childs' (table_n2). How can i fix it?

  Read the article

• How to backup MySQL database?

  - by mouthpiec

  Is there a way to backup an MySQL database so that if something wrong occurs, it will be easy to recreate the tables with the same data?

  Read the article

• PL SQL Where Clause with Column/Field name being a datatype

  - by Dale

  Quick question playing with PL SQL it seems that the tables column was named as the data type NUMBER so trying to perform a query fails since the column is being recognized as a datatype instead of a column name. Anyone know how to get around this without modifying the schema?

  Read the article

• MySQL Workbench - How to synchronize the EER Diagram

  - by Tiago Alves

  I am creating a visual representation of my existing database with MySQL Workbench and I am able to synchronize the models with the "Database - Synchronize Model..." menu. However, every time I synchronize (update) my model, I have to recreate the EER Diagram and rearrange all the tables. Is there a way to update or synchronize the EER Diagram as well? Thanks.

  Read the article

• What is best tool to compare two SQL Server databases (schema and data)?

  - by tomaszs

  I would like to compare two SQL Server databases including schema (table structure) and data in tables too. What is best tool to do this?

  Read the article

• ideas for a distributed cache proxy server

  - by Neeraj

  Hi everyone! I am implementing, a distributed cache proxy server.I have an idea of the HTTP and related stuff, so i am rather concentrating on the sub part "Distributed data storage". From some search on web i found that this could be done using Distributed Hash Tables(DHT). I was wondering if there exists some kind of library for this preferably in C/C++. Any better suggestions for the same will also be appreciated.

  Read the article

• How to look stored value in CoreData ?

  - by Meko

  Hi.I am new on iphone development and I have problem with CoreData. I hardly made to sore value in CoreData but How can I look those value like in MySql WorkBench you can see the tables ad also values.In CoreData am I have chance like that?

  Read the article

• How do I map common properties in NHibernate

  - by Ian Oakes

  In the database I'm working with, every table repeats the same nine columns and I don't want to have to supply the same properties in each of my entities to map these columns. I've tried adding properties to a common base class and adding them to the sub class's mapping file, but this doesn't work. I've read the documentation around inheritance mapping but this did not help. What is the best way to map columns that repeat accross multiple tables in NHibernate?

  Read the article

• SQL storing data about columns

  - by Chris

  I'm learning SQL Server Compact for a program I'm writing that requries a local database. I have multiple tables, each with different columns and I'd like to mark each column as being a certain type (not a data type, just an integer tag) to let the program know what to do with it. I'm clueless about SQL. How does one do this?

  Read the article

• Datamodel diagram-software

  - by megala

  I have nearly 20 tables.I want to draw datamodel diagram for this table.But it take more time.Is it possible to draw the diagram using any datamodel software.My constraint is i give dataonly it draw the diagram automatically,please suggest any softwsre related to my constraints

  Read the article

• Row rendering in Qooxdoo

  - by user311167

  Hi, I am trying to display rows of my tables in different colors . Please help me to achieve this. Please provide sample code to do same. Thanks. Regards, vyankatesh

  Read the article

• MySQL UPDATE problem

  - by comma

  I know the following MySQL code is not correct can some help me fix this code to use both tables I'm trying to grab the id from learned_skills and skill_id from users_skills for AND skill_id = id Here is the MySQL code. SELECT learned_skills.*, users_skills.* UPDATE learned_skills SET skill = '$skill', experience = '$experience', years = '$years' WHERE user_id = '$user_id' AND skill_id = id

  Read the article

• SQL View Creation

  - by george9170

  I have two tables Table FOO FooUniqueID| Year| Name| Worth| --------------------------- 1 2008 Bob 23.00 2 2009 Bob 40200 Table Bar BarUniqueID | Name | Value ----------------------- 1aBc Year 2009 I would like to create a view. That will select everything from FOO where the Year is equal select value from Bar where name = year without using a sub query. thank you

  Read the article

• Queries with Multiple Constraints

  - by ANITHA

  I have the following tables and fields: +------------------+ +-------------------+ +---------------+ | Request | | RequestItem | | Item | +------------------+ +-------------------+ +---------------+ | + Requester_Name | | + Request_No | | + Item | +------------------+ +-------------------+ +---------------+ | + Request_No | | + Item | +------------------+ +-------------------+ I would like to filter the items which are selected under a particular request number, along with a specific requester name. How might I go about doing this?

  Read the article

• How to SQL compare columns when one has accented chars?

  - by Pentium10

  I have two SQLite tables, that I would love to join them on a name column. This column contains accented characters, so I am wondering how can I compare them for join. I would like the accents dropped for the comparison to work.

  Read the article

• Object Oriented Database - why most of the companies do not use them

  - by GigaPr

  Hi, I am pretty new to programming(just finished University). I have been thought in the last 4 years about Object Oriented development and the numerous advantages of this approach. My question is Isn't it easier to use a pure Object Oriented database in development applications? Why Object Oriented database are not as much diffuse as relational? From my point of view makes sense to use OO database, the latter will avoid the numerous construction necessary for the mapping of complex objects on the tables.

  Read the article

< Previous Page | 159 160 161 162 163 164 165 166 167 168 169 170  | Next Page >