From: tarbin jiang Date: February 4 2009 8:31am Subject: how to delete all records which has same key value in a multi-key table? List-Archive: http://lists.mysql.com/ndb-connectors/668 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_7abce46f-2fc8-4e62-a8c4-35fdbb414622_" --_7abce46f-2fc8-4e62-a8c4-35fdbb414622_ Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit there is a multi-key table in my mysql cluster, such as : column name column type is key --------------------------------------------------------- column1 varchar true column2 smallint true column3 text false how should I delete all records which has same column1 value with deleteOperation? bellow is what I did: NdbTransaction trans = ndb.startTransaction(); NdbOperation op = trans.getDeleteOperation(tableName); op.equalString("column1", "100"); ret = trans.execute(ExecType.Commit, AbortOption.AbortOnError,true); trans.close(); it return following error: com.mysql.cluster.ndbj.NdbApiPermanentException: Operation was not defined correctly, probably missing a key how should I do? thanks tarbin _________________________________________________________________ News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx --_7abce46f-2fc8-4e62-a8c4-35fdbb414622_--