coopster - 9:06 pm on Jul 5, 2011 (gmt 0)

Second syntax example is almost exactly what you typed in your second post ...

INSERT INTO test SET name = 'sam', age = 34;