PDA

View Full Version : proper syntax for adding a row in table with vB SQL


Tekton
09-16-2004, 11:51 PM
I can find examples of adding fields to a table, but not adding a new row and then the values that go with it. Anyone got one that can work in a "vB sql" php page?

Tekton
09-18-2004, 12:08 AM
...I guess noone knows? *shrugs*

Warlord
09-18-2004, 02:10 AM
I'm very new to doing anything other than copying and pasting commands in mysql, but I think to add a column to and existing table it would be:


ALTER TABLE whateverthetablenameis ADD nameofextracolumn smallint(4) default NULL


Can I see what your current table looks like and what you're trying to add?

CarCdr
09-18-2004, 01:08 PM
<a href="http://dev.mysql.com/doc/mysql/en/INSERT.html" target="_blank">http://dev.mysql.com/doc/mysql/en/INSERT.html</a>