You can’t specify target table ‘XXX’ for update in FROM clause – MySQL

If you try to run this query below in MySQL

UPDATE XXX
SET count = count + 5000 
WHERE id IN ( SELECT id FROM XXX WHERE id > 2 )  ;

You will get this error message:
“You can’t specify target table ‘XXX’ for update in FROM clause – MySQL …”

MySQL does have an unorthodox way to handle this type of request:

UPDATE XXX
SET count = count +  5000
WHERE id  IN 
(
	SELECT id FROM 
	(
	SELECT id FROM XXX ORDER BY id DESC LIMIT 20 
	) 
	AS Temp_Tbl
)

Failed to open disk scsi0:0: Unsupported and/or invalid disk type 7

If you get this error

Failed to open disk scsi0:0: Unsupported and/or invalid disk type 7.
Did you forget to import the disk first?
Unable to create virtual SCSI device for scsi0:0

chances are that your VM was created with an ealier version of vmware and it is not quite compatible with the version 7. When that happens just download the vmware converter and convert your vm to the new version.

 

SQL Server Setup failed to modify security permissions on registry key

“SQL Server Setup failed to modify security permissions on registry key SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib for user XXXX. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that the registry key  exists on the destination drive.”

Add the following to the group in "administrative tools"

For some reason the software did not create the  necessary group. Make sure you replace YOURSERVERNAME with your server name.

Common Web Browsers Layout Engines

What Layout engine do the common Web Browsers use?

IE

IE  uses Trident layout engine.
http://en.wikipedia.org/wiki/Trident_(layout_engine)

FireFox 

FireFox uses the GECKO layout engine
http://www-archive.mozilla.org/newlayout/doc/layout-2006-12-14/master.xhtml
https://wiki.mozilla.org/Gecko:Home_Page

Opera

Opera uses the Presto Engine
http://www.opera.com/docs/specs/presto29/

Safari

Safari uses the Webkit Layout Engine
http://www.webkit.org/

Chrome

Chrome uses the Webkit Layout Engine
http://www.google.com/chrome/intl/en/webmasters-faq.html