Search results for query: *

Try going to : http://www.dbtools.com.br/ This is a reasonably good tool and if you like an MS Access type interface to bulid your queries, it has that as well. I have found this GUI to be very useful indeed although I do keep MySQLAdmin handy for some bits and pieces.

Try going to this address ; http://www.dbtools.com.br/ This tool is pretty good and also has an ACCESS type interface if you want to build queries that way.

I am trying to extract information from two seperate tables from 2 different MySQL databases on the same server. Is this possible, and if so what would be the best way to go about it.

Hi all I am having a problem trying to find out if php has a variable that recognizes the referring page as in javascript which is document.referrer. Does any one have any suggestions.

I have a query with a number of LEFT JOIN's in it - SELECT DISTINCT equip.*,CONCAT_WS (' ',firstname,lastname) as name,rooms.rmdesc FROM equip LEFT JOIN stfeqlink ON stfeqlink.equipid = equip.autoid AND stfeqlink.datereturned IS NULL AND equip.dept = 'SW'LEFT JOIN staff ON...

Hi Can anyone help me with this problem. Whenever I create a query with a number of left joins they can take up to 30 seconds to run on a web based MySQL database running through Apache. The latest query to cause me grief is shown below: SELECT DISTINCT equip.*,CONCAT_WS('...

Yep no problem. I am currently doing just that. All you need to do is set up MySQL, PHP and Apache on your Windows PC. This will give you the ability to develop your application in a localhopst environment or directly from the server. I would also suggest you grab the DBTools application which...

Hi It depends on what context you are using yout MySQL Database in. If you are using it to support a web based appplication the best way would be to use one of the embedded languages like PHP or the like to create the value you want and then simply feed this variable into your MySQL database...

Try using a self-join to query the table directly. DevShed.com have a MySQL section on self joins that is quite helpful for this.

I have a table which stores meeting times and want to remove the most recent double entries where they match the same time,date and place. I have created a temporarary table with the data that matches what I want to remove from the main table but when I run the DELETE queries it won't recognize...