Gossamer Forum
Home : Products : Gossamer Links : Pre Sales :

SQL INSERT

Quote Reply
SQL INSERT
In admin.cgi -> sub alternate_categories there is:

$db->do ("INSERT INTO CategoryAlternates (LinkID, CategoryID) VALUES($id, $add_to)");

But the table is defined:

CategoryID | LinkID


So it seems it is not important in which order i do my INSERT?
Or is it need from end to begin?

Could i do something like:

INSERT INTO gaga (ROW3, ROW1, ROW2) VALUES (value3, value1, value2)
or
INSERT INTO gaga (ROW1, ROW3, ROW2) VALUES (value1, value3, value2)
or ...

So this would mean it is only important to hold the order right for
(ROWs(Values)).

???
Robert

Subject Author Views Date
Thread SQL INSERT Robert 3593 Jul 29, 2000, 10:50 AM
Thread Re: SQL INSERT
pugdog 3535 Jul 29, 2000, 12:54 PM
Thread Re: SQL INSERT
Robert 3511 Jul 29, 2000, 7:33 PM
Post Re: SQL INSERT
pugdog 3493 Jul 29, 2000, 9:18 PM