RE: [PHP] Query Analyzer For MySQL with PHP?
| From: | Renzi, Sebastian | Date: | Mon, 23 Apr 2001 20:08:37 +0000 |
| Subject: | RE: [PHP] Query Analyzer For MySQL with PHP? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-49933@lists.php.net to get a copy of this message | ||
Create a mysql odbc acces and download the winsql.exe program that works
with odbc connections ,its a great sql client !!
Sebastián Renzi
Consultoría & Desarrollo de Sistemas.
CODES S.A
> -----Mensaje original-----
> De: Philip Olson [SMTP:philip@cornado.com]
> Enviado el: lunes 23 de abril de 2001 16:47
> Para: Brandon Orther
> CC: PHP User Group
> Asunto: Re: [PHP] Query Analyzer For MySQL with PHP?
>
>
> Use the mysql monitor, from shell :
>
> mysql -u username -p dbname
>
> That'll log you in, now run some queries :
>
> mysql>SELECT * FROM tablename;
>
> At this point everything is selected and displayed from table tablename.
> In otherwords, we can run and view SQL queries from this console, much
> like MySQL does it for PHP. Here are a couple tutorials that should help :
>
> MySQL Monitor Tutorial :
> http://www.mysql.com/doc/T/u/Tutorial.html
>
> MySQL Tutorial (demonstrates monitor) :
> http://www.devshed.com/Server_Side/MySQL/Intro/
>
> Also, phpMyAdmin has a place to enter and view such queries via a form.
>
> phpMyAdmin :
> http://www.phpwizard.net/projects/phpMyAdmin/
>
>
> Regards,
> Philip
>
>
>
> On Mon, 23 Apr 2001, Brandon Orther wrote:
>
> > Hello,
> > I recently took an ANSI SQL class to better familiarize my self with
> SQL in
> > general. In the class we used MSSQL SERVER 7 and to do queries we used
> the
> > Query Analyzer. Does anyone know of a PHP script that works like the
> Query
> > Analyzer so I can test Queries in a Browser? Like A Text Area where I
> can
> > put the query and a simple form that sends it to MySQL.
> >
> > Thanks,
> > Brandon
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-general-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
> >
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net