You may optionally enter a comparison operator (<, <=, >, >=, <> or =) at the beginning of each of your search values to specify how the comparison should be done.
UPDATE
`project.dataset.table1` t1
SET
t1.target_column = t2.source_column
FROM
`project.dataset.table2` t2
WHERE
t1.join_key = t2.join_key;
269
PL/pgSQL
Datenbank
UPDATE SQL mit JOIN
UPDATE TableToBeUpdated
SET myField1 = 'Update this field'
FROM
(
SELECT * FROM JoinedTable
WHERE cond1 = 1
)
J
WHERE J.ID = TableToBeUpdated.ID
;
271
MySQL
Datenbank
UPDATE SQL mit JOIN
UPDATE TableToBeUpdated UPD_TABLE
INNER JOIN JoinedTable J ON J.id = UPD_TABLE.id
SET UPD_TABLE.myField1 = 'Update this field'
;
270
T-SQL
Datenbank
UPDATE SQL mit JOIN
UPDATE UPD_TABLE
SET UPD_TABLE.myField1 = 'Update this field'
FROM TableToBeUpdated UPD_TABLE
LEFT JOIN
(
SELECT * FROM JoinedTable
WHERE cond1 = 1
)
J
WHERE J.ID = UPD_TABLE.ID
;
149
Perl
Datum, Zeit
Jahr aus Datum extrahieren
use POSIX qw/EXIT_SUCCESS EXIT_FAILURE/;
# Datum Vorbereitung:
my $DateTime = POSIX::strftime('%c', localtime(time));
my ($Date, $Time) = split(/\s+/, $DateTime);
my ($Day, $Month, $Year) = split(/\./, $Date);
my ($Hour, $Minute, $Second) = split(/:/, $Time );
my $Datum = "$Year"."$Month"."$Day";
#oder
# my $Datum = "$Day"."$Month"."$Year";
my $Uhrzeit = "$Hour".":"."$Minute".":"."$Second";
292
Yii2
Yii2-Internal
Prüfen ob aktueller User ein Gast ist
use Yii;
if (! \Yii::$app->user->isGuest)
{
$result = "User is logged in. User is no guest"
}
78
Delphi
Anwendungskonfigurationsdateien
INI-Datei lesen
uses
IniFiles;
var
iniMem: TMemIniFile; // ini-File (ready only one time)
// Load the ini-information once - maybe at startup
function TMyForm.LoadIniFile:boolean;
var
SL : TStringList;
return : Boolean;
iniFile : String;
begin
iniFile:='myFormConfig.ini';
return:=true;
if not FileExists(ExtractFilePath(Application.Exename)+iniFile) then
begin
MessageDlg('ini-File not found!', mtError, [mbOK], 0);
return:=false;
end;
if not return then halt;
iniMem:=TMemIniFile.Create('');
SL:=TStringList.Create;
SL.LoadFromFile(ExtractFilePath(Application.Exename)+iniFile);
iniMem.SetStrings(SL);
LoadIniFile:=return;
end;
procedure TMyForm.DoThis;
begin
ShowMessage(iniMem.ReadString('Section','Attribute','Default-Value'));
end;
86
C#
Variablen
Parsen von Datentypen
var d = (double)integer;
var myButton = (Button)object;
91
C#
Textdateien
TextDatei auslesen
var streamReader = new StreamReader("datei.txt");
string fileContent = streamReader.ReadToEnd();
streamReader.Close();
242
Bash Script
Fallunterscheidung
Wenn-Dann Abfrage
VAR1=1
VAR2=2
if [ "$VAR1" -eq "$VAR2" ]; then
echo "true";
else
echo "false";
fi
# false
