MySQL Query Tool for php

[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

[John Thingstad]

Re: MySQL Query Tool for php

On 19 Oct 2003 05:47:03 -0700, Bob <clarke@quality think.com> wrote:
[color=blue]
> 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[/color]

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

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

[John Downey]

Re: MySQL Query Tool for php

John Thingstad wrote:
[color=blue]
> On 19 Oct 2003 05:47:03 -0700, Bob <clarke@quality think.com> wrote:
>[color=green]
>> 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[/color]
>
>
> The human brain.
> Why don''t you just learn SQL..
>[/color]
phpMyAdmin can help you generate queries if you for some reason don't
learn SQL. Its available at http://www.phpmyadmin.net/.

[Eto Demerzel]

Re: MySQL Query Tool for php

In article <H6xkb.138105$x x4.25583891@twi ster.neo.rr.com >, John Downey's
output was...[color=blue]
> John Thingstad wrote:
>[color=green][color=darkred]
> >> Question: Is there a tool that interfaces to mysql and generates sql
> >> queries?
> >>
> >> thanks[/color]
> >
> >
> > The human brain.
> > Why don''t you just learn SQL..
> >[/color]
> phpMyAdmin can help you generate queries if you for some reason don't
> learn SQL. Its available at http://www.phpmyadmin.net/.
>[/color]
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;-)

[sk]

Re: MySQL Query Tool for php

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:
[color=blue]
> 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[/color]

[Bob]

Re: MySQL Query Tool for php

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.



clarke@qualityt hink.com (Bob) wrote in message news:<cfa521f2. 0310190447.66aa 2fad@posting.go ogle.com>...[color=blue]
> 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[/color]