primary-key

SQL Server add primary key

I have a table that needs to be given a new primary key, as my predecesor used a varchar(8) row as the primary key, and we are having problems with it now. I know how to add the primary key, but am not sure of the correct way to add this new primary key to other tables that have the foreign key. Here is what I have: users table: old...

How do I update my primary key in MySQL?

Ok, this is probably really simple, but I just can't figure it out. I have a primary key in a table that goes from 1-5,000. I need to manually update that id (for other table update purposes) so that it says 5,000-10,000. Can't I manually update this column? Please help!!! Thank you ...

Rename INDEX Column

Hey All I have a database with around 40 tables and need to rename every index column. IE USER a table has a bunch of fields like user_id | user_username | user_password | etc... I want to rename the ID columns just to id ie id | user_username | user_password | etc... But I keep getting mysql errors on the alter table command ie....

PHP/MYSQL Trouble Selecting by Primary Key

Hi all, So I have a primary key column called key. I'm trying to select the row with key = 1 via this code: $query ="SELECT * FROM Bowlers WHERE key = '1'"; $result = mysql_query($query) or die(mysql_error()); For some reason, I'm getting this result: You have an error in your SQL syntax; check the manual that corresponds to your...

PHP/MYSQL Different Trouble Selecting By Primary Key:

Due to some help from a recent post, I'm selecting a row by primary key, as follows: $query ="SELECT * FROM Bowlers WHERE 'key' = '1'"; $result = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_assoc($result)or die(mysql_error()); For some reason, the third line of code dies every time, without error. It works fine usin...

Would showing primary key to the public be potential security risk?

Well the question is self-explanatory. One more thing would be, if it is a security risk then please provide an example of what the user could do. In this case the primary key would be something like : "Product ID" Thanks! ...

php and mysql primary key question

Hi All, I have one simple table. the primary key column name is id. I have almost 200 records and some how i deleted some of the records. Now the id column has following entries 1 2 4 5 6 8 9 Can any body tell me what query can I write that return me all the missing rows? For example 3,7 rows in above example. Or any php funtion that ...

How to retrieve Google Appengine Objects by id (Long value) ?

Hi, i have declared an entity the following way: public class MyEntity { @PrimaryKey @Persistent(valueStrategy = IdGeneratorStrategy.IDENTITY) private Long id; @Persistent private String text; //getters and setters } Now I want to retrieve the objects using the id. I tried to manage it from the Google Appengine Data Vie...

sql insert error

This is my Insert Statement INSERT INTO ProductStore (ProductID, StoreID, CreatedOn) (SELECT DISTINCT(ProductId), 1, GETDATE() FROM ProductCategory WHERE EXISTS (SELECT StoreID, EntityID FROM EntityStore WHERE EntityType = 'Category' AND ProductCategory.CategoryID = EntityStore.EntityID AND StoreID = 1)) I am trying to Insert into tab...

What is the difference b/w Primary Key and Unique Key

I tried to find it out in google but not satisfactory answer is given out there.Can anybody explain the solid difference. actually if Primary key is used to select data uniquely then what is the need of Unique key? when should I use a Primary key and when to use a Unique key? ...

Foreign keys and pagination

This is my pagination script: <?php /*********************************** * PhpMyCoder Paginator * * Created By PhpMyCoder * * 2010 PhpMyCoder * * ------------------------------- * * You may use this code as long * * as this notice stays intact and * * the proper credit is given to * *...

How to create an entity with a composite primary key containing a generated value.

Using Hibernate + annotations, I'm trying to do the following: Two entities, Entity1 and Entity2. Entity1 contains a simple generated value primary key. Entity2 primary key is composed by a simple generated value + the id of entity one (with a many to one relationship) Unfortunately, I can't make it work. Here is an excerpt of the ...

Multiple keys/indeces/constraints when joining three tables

I'm getting more and more confused as I try to distinguish from the ambiguities of these terms. I have a query that is taking longer than necessary simply because I cannot get the key on on table to work for the other joins. I have only one column that is "Unique" in t1, there are others which are 73.8% unique and I cannot figure out h...

MySQL: updating a row and deleting the original in case it becomes a duplicate

I have a simple table made up of two columns: col_A and col_B. The primary key is defined over both. I need to update some rows and assign to col_A values that may generate duplicates, for example: UPDATE `table` SET `col_A` = 66 WHERE `col_A` = 70 This statement sometimes yields a duplicate key error. I don't want to simply ignore...

Getting id of row just inserted into MySQL database

I have my table columns set like this: likes(id, like_message, timestamp) id is the primary key that is auto incrementing. This is the SQL that I use to add a row: $sql = "INSERT INTO `likes` (like_message, timestamp) VALUES ('$likeMsg', $timeStamp)"; Everything works, but now I need to throw back the id attribute of the ne...

Datanucleus JDO Retrieve newly generated primary key

I am using datanucleus and jdo in a GWT project. How can I retrieve the generated primary key after adding an element to the database with makePersistent() Edit We use annotations, here is the primary key: @PrimaryKey @Column(name = "id_bla", allowsNull = "false") @Persistent(valueStrategy = IdGeneratorStrategy.IDENTITY, extensions...

Deadlock in SQL Server 2005! Two real-time bulk upserts are fighting. WHY?

Here's the scenario: I've got a table called MarketDataCurrent (MDC) that has live updating stock prices. I've got one process called 'LiveFeed' which reads prices streaming from the wire, queues up inserts, and uses a 'bulk upload to temp table then insert/update to MDC table.' (BulkUpsert) I've got another process which then rea...

Violation of primary key constraint, multiple users

Lets say UserA and UserB both have an application open and are working with the same type of data. UserA inserts a record into the table with value 10 (PrimaryKey='A'), UserB does not currently see the value UserA entered and attempts to insert a new value of 20 (PrimaryKey='A'). What I wanted in this situation was a DBConcurrencyExcep...

2-column table with two foreign keys. Performance/design question.

Hello everyone! I recently ran into a quite complex problem and after looking around a lot I couldn't find a solution to it. I've found answers to my questions many times before on stackoverflow.com, so I decided to post here. So I'm making a user/group managment system for a web-based project, and I'm storing all related data into a p...

Android: Text primary key with different name

I have an existing Windows app for which I'm writing an Android port. The app uses a unique string as the primary key, but the SQLite methods in Android all seem to work with integers and a column names _id, whereas my ID column isn't called this. Is there a way to let Android know I have a key with a different column name? ...