Needing help with mySQL parameters

Hello there everyone, I’m pretty new to the mySQL part of bubble and I was wondering how do I put the parameters in my mySQL query. I’ve been stuck with this for a few weeks now. (See screenshot)

I placed the parameter names in the places I want the parameter text to be.

Hi there, I need help with my bubble -> mySQL parameters. :slight_smile:

Captura de Tela 2020-05-06 às 17.45.32

1 Like

Thank you, after figuring out a little bit I have found the sulution. Thank you for the response. :slight_smile:

Since you asked the question could you please share your solution you found to the problem?

I’m also trying to resolve a similar problem and wondering if any one has some advice. I have looked through the forum and can’t find a post that solves my problem.

I can successfully connect to my mySQL database and can write a query to insert a new row into the applicable table. The problem I am having is when I try create a parameter and reference that in the query, for some reason bubble.io (or the way I have written the query) doesn’t parse the value through to the db.

As an example, if I hard code the values into the query then I can successfully update the db with the hardcoded values.


image

But when I create a parameter ($1) with a name title_name (see screenshot below) it does not save the test value to the db.


image

I have tried the following snytax with no luck:

@title_name
$1
=title_name
@$1
=$1

Any help will be great :slight_smile:

still looking for help?

Hello I’m stuck here I tried with @ ? or simply with the name of the parameter but without success you can share how you did it

The solution is here: SQL Connector SQL Server Parameter Format - #2 by ben13

You need to use the ‘?’ for parameter replacement for MySql.

You guys, my sql worked like this:

from EST_SAIDA_ESTOQUE
where ID_ADMINISTRACAO = ?
limit 20;

ps: I’m using mysql database