Hi I try using sql connector database When i insert data to mysql and want get his new id ( and be sure to other user not add new other record and i get wrong number). I wanted use for this mysql transaction like below, who work in my mysql database START TRANSACTION; INSERT INTO lightlog_gmp.Pr…

Are you sure that’s correct syntax for MySQL? Also, I’m pretty sure you can only do one transaction, but you have multiple. Try a single one and see what happens.

Thanks for answer Are you sure that’s correct syntax for MySQL? Yeah you have right, I edit my post and add screens. and I test this at mysql workbench and … work - i added screen Also, I’m pretty sure you can only do one transaction, but you have multiple. I am not sure - what do you think…

So here is one of my smallest queries, but it shows you how to use the variables. First, I don’t see you using the variables. Secondly it’s telling you that it doesn’t like the second line (probably) because you have the ; which ends your query. It might not have been built for something like this, …

When I use $1, $2 etc. [db_error_dolar_liczba] which is not existed when I use sign ? - i don’t know why, but first ‘?’ is recognise as first parameter, second ‘?’ is second parameter- i checked that only at mysql. Maybe this is only except only for mysql… https://www.youtube.com/watch?v=iN34KFb…

Send a pic. And yes you might need the ? For MySQL, not sure exactly.

thanks a lot :wink: , so are you using mysql as your database? How you convert tinyint (boolean at mysql) to bubble yes/no? I try a few times, and every time bubble cannot understand change 1 to yes and 0 to no

How about you keep it the same and just build logic around 0 and 1

im having the same problem [Screen Shot 2023-07-16 at 6.46.03 PM] [Screen Shot 2023-07-16 at 6.45.50 PM] what is the correct syntax

I’m not entirely sure, but I don’t think the SQL Connector supports a block of statements. I think it might only work for one select, insert, update, etc. at a time. One idea is to convert your code into a MySQL Stored Procedure and then call the Stored Procedure from Bubble passing it the input pa…

SQL Connector bubble - how call insert into querries inside workflow

Need help Database

ben13 December 23, 2022, 3:35pm 7

I explained this here: SQL Connector SQL Server Parameter Format - #2 by ben13

Topic		Replies	Views
SQL Connector: Return Id after insert query Database	1	531	July 26, 2023
Inserting multiple rows via SQL Connector Database	6	2538	July 23, 2020
SQL Database Connection Database	1	207	March 15, 2024
SQL Database Connector Issue Need help	2	1135	March 31, 2022
Bubble input data to SQL Connector parameter Plugins	15	5847	April 23, 2018

SQL Connector bubble - how call insert into querries inside workflow

Related topics