Reputation: 1928
I am a real dummie when it comes to SQL. Does anyone have a tool maybe that I could select what I want to do and have it output the sql query?
Thanks, Blake
Upvotes: 0
Views: 1041
Reputation: 2590
Navicat (the database manager) outputs the SQL in the bottom of the window. This is true for deletion, insertion, ordering, etc.
Upvotes: 0
Reputation: 6014
MySQL workbench (Look inside the mysql.com) is a free tool and generates the whole sql code for you. Also phpMyAdmin do the job, but they are different tools for different reasons.
Upvotes: 1
Reputation: 742
I would look into phpMyAdmin, http://www.phpmyadmin.net/home_page/index.php
Upvotes: 1