Hello, I am experimenting with an external database. I have set up one and connected it to Bubble using the SQL Database Connector plugin.
But… Now what? How do I access the data? Preferably I would use it just like it was “internal” Bubble data. So for example when I place a new repeating group, I would like to pick a datatype from the external SQL. How to proceed?
I tried Googling about this and read that I should use queries. Is this really neccessary? Where do I enter a query?
Hey @woezel1980. Yes, you will need select queries to read data from this external DB,insert queries to add data, etc. If you use SQL database connector, there is no other option. You cant use it like Bubble’s own data types.
Hi, sorry for the late reply, I missed the notification. 
Thanks for your answer.
Where do I enter these queries? Any recommendations for a beginners “course”?
Start with the official manual. It has all the queries as example. Then, come back here for the parts you don’t understand:
Thanks, I am working on it. Also found this clip which is not in my language but helpful:
Ok, I succeeded in retrieving data from the SQL in my bubble app. I used:
SELECT Kolom1, Kolom2, Kolom3, Kolom4, Kolom5 FROM Test1 WHERE 1 LIMIT 10
This worked! I am now working on updating fields.
This is the plan:
ONe of the columns contains an unique ID. When usingt the app, this ID is present in the URL. I need to refer to this ID and change the fields of the other columns that belong to this ID.
So let’s say that Kolom1 contains the ID, and I need to change the values of Kolom2 (using an input form). In the app I need to refer to the ID (I will do this by fetching it from the URL) and change the corresponding value of Kolom 2.
I was thinking of something like this:
UPDATE Test1 SET Kolom2 = ? Where Kolom2 = ?
This gives me an error:
SQL Database Connector issue: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘?’ at line 1
Not sure how to proceed…
