CODEWITHSUNDEEP
phpsql
praba
praba

Reputation: 1

Alter the table inserted value

disease_category

cat_id      cat_name            sub_id          sub_name 

1         Infect Disease           1             head   
1         Infect Disease           2            development de

how to alter the sub_name development de into development delay?

how to insert new column C_id as primary key & auto_increment?

Upvotes: 0

Views: 58

Answers (1)

R R
R R

Reputation: 2956

how to alter the sub_name development de into development delay?

Answer:You need to use update query.

update tablename
set sub_name='development delay'
where sub_name='development de'

2nd question:

ALTER TABLE tablename ADD c_id INT PRIMARY KEY AUTO_INCREMENT;

Upvotes: 1

Related Questions