PDA

View Full Version : Probably an obvious question


NeoMoon
11-28-2008, 08:17 PM
Okay, so I'm trying to insert data into 2 tables, with the same fields, in the same query. Is that possible?

Something like "INSERT INTO `table1`, `table2` VALUES ('blah', 'blah');"

SIDE QUESTION: What exactly does NULL do in an insert into? I can't find anything on this, so I was wondering: Does it set the value of the field to something that isn't already used by the same field in all of the other rows? Or is it just treated as 'nothing'.

guelphdad
11-29-2008, 06:32 AM
why do you have two tables?

NeoMoon
11-29-2008, 06:48 AM
why do you have two tables?

One table corresponds with the values of the other table.

194673
11-29-2008, 10:10 AM
Eh? I think what guelphdad was getting at is that you basically have two identical tables, which I can't for any reason understand why this would be necessary.