MYSql - how to update data

jamesmeeds · 2021-01-01T23:30:08.209Z

Hi Bubblers!

How do we go about updating data to a MySQL database?

image857×334 15.6 KB

All I’m trying to achieve above is change someone’s callsign, but I get the below error, any help?

jamesmeeds · 2021-01-02T14:11:32.717Z

Please someone must know?

lottemint.md · 2021-01-02T14:40:53.865Z

Hello,

Try the following one, please:

image764×212 32.6 KB

lottemint.md · 2021-01-02T14:47:31.123Z

Also, you need to have kind of the next query:

UPDATE table_name
SET "column1" = $1
WHERE "id" = $2;

Without specifying which record you need to update, you will update all of them.

Link:
https://www.tutorialspoint.com/sql/sql-update-query.htm

jamesmeeds · 2021-01-02T15:14:05.297Z

Hi,

Although in the mySQL database, it does exist?

jamesmeeds · 2021-01-02T15:14:27.358Z

image837×350 19 KB

This is the query at the moment…

lottemint.md · 2021-01-02T15:19:55.848Z

Try to replace ” with ".

I’ve updated my comment:

jamesmeeds · 2021-01-02T15:21:12.341Z

lottemint.md:

"

That broke all of it changing that

lottemint.md · 2021-01-02T15:22:09.143Z

Can you paste a screenshot of your current query, please?

jamesmeeds · 2021-01-02T15:22:29.799Z

image839×362 19.1 KB

Shall I sent an editor link maybe?

lottemint.md · 2021-01-02T15:22:55.348Z

jamesmeeds:

Shall I sent an editor link maybe?

yes, please

jamesmeeds · 2021-01-02T15:24:02.176Z

Bubble

Bubble - Visual Programming

Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications.

does this work?

lottemint.md · 2021-01-02T15:26:23.338Z

jamesmeeds:

does this work?

Nope. It’s a preview link.

change it to:

UPDATE department_members
SET "callsign" = $1
WHERE "userID" = $2;

The quotes should be ".

jamesmeeds · 2021-01-02T15:27:41.319Z

Using your quotes, it causes everything to break, I think it’s a keyboard thing?

When I use mine, I get the below screenshot;

jamesmeeds · 2021-01-02T15:30:16.307Z

I have changed perms in my app, you should be able to access the editor via that link above?

lottemint.md · 2021-01-02T15:37:59.474Z

Thanks for providing the access.

The next one works:

UPDATE department_members
SET `callsign` = callsign
WHERE `userID` = userID;

So, `` these for column names.
I see that we cannot use $ as variables. We need to type the names of the added parameters.

jamesmeeds · 2021-01-02T15:38:28.599Z

You are a star! Thank you very much! Appreciate the help you’ve given me!

lottemint.md · 2021-01-02T15:39:28.055Z

Have you tested it out via workflows to ensure if that works?

jamesmeeds · 2021-01-02T15:39:50.253Z

I’ll do a quick mockup of it now, standby

jamesmeeds · 2021-01-02T15:45:07.456Z

Ah, it isn’t actually updating the value on the MySQL datbase