There is a field "num", which is the primary key of the underlying table.The Grid View's Data Key Names field is also set to "num". Now, I would like to let the users change the primary key field.But behind the scenes, Cassandra processes the second statement by deleting the entire collection and replacing it with a new collection containing three entries.
4) ask your DBA why he or she would ever use as a primary key data that might need to be changed. maybe you should not ask this question)Sorry I have not been watching this forum.CREATE TABLE mytable (a int, b int, s int static, d text, PRIMARY KEY (a, b)) BEGIN BATCH INSERT INTO mytable (a, b, d) values (7, 7, 'a') UPDATE mytable SET s = 7 WHERE a = 7 IF s = NULL; APPLY BATCH conditional succeeds, so the batch succeeds.PDF (US Ltr) - 37.9Mb PDF (A4) - 38.0Mb PDF (RPM) - 37.3Mb HTML Download (TGZ) - 10.3Mb HTML Download (Zip) - 10.3Mb HTML Download (RPM) - 8.9Mb Man Pages (TGZ) - 216.7Kb Man Pages (Zip) - 329.5Kb Info (Gzip) - 3.4Mb Info (Zip) - 3.4Mb My SQL Backup and Recovery My SQL Globalization My SQL Information Schema My SQL Installation Guide My SQL and Linux/Unix My SQL and OS X My SQL Partitioning My SQL Performance Schema My SQL Replication Using the My SQL Yum Repository My SQL Restrictions and Limitations Security in My SQL My SQL and Solaris Building My SQL from Source Starting and Stopping My SQL My SQL Tutorial My SQL and Windows My SQL NDB Cluster 7.5 statements are flagged as unsafe for statement-based replication.Most, if not all, databases will implement this as requiring an insert and delete, not an update. 1) first create a copy of the orginal parent record with a new Primary key.2) change the FK on the child record to the primary key of the new parent record you just added.