Re: DBI, add fields to existing table?

UPDATE adds rows to an existing table. What you seem to be looking for is altering the table's schema instead, which is usually accomplished by the ALTER TABLE syntax.

Here's the manpage for MySQL's way of doing that.

Comment on Re: DBI, add fields to existing table? Select or Download Code

Replies are listed 'Best First'.
Re^2: DBI, add fields to existing table? by castaway (Parson) on Aug 13, 2005 at 20:30 UTC
`UPDATE` changes contents of an existing table. `INSERT` adds them. C.	[reply] [d/l] [select]
Re^2: DBI, add fields to existing table? by pg (Canon) on Aug 13, 2005 at 22:21 UTC
"What you seem to be looking for is altering the table's schema instead" To most of the people, schema is a way to group database components. The OP is not trying to alter "schema". To be more precise, he is trying to modify the table definition.	[reply]