ProductImages
Retrieve images for a product.
Table Specific Information
Select
WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query.
These columns support only the = comparison, unless stated otherwise. The available columns for this
table are: Id, DateCreated, DateModified, Src, Name, Alt, ProductId. All other columns are processed
client side. If the 'ProductId' filter is not specified, the 本製品 will fetch a list of all the
products and perform a request for each product in the list.
SELECT * FROM ProductImages WHERE Id = 4 SELECT * FROM ProductImages WHERE ProductId = 6
Columns
Name | Type | References | Description |
Id [KEY] | Long | Image ID. | |
DateCreated | Datetime | The date the image was created, in the site's timezone. | |
DateModified | Datetime | The date the image was last modified, in the site's timezone. | |
Src | String | Image URL. | |
Name | String | Image name. | |
Alt | String | Image alternative text. | |
ProductId | Long |
Products.Id | Id of the product. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description | |
ReferenceNumber | String | This column will be used in Bulk operations to get specific values from the Temp tables. |