It is my Computer Notes.
Using Guide : object-key or object-key-key
e.g. Step 1 Blog Search : [mysql-run] and then Step 2 ctrl+F [mysql-run]
{bookMark me : Ctrl+D}
2013年9月16日 星期一
mysql
mysql - had this record or not
sqlString="select count(*) from table where objectNumber='"+mObjectNumber+ "' and year="+mYear+" and mth='"+mMth+"'"; result=result+" "+sqlString; rs = stmt.executeQuery(sqlString); rs.next(); int k=rs.getInt(1);
沒有留言:
張貼留言