SQL survival kit

SELECT * FROM ITL WHERE str CONTAINS  'BBB';   --> exact match 
SELECT * FROM ITL WHERE str LIKE  'C';         --> starts with 
SELECT * FROM mytable WHERE Md IS null; 
SELECT * FROM mytable WHERE Id>5; 
SELECT count(*) FROM mytable;                  --> count the number of rows
UPDATE table_13 SET Width=50, Height=50 WHERE id=1; 
ALTER TABLE mytable ADD COLUMN Width int; 
ALTER TABLE mytable CHANGE col col_new_name VARCHAR(255); 
RENAME TABLE mytable TO newtable;

DELETE FROM `mytable` WHERE Url LIKE '%sylvain%';
DELETE FROM ourson_offer;
DELETE FROM lt.image WHERE lt_kimage_id IN (select lt.image.lt_kimage_id from lt.image INNER JOIN lt.keyword ON lt.image.ltu_kimage_id = lt.keyword.lt_kimage_id WHERE lt.keyword.keyword LIKE '%_dead' ORDER BY lt_kimage_id LIMIT 100000);

jointure explicite:

SELECT *   
  FROM employee INNER JOIN department
  ON employee.DepartmentID = department.DepartmentID; 

jointure implicite:

SELECT *   
  FROM   employee, department  
  WHERE  employee.DepartmentID = department.DepartmentID; 

• list sorted column names of a table 

SELECT COLUMN_NAME FROM information_schema.columns WHERE table_schema='app_v2' AND table_name='guest' ORDER BY COLUMN_NAME;

Perl's survival kit

[] empty array
{} empty hash

my $toto = shift equivalent to shift(@_) meaning the first function parameter.

msbuild.exe

c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\msbuild.exe "c:\build\MyBuild.sln" /t:Build /p:Configuration=Release;Platform=Win32 /v:diag

Switch AZERTY/QWERTY key settings (when it is changed using Studio)

When using Visual Studio, it happens that the key settings change from AZERTY to QWERTY. To put them back:

left ALT + SHIFT