Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Spijker
  • Content: Threads
  • Order by date
  1. Spijker

    Looking for a MySQL GUI for a Windows environment?

    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.
  2. Spijker

    Is it possible to query multiple MySQL db's in one query?

    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.
  3. Spijker

    Is there a php url referrer variable?

    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.
    • Spijker
    • Thread
    • Replies: 2
    • Forum: PHP
  4. Spijker

    Is there anything quicker than a LEFT JOIN?!!

    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...
  5. Spijker

    HELP! - Left Joins taking a long time to execute.

    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('...
  6. Spijker

    MySQL - Delete's and temp tables

    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...

Part and Inventory Search

Back
Top