Android Bitmap到Base64字符串(Android Bitmap to Base64 String)
如何将一个大的Bitmap(用手机相机拍摄的照片)转换为Base64 String?
How do I convert a large Bitmap (photo taken with the phone's camera) to a Base64 String?
原文:https://stackoverflow.com/questions/9224056
更新时间:2023-03-10 12:03
最满意答案
我猜这是你想要的:
select pi.costtype_id, costcentercode_id, fv.fix, fv.var from planningitems pi left join fixvar fv on fv.costtype_id = pi.costtype_id and (fv.costcenter_id = pi.costcenter_id or fv.costcenter_id = -1 and fv.costtype_id not in (select fv2.costtype_id from fixvar fv2 where fv2.costcenter_id = pi.costcenter_id) );
查询中的逻辑很难遵循。 我很确定有一个更简单的方法来做你想做的事情。 你可能会考虑用样本数据和期望的结果提出另一个问题。
I am guessing this does what you want:
select pi.costtype_id, costcentercode_id, fv.fix, fv.var from planningitems pi left join fixvar fv on fv.costtype_id = pi.costtype_id and (fv.costcenter_id = pi.costcenter_id or fv.costcenter_id = -1 and fv.costtype_id not in (select fv2.costtype_id from fixvar fv2 where fv2.costcenter_id = pi.costcenter_id) );
The logic in your query is very hard to follow. I'm pretty sure there is an easier way to do what you want. You might consider asking another question with sample data and desired results.
相关问答
更多-
TCP/IP模型是一个________。[2023-05-19]
a -
下列中不属于面向对象的编程语言的是?[2022-05-30]
a -
我猜这是你想要的: select pi.costtype_id, costcentercode_id, fv.fix, fv.var from planningitems pi left join fixvar fv on fv.costtype_id = pi.costtype_id and (fv.costcenter_id = pi.costcenter_id or fv.costcenter_id = -1 and fv.co ...
-
如何从mySQL中的子查询中指定父查询字段?(How to specify the parent query field from within a subquery in mySQL?)[2024-01-19]
怎么样: $query = "SELECT p1.id, (SELECT COUNT(1) FROM post_table p2 WHERE p2.parent_id = p1.id) as num_children FROM post_table p1 WHERE p1.parent_id = 0"; 或者如果您在p1.id上放置一个别名,您 ... -
子查询区别字段(Subquery distinct field)[2023-05-29]
试试这个: SELECT [ENCID] ,[PATIENTID] ,[ITEMTYPE] ,[Service Date] ,[Transaction Date] ,[Trans] ,[PracticeName] FROM TABLE1 WHERE ITEMTYPE = 'S' AND ENCID IN ( SELECT ENCID FROM TABLE1 WHERE ... -
在子查询中使用父字段(Using parent field in subquery)[2023-11-21]
尝试只使用一个子查询: SELECT o.invoice_date, o.invoice_number, ( SELECT ROUND(SUM(od.product_price * od.tax_rate / 100), 2) FROM order_detail od WHERE od.id_order = o.id_order ) as `tax` FROM `order` o WHERE o.invoice_number != 0 因为,如果你嵌 ... -
子组外的引用字段(where子句中的Unknown列)(Reference field outside the subgroup (Unknown column in where clause))[2023-07-03]
看起来你正试图在这里自我加入; 就像是 UPDATE order_items a JOIN order_items b ON b.pointer = a.pointer AND b.id_parent = 0 SET a.id_parent = b.id WHERE a.id_parent > 9999; Looks like you are trying to do a self join here; something like UPDATE order_items a JOIN ... -
导致问题的不是Notes ,而是Deployment 。 更准确的是,您在部署表中有多个具有相同库存ID的行。 您可以使用STUFF和FOR XML从子查询返回连接字符串的单个结果,如下所示: SELECT InventoryID, AccountCode, Description, Notes + N'N ' + ( SELECT STUFF( (SELECT ',' + Dep ...
-
不确定您的解决方案有多好,但是这里是如何使用SQLAlchemy编写SQL查询: from sqlalchemy.dialects.postgresql import array # First write the subquery. array() function is used for Pg ARRAY literals. subq = db.session.query( db.func.unnest(array([1])).label('model_id'), db.func.u ...
-
没有。 试试这个。 基本上,在上层次结构时获取所需的属性(如果需要可以重命名它们)然后使用它们。 Select a, d.fa From b join (select a,f.a fa from c join (select a from e) f on f.a = c.a ) d on d.a = b.a 我还没有测试表。如果您发现任何问题,请在此处发布。 *根据更新的问题进行编辑* 即使在这里,逻辑仍然相同,你必须要么...... select a, d.x, d.v? from b join ( ...