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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
