Solved

SQL Queries for Dummies

Posted on 2013-12-15
3
475 Views
Last Modified: 2013-12-15
I need to be able to make queries with my Volusion.com eCommerce store.

Here is a program I found with a WYSIWYG approach to the query building:
1
It's called SQL Generator. However, it's no good for me, and it only support one table. I need to be able to do those "inner join" things to connect data from different tables.

I also found this:
http://download.cnet.com/Advanced-Access-Builder/3000-10254_4-10571995.html?tag=mncol;5
But I don't know if it will serve my needs either.

So maybe all I need is a website with a handy reference guide to figuring out the syntax.

Can anyone lead me in the right direction?
0
Comment
Question by:gregholl
3 Comments
 
LVL 10

Accepted Solution

by:
George Khairallah earned 400 total points
ID: 39720268
I'm assuming you're using MySQL with Volusion?  there are a lot of products out there.
I personally use MySQL Workbench (http://www.mysql.com/products/workbench/).
Unfortunately, this one also does not have a visual query builder in it.

Quite honestly though, I would recommend that you understand at least the basics of building queries by hand before jumping on a visual tool. It will help you understand the underlying process.
There are a lot of resources that would help you get started. Here are a couple:

http://www.elated.com/articles/mysql-for-absolute-beginners/
http://www.w3schools.com/sql/
http://www.tutorialspoint.com/mysql/

Of course there are plenty more, but this should help you get started.
0
 
LVL 1

Assisted Solution

by:kostbad
kostbad earned 100 total points
ID: 39720391
Why not use Microsoft Access? It makes it real easy to build queries and even reports.
0
 
LVL 1

Author Closing Comment

by:gregholl
ID: 39720418
THANKS GUYS
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now