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>
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.