var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Insert ... Set -> Ansi ?
The question is in the title.
Can I do
with ANSI92 compliant DB ?
key1 = value1
key2 = value1
That would be the syntax for UPDATE:
For INSERT you will need the following syntax:
UPDATE theTable SET key1 = value1, key2 = value2
Details in the manual for insert and for update.
INSERT INTO theTable
The question is: do you want to create a new row, or change (update) an existing one?
i think gtk just wants to INSERT
i'm guessing the previous experience was mysql
INSERT SET syntax is non-standard, mysql-proprietary
Ok thank you Rudy, you are right.
Now I wonder why don't they implement this syntax.
It seems to me to be slightly more maintainable, simple
and compatible with UPDATE for single row INSERTs.
Well, the question is rather: why on earth did MySQL choose to implement a completely new and in-compatible syntax if there is already a well defined standard for this?
For the INSERT, MySQL have implemented both syntaxes since quite a long time.
And I don't think that their aim is to manage a new syntax before the standard.