Tags » Primary Key

Mule and getting the generated id of a newly inserted row ...

There’s not a whole lot of documentation (that I found very clear, at least), so I thought I’d share this little Mule tidbit. In our flow, we end up inserting a single row into 2 sql server tables; the row that is inserted into the second table is linked to the first via a foreign key relationship to the primary key (auto-generated by the db) of the row we added to the first table. 318 more words


Handling Database Tables with no Primary key in Spring MVC and Hibernate

If you are building your web application in Java, you might be using Spring MVC with Hibernate. Both these Frameworks are extremely powerful and lets you, the developer to focus on building the application itself rather than to worry about many other factors required to manage and maintain the… 1,045 more words


Getting back on track and building the database

Well you would have of noticed that it has been three weeks since I have done a last blog post, there was a reason for this as I went to Australia as part of a family holiday/honeymoon and didn’t have any wifi where I was (unless you wanted to pay $90 for two weeks of it). 447 more words

Tepat Setahun

6 September 2015

Hari ini tepat setahun setelah wisuda, mendapat gelar A.Md. di belakang nama.

Dalam satu tahun ini begitu banyak karunia yang Alloh berikan. Setahun yang begitu lama tak terasa sudah dilalui. 358 more words

Primary Key

Cassandra keys : primary, composite, clustering and partitioning

When I started reading Cassandra docs, my biggest source of confusion started with all different types of keys that Cassandra has. I will give you the simplified view of all types of keys here with CQL examples. 195 more words



1. Create the primary key constraint (disabled)

alter table t1 add (
constraint t1_pk
primary key (col1))
disable primary key;

2. Create a unique index with the same name & columns as the primary key… 21 more words


Constraints in SQL

Constraints are the rules enforced on data columns on table. These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the database. 319 more words

SQL Server