CREATE TABLE does not get updated
Posted by:
Syed Huq
Date: February 06, 2023 12:55PM
Hi
I created a databased and then added a table to that:
create table birthday_1 (id integer primary key, name text, birth_year year);
insert into birthday_1 values (1, "Rathon" , 1963);
select * from birthday_1
The above is working fine. Then I add a new Column to the table called "Age") as shown below:
create table birthday_1 (id integer primary key, name text, birth_year year, age int);
insert into birthday_1 values (1, "Rathon", 1963, 35);
select * from birthday_1
Error Code 1136: Coulmn count doesnt match value count at row 1
Why is the table not accepting my new column that I added ?
Pls help.
Subject
Written By
Posted
CREATE TABLE does not get updated
February 06, 2023 12:55PM
February 06, 2023 06:41PM
February 07, 2023 08:16AM
February 07, 2023 05:11PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.