UPDATE users AS U1, users AS U2
SET U1.name_one = U2.name_colX
WHERE U2.user_id = U1.user_id
Update from Select MySQL
November 7th, 2016Fastest way to delete large folders in Windows
July 23rd, 2016del /f/s/q foldername > nulrmdir /s/q foldernameTreeSize Free V3.45
June 25th, 2016DS18B20 – 1-Wire Temperature Sensors
April 30th, 2016Power/VCC sensor lead — Orange CAT-5/6 wire (pin 2)
Data sensor lead — Blue CAT-5/6 wire (pin 4)
GND (ground) sensor lead — White/Blue CAT-5/6 wire (pin 5
Feeds updating at incorrect time – Update Time Zone
April 30th, 2016By default, the emonPi is set to the UTC time zone. You can set the time zone to match your location by connecting to the emonPi via SSH, and running :
To check current time on the emonPi $ date Enter read-write mode $ rpi-rw Run Raspberry Pi setup $ sudo raspi-config Select internationalization options > timezone Exir raspi-config Return to read-only mode $ rpi-ro
Reset Emoncms to factory settings and erase all data
April 29th, 2016If you want to erase all logged data, input processing and configuration from the local Emoncms on the emonPi, run the ‘factoryreset’ script in the emonpi directory:
$ rpi-rw
$ cd emonpi
$ sudo ./factoryreset
$ rpi-ro
pinginfoview
July 1st, 2015How to Change the Built-in Administrator Account Name in Windows
April 6th, 2015Computer Configuration > Windows Settings > Security Settings > Local Policies > Security Options
How to get rid of prompts for credentials in Office 2013?
March 19th, 2015The dword to add with a zero value is below
HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Internet\useOnlineContent
Resubmit Messages in Queues
March 14th, 2015Use the Shell to resubmit all messages located in a specific mailbox delivery queue or remote delivery queue
Retry-Queue -Identity “<ServerName>\<Destination>” -Resubmit $true