MYSql - how to update data

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

jamesmeeds · 2021-01-02T15:47:09.907Z

I’ve opened the app to edit again,

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.

The button is in page Index, in the department_members group, not sure why it isn’t actually updating the value when entered?

lottemint.md · 2021-01-02T15:51:35.128Z

Fixed.

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

Weird syntax. Try to update a department - and then refresh the page.

jamesmeeds · 2021-01-02T15:52:26.527Z

Aha you got it!

Yeah it’s really weird man, I’ve seen a lot of people having to use ? for MySQL here!

lottemint.md · 2021-01-02T16:00:38.288Z

Ehm. By logic, we should be able to use $1, $2, etc.

ericwil1991 · 2022-02-28T12:56:00.851Z

Continuing the discussion from MYSql - how to update data:

james can you help with mobile app connecting to mysql? any whstsapp?
it’s a project not a question. thanks!

jamesmeeds · 2022-02-28T16:37:25.117Z

Same way that you’d work it for a website app, using that above

If you drop me a DM with your question and issues I’ll be able to help you.

ericwil1991 · 2022-02-28T17:33:35.597Z

how do I send a dm?