Reputation: 45
in salesforce I was able to create scripts that could filter and manipulate data and then export a result. I'm new to mysql and I was wondering if there was a similar tool that uses some programming language to do the same?
here's an example of a salesforce script written in apex just to know what I mean:
Upvotes: 0
Views: 70
Reputation: 55
Salesforce implements a non relational database and a especific language to access to it called Salesforce Object Query Language (SOQL), very similar to SQL
APEX es a Java-like language to call that kind of queries (and more things). The advantage is that the same server hosts the db and the APEX server.
In mysql you have the freedom to choose any language (PHP, Java...) to access the data, but you have to install your own application server (apache, nginx...) to deploy your scripts.
Hope it helps
Upvotes: 2