PlItems

ID: 24
PlCodelang: Caché
PlGroup: Caché-Spezifisch, Netzwerk
PlItemTitle: Superserver-Port
Code: W !,$ZU(172,0) ; z.B. 1972

ID: 34
PlCodelang: Caché
PlGroup: Caché-Spezifisch, Prozesse/Jobs
PlItemTitle: Variableninhalt eines fremden Prozesses ermitteln
Code: ; Important: You musn't check variables in your own job, it will result in a <PARAMETER>-Error! Set checkjob=1234 Set checkvar="foo" ; Check if job is not my own Quit:checkjob=$Job ; Check if Job exists und prompt the content of the varible foo If $Data(^$Job(checkjob)) W !,$ZUtil(88,2,checkjob,checkvar) ; Prompts the content of the variable foo, maybe it is 'bar' ;-)

ID: 82
PlCodelang: Caché
PlGroup: Textdateien
PlItemTitle: Textdatei schreiben
Code: Set file=##class(%File).%New("file.txt") Write file.Size Do file.Open("WSN") Do file.WriteLine("This is a line of text")

ID: 7
PlCodelang: Mumps
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: ; The first integer is the number of days since December 31, 1840, where day 1 is January 1, 1841. The second integer is the number of seconds since midnight of the current day Set h=$horolog S h=$H W !,h ; gibt aus 61793,34937 was dem Datum 2010-03-08 und der Uhrzeit 09:42:17 entspricht

ID: 11
PlCodelang: Mumps
PlGroup: Datenbank
PlItemTitle: Lesen Datensatzes
Code: ; In M werden Tabellen Globals genannt S id=1 W !,^TABLE(id) S street="Hollywood Drive" S city="Los Angeles" W !,^PERSONS(street,city) S temp=^GLOBAL(0,"test","temp1")

ID: 14
PlCodelang: Mumps
PlGroup: Array
PlItemTitle: Array definieren
Code: S arr("dim1","dim2")="value" Set arr("dim1",99)=187 ; Persistent, will be saved with prefix ^: S ^save("dim1","dim2")="saved value"

ID: 16
PlCodelang: Mumps
PlGroup: Variablen
PlItemTitle: Existenz der Varible abfragen
Code: Set status=$Data(test) If status Write !,"Variable existiert: "_test I '$D(test2) W !,"Variable existiert nicht!"

ID: 21
PlCodelang: Mumps
PlGroup: Variablen
PlItemTitle: Var-Dump einer Variable
Code: ZW test S A(1,2)="Inhalt" ZWrite A Set ^GLOBAL1("sub1","sub2")="content" ZW ^GLOBAL1

ID: 33
PlCodelang: Mumps
PlGroup: Strings
PlItemTitle: String nach Delimenter zerlegen
Code: myString="A;B;C;D;E" Write !,$Piece(myString,";",3) // gibt C aus

ID: 40
PlCodelang: Mumps
PlGroup: Strings
PlItemTitle: String nach einem Teilstring durchsuchen
Code: Set fullstring="This is my string" Set searchfor="my" If $Find(fullstring, searchfor) Do . Write !,"I found it!!" . Quit

ID: 127
PlCodelang: Mumps
PlGroup: Konsolenverwaltung
PlItemTitle: Einlesen Konsoleneingabe
Code: WRITE !,"What's your name? " READ yourname

ID: 165
PlCodelang: Mumps
PlGroup: Variablen
PlItemTitle: Auflistung aller Variablen
Code: S A="This is a test" Set b=1 ZW ZWrite

ID: 6
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: SELECT NOW(); INSERT INTO table (datetime) VALUES (NOW());

ID: 10
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: Lesen Datensatzes
Code: SELECT * FROM myTable WHERE id=1; SELECT field2,field17 FROM myTable WHERE id=1 AND name='test'; SELECT field3,field1 FROM myTable WHERE city like '%ew Yor%';

ID: 271
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: UPDATE SQL mit JOIN
Code: UPDATE TableToBeUpdated UPD_TABLE INNER JOIN JoinedTable J ON J.id = UPD_TABLE.id SET UPD_TABLE.myField1 = 'Update this field' ;

ID: 287
PlCodelang: MySQL
PlGroup: Strings
PlItemTitle: Anzahl an Zeichen in einem String ermitteln
Link Reference: https://pisceansheart.wordpress.com/2008/04/15/count-occurrence-of-character-in-a-string-using-mysql/
Code: -- Gets only result with 4 "/" in the the field relativePath SELECT id ,albumRoot ,relativePath ,date ,caption ,collection ,icon ,LENGTH(relativePath) - LENGTH(REPLACE(relativePath,'/','')) AS `occurrences` FROM Albums WHERE LENGTH(relativePath) - LENGTH(REPLACE(relativePath,'/',''))=4 ;

ID: 83
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: Tabellenstruktur kopieren
Code: CREATE TABLE zieltabelle SELECT * FROM quelltabelle WHERE ID=-1;

ID: 130
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: CSV erstellen
Code: -- http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat SELECT R.TITEL AS TITEL ,R.ANLEITUNG AS ANLEITUNG ,GROUP_CONCAT(CONCAT(CAST(RZ.MENGE AS CHAR),' ',RZ.EINHEIT,' ' ,Z.ZUTAT) SEPARATOR ',') AS ZUTATEN ,R.NOTIZ AS NOTIZ FROM REZEPT AS R LEFT JOIN REZEPT_HAS_ZUTAT AS RZ ON R.ID=RZ.REZEPT_ID LEFT JOIN ZUTAT AS Z ON RZ.ZUTAT_ID=Z.ID AND RZ.REZEPT_ID=R.ID

ID: 205
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Tagesname
Code: SELECT DAYNAME(NOW()); -- Monday SELECT DAYNAME('2014-08-10'); -- Sunday -- To get localized names switch the parameter, e.g. to German SET lc_time_names = 'de_DE'; SELECT DAYNAME('2014-08-10'); -- Sonntag

ID: 206
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: Tabelle DB übergreifend kopieren
Code: DROP TABLE IF EXISTS `DestinationDB`.`Table1`; CREATE TABLE `DestinationDB`.`Table1` SELECT * FROM `SourceDB`.`Table1`;