> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/connectors/mariadb-connector-c/api-prepared-statement-functions/prepared-statement-examples.md).

# Prepared Statement Examples

{% columns %}
{% column %}
{% content-ref url="/pages/1gihUQNSPnPXDxYgleXW" %}
[Bulk Insert (Column-wise Binding)](/docs/connectors/mariadb-connector-c/api-prepared-statement-functions/prepared-statement-examples/bulk-insert-column-wise-binding.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Insert multiple rows in a single prepared-statement call using column-wise binding, demonstrating indicator variables and `STMT_ATTR_ARRAY_SIZE`.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/bXBWYJX9DDqi8z3LBzTU" %}
[Bulk Insert (Row-wise Binding)](/docs/connectors/mariadb-connector-c/api-prepared-statement-functions/prepared-statement-examples/bulk-insert-row-wise-binding.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Insert multiple rows in a single prepared-statement call using row-wise binding, packing parameters into a C struct and setting `STMT_ATTR_ROW_SIZE`.
{% endcolumn %}
{% endcolumns %}