Code Forums - View Single Post - Setting a field equal to the row count of another table

l33t_1-1axx0r · 04-02-2006, 10:05 PM

Maybe I'm a little confused as to what you're asking, but it seems that the number of comments and the blog information is seperate... so you'd never need to update two tables at once. Instead, maybe have a field in the comments table that holds the ID of the blog it corresponds to...

A little more detail on how you're structuring may help.

As for the autoincrementing, just add NOT NULL AUTO_INCREMENT to the column when you create the tables.

e.g.

Code:

CREATE TABLE foo (
     id INT NOT NULL AUTO_INCREMENT,
     bar CHAR(30),
     PRIMARY KEY (id)
);

04-02-2006, 10:05 PM	#2 (permalink)
l33t_1-1axx0r Huzzah! Join Date: Feb 2006 Posts: 8	Maybe I'm a little confused as to what you're asking, but it seems that the number of comments and the blog information is seperate... so you'd never need to update two tables at once. Instead, maybe have a field in the comments table that holds the ID of the blog it corresponds to... A little more detail on how you're structuring may help. As for the autoincrementing, just add NOT NULL AUTO_INCREMENT to the column when you create the tables. e.g. Code: CREATE TABLE foo ( id INT NOT NULL AUTO_INCREMENT, bar CHAR(30), PRIMARY KEY (id) );