# Please give me some instance for write tag into database

**URL:** <https://forum.inductiveautomation.com/t/please-give-me-some-instance-for-write-tag-into-database/46008>\
**Category:** Ignition\
**Tags:** ignition79, ignition80\
**Created:** [April 25, 2021, 7:44am UTC](https://forum.inductiveautomation.com/t/please-give-me-some-instance-for-write-tag-into-database/46008 "2021-04-25T07:44:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![netliuhao](https://avatars.discourse-cdn.com/v4/letter/n/8baadc/32.png) [@netliuhao](https://forum.inductiveautomation.com/u/netliuhao)\
**Post date:** [April 25, 2021, 7:44am UTC](https://forum.inductiveautomation.com/t/please-give-me-some-instance-for-write-tag-into-database/46008/1 "2021-04-25T07:44:15Z")

</div>

hello ： SIR.  
i am new guy for ignition.  
i can read date form MYSQL database in Ignition software before last week .  
but i don’t know : how to write tags-value into Mysql database in Ignition software .  
my idea is : when i click one button in HMI picture . it will write some tags-value into MYsql database .  
but i don’t know :how to do it ?  
certainly , another way can write tags into database will very good.

the picture is read vales from MYSQL.

 ![74adb3fe8fb0ee2497e89d9823d0f7d](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/8/b8c06ff9ed6dbc96d2f8c341650c0fc1cfe62733.png)

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [April 25, 2021, 12:42pm UTC](https://forum.inductiveautomation.com/t/please-give-me-some-instance-for-write-tag-into-database/46008/2 "2021-04-25T12:42:27Z")

</div>

```auto
# This example would gather some user entered text and insert it into the database.
  
ID_val = 10
class_val = 10
system.db.runPrepUpdate("INSERT INTO andytable1 (ID, class) VALUES (?,?)", [ID_val, class_val])

```

[https://docs.inductiveautomation.com/display/DOC79/system.db.runPrepUpdate](https://docs.inductiveautomation.com/display/DOC79/system.db.runPrepUpdate)

Also your ID should be set in MySQL to Auto Increment, you shouldn’t be supplying the value each time

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [April 25, 2021, 12:43pm UTC](https://forum.inductiveautomation.com/t/please-give-me-some-instance-for-write-tag-into-database/46008/3 "2021-04-25T12:43:09Z")

</div>

Put the above code on the script section of your button, and turn your designer to read/write mode before putting it into preview mode and clicking