what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

0 Answers  

---

how will you find out the last three records in a table with n no of records and delete them

3 Answers  

---

Does view contain data?

0 Answers  

---

How to fetch common records from two tables?

1 Answers  

---

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 I save the results of sql query in a file?

0 Answers  

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

What is ROWID?

8 Answers  

---

What is dynamic query?

0 Answers  

---

What is the difference between unique and primary key constraints?

0 Answers  

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,

---

what is the difference between a local and a global temporary table? : Sql dba

0 Answers  

---