Answer / Abhishek Swaroop

To dump a table from MySQL, use the mysqldump utility. Here's an example: `mysqldump -u username -p password your_database_name your_table_name > backup.sql`

Where is the mysql config file?

1 Answers  

---

How to delete a database from mysql server.

1 Answers  

---

How do you connect MySQL database with PHP?

1 Answers  

---

A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.

1 Answers  

---

What is the difference between primary and unique key

5 Answers   CSC,

---

If you wish to encrypt the username and password using php, how will you do that?

1 Answers  

---

What is inner join in mysql?

1 Answers  

---

How do I declare a variable in mysql?

1 Answers  

---

What is the maximum length of a table name, a database name, or a field name in MySQL?

4 Answers  

---

How many tables will create when we create table, what are they?

2 Answers  

---

What is the default port for MySQL Server?

1 Answers  

---

What is limit in mysql?

1 Answers  

---