MySQL Forums
Forum List  »  Newbie

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.

Options: ReplyQuote


Subject
Written By
Posted
CREATE TABLE does not get updated
February 06, 2023 12:55PM


Sorry, you can't reply to this topic. It has been closed.

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.