Answer / Ram Kumar

In SQL, there are three main categories of queries: Data Manipulation Language (DML) queries (SELECT, INSERT, UPDATE, DELETE), Data Definition Language (DDL) queries (CREATE, ALTER, DROP), and Data Control Language (DCL) queries (GRANT, REVOKE).

if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 Answers  

---

What is index length in mysql?

1 Answers  

---

write a query to mysql in safe mode and to change the root password

1 Answers  

---

How do I edit a table in mysql?

1 Answers  

---

What does tee command do in MySQL?

1 Answers  

---

What is username in mysql?

1 Answers  

---

Write a query to create a database and a table?

1 Answers  

---

How to drop an existing index in mysql?

1 Answers  

---

Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 Answers  

---

Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

1 Answers  

---

How can increase the performance of MySQL select query?

3 Answers   RV Technologies, Span Systems,

---

How do I restore a mysql database?

1 Answers  

---