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.
Dim longStr = "This is a long string"
Dim searchFor = "long"
position = InStr( longStr, searchFor )
6
MySQL
Datum, Zeit
Aktuelles Datum/Uhrzeit
SELECT NOW();
INSERT INTO table (datetime) VALUES (NOW());
10
MySQL
Datenbank
Lesen Datensatzes
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%';
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'
;
287
MySQL
Strings
Anzahl an Zeichen in einem String ermitteln
-- 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
;
83
MySQL
Datenbank
Tabellenstruktur kopieren
CREATE TABLE zieltabelle SELECT * FROM quelltabelle WHERE ID=-1;
130
MySQL
Datenbank
CSV erstellen
-- 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
205
MySQL
Datum, Zeit
Tagesname
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
206
MySQL
Datenbank
Tabelle DB übergreifend kopieren
DROP TABLE IF EXISTS `DestinationDB`.`Table1`;
CREATE TABLE `DestinationDB`.`Table1` SELECT * FROM `SourceDB`.`Table1`;
