I am trying to obtain the primary key of a table from a MySQL database. When I use the MySQL ODBC 3.51 Driver, the code below works fine. When I change the code to use MySQL ODBC 5.2 ANSI Driver, it ...

I understand that the InnoDB engine relies heavily on primary keys for its storage mechanisms (index layouts, etc), and that it is consequently a bad idea to use a non-sequential primary key (say a ...

I have a MySQL Master(v. 5.1.56-ndb-7.1.18-cluster-gpl-log) - 2 Slaves(both v. 5.1.51-community) system setup and has been running for several years. It was originally intended to be a cluster which ...

I have a problem with the naming of some primary keys in the database. On my development system the primary key constraints are named PK_FullTableName. Now on a production system the constraints are ...

Currently we have tables that has type 4 UUID(random) as primary key.
Our application layer does a batch insert into DB.
But still since the primary key is random, this will result in multiple disk ...

I have a database with Stored procedures, and i used Ado.Net Entity Data Modell and Ado.Net DBContext generator. After this part i've got error: "no primery key".
I modify in .edmx file in entityset ...

Looked in many places and found that the hibernate with postgresql can use an IDENTITY primary key generator which maps into serial/bigserial table column. Suppose i have follow entity:
@Entity
class ...

My workplace doesn't use identity columns or GUIDs for primary keys. Instead, we retrieve "next IDs" from a table as needed, and increment the value for each insert.
Unfortunatly for me, LINQ-TO-SQL ...

We are currently using the method below which depends upon IObjectContextAdapter in an abstract Repository. From what I'm reading, it appears that anything related to ObjectContext is being chopped ...

I habe two tables which are have a manytomany relation via a join table. Entity L is the "Main" entity
The problem is that EclipseLink dosen't set the primary key in the join table when there are new ...

I am new to Apache Derby so this question may seem remedial but I am trying to find a way to write a select statement from the ij prompt that will show all of the fields along with their data types, ...

Hy!
I have the following stupid question?
First an example to understand my point of view.
I have a mysql db, Innodb tables with foreign keys between them,
I currently work on a localhost machine
When ...

I have created the schema with Workbench 6.1 (and MySQL 5.6) and it outputs the code below. But this produces a foreign key constraint. Last time it worked but produced a composite primary key made of ...

I would like to initialize the primary key (based on certain validations) of a table at restart of mysql. Is there any event at mysql restart. The idea is to execute a TRIGGER after a mysql restart. ...

I am exporting data from a .csv file. The file contains a sports player attributes e.g catching, throwing, jumping. Each sports player can have more than one attribute so i need to set up a unique ID ...

I've created a second table that I want to copy data from a first table to.
table2 has the same structure as table1, only some of it's columns are COLLATE NOCASE. Apart from that and the table names, ...

I am using DBVisualiser to execute SQL commands against a Derby database. I am however having an issue with the DESC command.
I want to create a primary key with a descending sort order rather than ...

When you use federations in SQL Azure do you have to have the tenantid as part of the primary key on every table? That would mean that all tables except maybe one tenant table would all have composite ...

I've just found some very strange behaviour after adding a Primary Key to a table. Before creating the key, there were 6,672 rows in the table. After creating the key, there were 103. However if the ...

We have a JDE (JD Edwards) system on an AS400 DB2 database. There is a Showcase server running queries to create several tables (.dbf). These queries run at different time during the day and night to ...

I am creating an application with Spring Roo. When I do a reverse engineer on a database table everything looks great but there are no fields for the primary keys, which are in the database. These are ...

I am creating a social networking site that will be open to the general public and will expected to host a large number of users. The information of each user will be stored in a MySQL database, and ...