add a new column into a database

i'm using a matlab tutorial database i have tried to add new column to salesvolume table by using this code
a=exec(conn,'ALTER TABLE salesVolume ADD Nkey number(30)') but the new column hasn't been added in the original table , so i can't add variables to this column

回答(1 个)

Hi,
if you take a look at a.Message, do you see an error message from the database server?
Titus

1 个评论

no there isn't any error message
my new column contains the summation of the same row

请先登录,再进行评论。

提问:

2012-2-7

编辑:

2013-10-15

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by