Answer / guest

I. to modify datatype of a column ?
ii. to add a column with NOT NULL constraint ?

To Modify the datatype of a column the column must be empty.

To add a column with NOT NULL constrain, the table must be
empty.

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

How do you assign Construct the where clause without concatenating Field,value pairs?

1 Answers   Microsoft,

---

how u can find the n row from a table?

19 Answers   Tech Mahindra,

---

how to shutdown mysql server? : Sql dba

0 Answers  

---

Is sql a backend language?

0 Answers  

---

---

What is the use of double ampersand (&&) in sql queries? Give an example

0 Answers  

---

What are the types of join in sql?

0 Answers  

---

How many sql statements are used? Define them.

0 Answers  

---

What are the commands used in sql?

0 Answers  

---

What are the different types of triggers?

0 Answers  

---

What is an inner join sql?

0 Answers  

---

What are the steps for performance tuning.

0 Answers  

---