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
| Thread |
|---|
| • how to delete all records which has same key value in a multi-keytable? | tarbin jiang | 4 Feb |