Skip to content

Instantly share code, notes, and snippets.

View bakkerjs's full-sized avatar

bakkerjs

View GitHub Profile
@bakkerjs
bakkerjs / gist:1210942
Created September 12, 2011 09:51
SELECT SUM( factuurnr ) FROM bestellingen
SELECT SUM( factuurnr ) FROM bestellingen
@bakkerjs
bakkerjs / gist:1210937
Created September 12, 2011 09:47
SELECT SUM( factuurnr ) FROM bestellingen WHERE klant = 'wim'
SELECT SUM( factuurnr ) FROM bestellingen WHERE klant = 'wim'
@bakkerjs
bakkerjs / gist:1210918
Created September 12, 2011 09:29
DELETE FROM `voorraad` WHERE product='appels'
DELETE FROM `voorraad` WHERE product='appels'
@bakkerjs
bakkerjs / gist:1191271
Created September 3, 2011 14:33
UPDATE bestellingen SET klant='Joop' postcode='6756be' WHERE factuurnr=9
UPDATE bestellingen SET klant='Joop' postcode='6756be' WHERE factuurnr=9
@bakkerjs
bakkerjs / gist:1191263
Created September 3, 2011 14:27
UPDATE bestellingen SET klant='Joop' WHERE factuurnr=9
UPDATE bestellingen SET klant='Joop' WHERE factuurnr=9
@bakkerjs
bakkerjs / gist:1184129
Created August 31, 2011 17:30
1 rij toegevoegd. ( Query duurde 0.0846 sec )
1 rij toegevoegd. ( Query duurde 0.0846 sec )
@bakkerjs
bakkerjs / gist:1184127
Created August 31, 2011 17:29
INSERT INTO bestellingen (factuurnr,postcode) VALUE ('9','5427de')
INSERT INTO bestellingen (factuurnr,postcode) VALUE ('9','5427de')
@bakkerjs
bakkerjs / gist:1184121
Created August 31, 2011 17:26
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
@bakkerjs
bakkerjs / gist:1184120
Created August 31, 2011 17:25
INSERT INTO bestellingen VALUE ('9','5427de')
INSERT INTO bestellingen VALUE ('9','5427de')
@bakkerjs
bakkerjs / gist:1184094
Created August 31, 2011 17:17
INSERT INTO bestellingen (factuurnr,klant,postcode) VALUE ('9','Wim','5427de')
INSERT INTO bestellingen (factuurnr,klant,postcode) VALUE ('9','Wim','5427de')