mysql - 如何在mysql对象中写入where条件
问题描述
在表 AI 中有一个options
类似下面的值的列。
{
"info_buyRequest": {
"qty": "1.0000"
},
"options": [
{
"label": "Prescription",
"value": "|power_base:-2.00|bc_base:8.9|dia_base:14.2|qty:1",
"print_value": "|power_base:-2.00|bc_base:8.9|dia_base:14.2|qty:1",
"option_id": "403",
"option_type": "field",
"option_value": "|power_base:-2.00|bc_base:8.9|dia_base:14.2|qty:1",
"custom_view": false
}
]
}
我有一个表 B,其中包含power_code
、bc_code
、等列dia_code
。我必须将表 b 列与表 A 对象power_base
、bc_base
、进行比较dia_base
。
或者是否可以使用 PHP?
创建表语句。
CREATE TABLE `sales_order_item` (
`item_id` int(10) UNSIGNED NOT NULL COMMENT 'Item ID',
`order_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Order ID',
`parent_item_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Parent Item ID',
`quote_item_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Quote Item ID',
`store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
`product_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Product ID',
`product_type` varchar(255) DEFAULT NULL COMMENT 'Product Type',
`product_options` text COMMENT 'Product Options',
`weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Weight',
`is_virtual` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Is Virtual',
`sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
`name` varchar(255) DEFAULT NULL COMMENT 'Name',
`description` text COMMENT 'Description',
`applied_rule_ids` text COMMENT 'Applied Rule Ids',
`additional_data` text COMMENT 'Additional Data',
`is_qty_decimal` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Is Qty Decimal',
`no_discount` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'No Discount',
`qty_backordered` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Backordered',
`qty_canceled` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Canceled',
`qty_invoiced` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Invoiced',
`qty_ordered` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Ordered',
`qty_refunded` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Refunded',
`qty_shipped` decimal(12,4) DEFAULT '0.0000' COMMENT 'Qty Shipped',
`base_cost` decimal(12,4) DEFAULT '0.0000' COMMENT 'Base Cost',
`price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
`base_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Price',
`original_price` decimal(12,4) DEFAULT NULL COMMENT 'Original Price',
`base_original_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Original Price',
`tax_percent` decimal(12,4) DEFAULT '0.0000' COMMENT 'Tax Percent',
`tax_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Tax Amount',
`base_tax_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Tax Amount',
`tax_invoiced` decimal(20,4) DEFAULT '0.0000' COMMENT 'Tax Invoiced',
`base_tax_invoiced` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Tax Invoiced',
`discount_percent` decimal(12,4) DEFAULT '0.0000' COMMENT 'Discount Percent',
`discount_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Discount Amount',
`base_discount_amount` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Discount Amount',
`discount_invoiced` decimal(20,4) DEFAULT '0.0000' COMMENT 'Discount Invoiced',
`base_discount_invoiced` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Discount Invoiced',
`amount_refunded` decimal(20,4) DEFAULT '0.0000' COMMENT 'Amount Refunded',
`base_amount_refunded` decimal(20,4) DEFAULT '0.0000' COMMENT 'Base Amount Refunded',
`row_total` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Row Total',
`base_row_total` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Row Total',
`row_invoiced` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Row Invoiced',
`base_row_invoiced` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Row Invoiced',
`row_weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Row Weight',
`base_tax_before_discount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Before Discount',
`tax_before_discount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Before Discount',
`ext_order_item_id` varchar(255) DEFAULT NULL COMMENT 'Ext Order Item ID',
`price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Price Incl Tax',
`base_price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
`row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
`base_row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
`discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
`base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
`discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Invoiced',
`base_discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Invoiced',
`discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Refunded',
`base_discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Refunded',
`tax_canceled` decimal(12,4) DEFAULT NULL COMMENT 'Tax Canceled',
`discount_tax_compensation_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Canceled',
`tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Tax Refunded',
`base_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Refunded',
`discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Refunded',
`base_discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Refunded',
`gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
`gift_message_available` int(11) DEFAULT NULL COMMENT 'Gift Message Available',
`free_shipping` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Free Shipping',
`weee_tax_applied` text COMMENT 'Weee Tax Applied',
`weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Amount',
`weee_tax_applied_row_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Row Amount',
`weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Disposition',
`weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Row Disposition',
`base_weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Amount',
`base_weee_tax_applied_row_amnt` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Row Amnt',
`base_weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Disposition',
`base_weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Row Disposition',
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Item';
解决方案
推荐阅读
- swift - 使用通用参数创建 async/await 函数
- python - 如何使用 pd.read_xml 正确解析 SEC cal.xml 文件?
- css - Safari 和 Chrome 之间的 CSS 'visibility:collapse' 错误?
- c# - 如何在 Unity 中使 UI 看起来像 Pixel Perfect?
- java - 使用的 lambda 表达式中未触发断点 n CompletableFuture.supplyAsync(Supplier) (不是由于延迟执行)
- c# - 下拉值需要传入repeater控件绑定方法
- android - 获取 Android Dialog Window 的实际偏移量
- c# - 如何有效地通过网络发送受约束的双精度值
- python - 在 `tortoise.field.ForeignKeyField` 中使用关键字 `related_name`
- discord - 我想在 discord.py 的 on_reaction_add 函数中获取用户反应的消息