INSERT INTO users SET username='pv',wachtwoord='5a105e8b9d40e1329780d62ea2265d8a'
INSERT INTO users SET username='pv',wachtwoord='5a105e8b9d40e1329780d62ea2265d8a'
INSERT INTO users SET username='pv',wachtwoord='5a105e8b9d40e1329780d62ea2265d8a'
INSERTINTO users SET username='pv',wachtwoord='5a105e8b9d40e1329780d62ea2265d8a'
INSERTINTO users SET username='pv',wachtwoord='5a105e8b9d40e1329780d62ea2265d8a'
INSERTINTO users SET username='pv',wachtwoord='5a105e8b9d40e1329780d62ea2265d8a'
Als ik deze in PHPmyADMIN invul krijg ik de error
ERROR: Ongeldig herkenningsteken
INSERT INTO sometable
SET field1 = 'value1',
field2 = 'value2',
field3 = 'value3'
Citaat:
We think there's something wrong with this syntax because it is not part of the SQL specifications, as far as I can see. Not that language extensions by themself are a bad thing, but one that replicates an extraordinarily well known method seems silly.
Citaat:
This is a nice way and works well. 1 word of caution though, if you want your code to be more universal I would stick to the INSERT INTO and VALUES since this will work both in access and SQL.