New Table

[Anon]

I have multiple table joins already.

I have some new fields that need to be in a new table. Is there a way that I can build a table that already has the same amount of rows as my other tables?

or

Do I have to input to this new table the same amount of times to match the same amount of rows?

[kurtsu]

Depends on the database; with most SQL databases, you can create the new table structure, then use 'select into' to move the data from the old table to the new on with one SQL command.

[Anon]

Yeah this new table is actually and add on.
(New Data) and the primary key fields need to match.

So I have the user info fields in one table
and the new table will have all additional info that I did not include in the first table. So the primary keys will join the tables together.

I ended up just inserting blank data over 200 times so that I would have an equal amount of rows in the second table.

The database is small so it's not that big of deal at this point but if it had over 10,000 entries it would become a huge deal to add on other additional tables with the same amount of rows.

Thanks for your help.