By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,729 Members | 1,363 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,729 IT Pros & Developers. It's quick & easy.

MySQL Query Tool for php

P: n/a
Bob
I am making the jump from ASP/Access to PHP/MySQL.

And I really miss the ease of generating sql queries inherent in
access.

I've been reduced on occassion to modeling the database in access,
using access to generate the complex sql query then copying it over to
my php app.

Question: Is there a tool that interfaces to mysql and generates sql
queries?

thanks
Jul 17 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On 19 Oct 2003 05:47:03 -0700, Bob <cl****@qualitythink.com> wrote:
I am making the jump from ASP/Access to PHP/MySQL.

And I really miss the ease of generating sql queries inherent in
access.

I've been reduced on occassion to modeling the database in access,
using access to generate the complex sql query then copying it over to
my php app.

Question: Is there a tool that interfaces to mysql and generates sql
queries?

thanks


The human brain.
Why don''t you just learn SQL..

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
Jul 17 '05 #2

P: n/a
John Thingstad wrote:
On 19 Oct 2003 05:47:03 -0700, Bob <cl****@qualitythink.com> wrote:
I am making the jump from ASP/Access to PHP/MySQL.

And I really miss the ease of generating sql queries inherent in
access.

I've been reduced on occassion to modeling the database in access,
using access to generate the complex sql query then copying it over to
my php app.

Question: Is there a tool that interfaces to mysql and generates sql
queries?

thanks

The human brain.
Why don''t you just learn SQL..

phpMyAdmin can help you generate queries if you for some reason don't
learn SQL. Its available at http://www.phpmyadmin.net/.

Jul 17 '05 #3

P: n/a
In article <H6***********************@twister.neo.rr.com>, John Downey's
output was...
John Thingstad wrote:
Question: Is there a tool that interfaces to mysql and generates sql
queries?

thanks

The human brain.
Why don''t you just learn SQL..

phpMyAdmin can help you generate queries if you for some reason don't
learn SQL. Its available at http://www.phpmyadmin.net/.

PhpMyAdmin has actually helped me learn some SQL. I've used it to
generate queries, and in doing so, seen how these queries are
constructed, so I am subsequently able to construct them on my own.
And it doesn't cause an error in module explorer.exe, like access does;-)
Jul 17 '05 #4

P: n/a
sk
If you can connect to MySQL from your desktop PC (not a given on a
hosted server), then you can install a MySQL ODBC driver on your PC and
use Access or pretty much whatever you want to build queries.

--
Steve Koppelman
http://www.hatless.com/

Bob wrote:
I am making the jump from ASP/Access to PHP/MySQL.

And I really miss the ease of generating sql queries inherent in
access.

I've been reduced on occassion to modeling the database in access,
using access to generate the complex sql query then copying it over to
my php app.

Question: Is there a tool that interfaces to mysql and generates sql
queries?

thanks


Jul 17 '05 #5

P: n/a
Bob
Actually I do have quite an extensive knowledge of SQL. I should have
mentioned my queries are very long and very complex, spaning multiple
tables/databases.

And yes I can constuct complex queries, but in this time rushed world,
I prefer point and click.

cl****@qualitythink.com (Bob) wrote in message news:<cf**************************@posting.google. com>...
I am making the jump from ASP/Access to PHP/MySQL.

And I really miss the ease of generating sql queries inherent in
access.

I've been reduced on occassion to modeling the database in access,
using access to generate the complex sql query then copying it over to
my php app.

Question: Is there a tool that interfaces to mysql and generates sql
queries?

thanks

Jul 17 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.