Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Need basic help building query for MySQL connector #12

Open
utsecnet opened this issue Apr 15, 2019 · 0 comments
Open

Need basic help building query for MySQL connector #12

utsecnet opened this issue Apr 15, 2019 · 0 comments

Comments

@utsecnet
Copy link

I have a very simple MySQL database table that looks like:

+----+-------------------------+-------+---------+---------+
| id | program_name            | value | goal_1y | goal_6m |
+----+-------------------------+-------+---------+---------+
|  1 | vulerability management |     2 |       5 |       3 |
|  2 | incident response       |     2 |       4 |       2 |
|  3 | infrastructure          |     4 |       8 |       6 |
|  4 | data ecurity            |     2 |       7 |       5 |
|  5 | cloud security          |     3 |       6 |       4 |
|  6 | IDM                     |     4 |       7 |       6 |
+----+-------------------------+-------+---------+---------+

I know MySQL isn't officially supported, but I've seen the author of this plugin help others that are using it for MySQL. I am trying to get one blob for Value, one blob for goal_1y, and one blob for goal_6m. I don't know how to build the query to get the display like I want. Can someone help me?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant