Answer / Akash Avasthini

There are several tools available to draw ER diagrams for MySQL. Here are some popular ones:n
1. Lucidchart - A web-based visual workspace that supports creating and sharing ER diagrams.
2. drawsql - An open-source tool for generating ER diagrams based on your SQL scripts.
3. MySQL Workbench - A free, open-source GUI tool provided by Oracle for designing databases and creating ER diagrams.
4. ER Diagram Designer - A paid tool from Sparx Systems that offers advanced features for modeling complex database relationships.

What is sql select statement?

1 Answers  

---

sql query to get zero records from a table having n no of records

8 Answers   CTS,

---

what is a constraint? Tell me about its various levels. : Sql dba

1 Answers  

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

how to insert the records in particular position

1 Answers  

---

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

---

what is a stored procedure? : Sql dba

1 Answers  

---

in procedure how to return a value

3 Answers   Wipro,

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

How to fetch common records from two tables?

1 Answers  

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

what is a cursor? : Sql dba

1 Answers  

---