Answer / Indrajeet

To load data files into tables using mysqlimport, you can follow these steps:
1. Install mysqlimport on your system if it is not already installed.
2. Navigate to the directory containing your SQL file.
3. Run the command: `mysqlimport --local --user=username --password=password --host=localhost database_name tablename filename` where username and password are your MySQL credentials, localhost is the host name of your MySQL server, database_name is the name of the database to which you want to import the data, tablename is the name of the table into which you want to load the data, and filename is the name of the SQL file containing the data.
4. If the import is successful, you will see a message saying 'Number of rows: xxx', where xxx is the number of rows in your data file.

Can a table contain multiple primary key’s?

1 Answers  

---

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

---

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1 Answers  

---

cursor types? explain with example programs?

1 Answers   HP,

---

What is pls integer?

1 Answers  

---

Why select is used in sql?

1 Answers  

---

What is lexical units in pl sql?

1 Answers  

---

How does a trigger work?

1 Answers  

---

What are the different types of tables in sql?

1 Answers  

---

explain normalization concept? : Sql dba

1 Answers  

---

What is the difference between stored procedure and view?

1 Answers  

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1 Answers  

---