mariadb_dyn...te_many_num(3)

πŸ“¦
version 13.0.2 Β· 4 versions
, in alpine 3.22, alpine 3.23, alpine 3.24, arch rolling, centos-stream 10, debian trixie, fedora 43, fedora 44, nixpkgs unstable, opensuse-leap 16.0, ubuntu questing, ubuntu resolute, ubuntu stonking

✨ mariadb_dyncol_update_many_num ✨

okay bestie, welcome to the MariaDB Connector/C manual, page mariadb_dyn...te_many_num(3) πŸ’– this one's a bop, let's go.


🌸 NAME 🌸

mariadb_dyncol_update_many_num β€” update, insert or delete values in a dynamic column using numeric keys πŸ¦‹


✨ SYNOPSIS ✨

#include <mariadb_dyncol.h>

enum enum_dyncol_func_result
mariadb_dyncol_update_many_num(DYNAMIC_COLUMN *str,
                               uint column_count,
                               uint *column_keys,
                               DYNAMIC_COLUMN_VALUE *values)

like, copy it exactly bestie, no typos, the compiler is NOT forgiving πŸ’…


πŸ’– DESCRIPTION πŸ’–

So basically? You're adding, deleting, or updating columns in a dynamic column, and you're doing it with a numeric key. That's the whole vibe. Multiple columns, one call, we love efficiency πŸ‘‘


πŸŽ€ PARAMETER πŸŽ€

  • *str β€” a pointer to a dynamic column structure 🌈
  • column_count β€” how many columns we're talking about, the count, the number, the quantity πŸ”’
  • *column_keys β€” an array of column keys, one per column, obvi πŸ—οΈ
  • *values β€” an array of values, matching up with those keys πŸ“

⭐ RETURN VALUE ⭐

It hands you back ER_DYNCOL_OK when everything slays, and otherwise... an error. 😭 That's it, that's the deal.


🧚 NOTES 🧚

  • Wanna delete a column? You update its value to a "non-value"</> of type DYN_COL_NULL πŸ’€ that's the move, that's the trick, iykyk.
ngl this is the kind of thing that lives rent-free in your head once you know it. DYN_COL_NULL = bye bye column πŸ™ˆ

πŸ’œ SEE ALSO πŸ’œ

  • mariadb_dyncol_create_many_num
  • mariadb_dyncol_update_many_named
  • Dynamic Column Error Codes

and that's the page, bestie 🫢 Version 3.4 of the MariaDB Connector/C manual, page mariadb_dyn...te_many_num(3) β€” go forth and update those dynamic columns, you absolute icon πŸ‘‘βœ¨πŸŽ€

πŸ“¦ where this page comes from