Search Results

Search found 2 results on 1 pages for 'imperium2335'.

Page 1/1 | 1 

  • Define keys in temporary table creation

    - by imperium2335
    How do I define the keys for a temporary table that is being created from a SELECT statement? I have: CREATE temporary TABLE _temp_unique_parts_trading engine=memory AS (SELECT parts_trading.enquiryref, sellingcurrency, jobs.id AS jobID FROM parts_trading, jobs WHERE jobs.enquiryref = parts_trading.enquiryref GROUP BY parts_trading.enquiryref) But where do I define the keys?

    Read the article

  • Syncronise Server Seconds with JS Clients

    - by imperium2335
    I would like to drive a setTimeout loop based on the time of the server, seconds only. So when the seconds on the server is 30, some function is run on all clients. It is vital that they do not become totally out of sync with the server, as there will be a CRON job running on the server every, say, 45 seconds which is important to the system functioning correctly. It is ok if a client is out by a few seconds with the server, client do not need to be synced to each other. I am using Jquery library. Hope this makes sense!

    Read the article

1