adspace


How do I clear a mysql database?

Answer Posted / Kumar Abhinav

To clear or delete all data from a MySQL database, you can use the TRUNCATE TABLE command. Here's an example:

```sql
USE <database_name>;
TRUNCATE <table_name>;
```

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to Change a users password from unix shell.

1223


What is the current mysql version?

1105


Which statement is used in a select query for partial matching?

1247


What is current version of mysql?

1084