Breaking News: Grepper is joining You.com. Read the official announcement!

command to truncate a database

Jason M Potter answered on October 16, 2023 Popularity 8/10 Helpfulness 3/10

answer command to truncate a database

command to truncate a database

Comment

#Drop (i.e. remove tables)
mysql -Nse 'show tables' DATABASE_NAME | while read table; do mysql -e "drop table $table" DATABASE_NAME; done

#Truncate (i.e. empty tables)
mysql -Nse 'show tables' DATABASE_NAME | while read table; do mysql -e "truncate table $table" DATABASE_NAME; done

Popularity 8/10 Helpfulness 3/10 Language shell

Source: Grepper

Tags: command database shell truncate

Link to this answer
Share Copy Link

Contributed on Oct 16 2023

Jason M Potter

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

command to truncate a database

Contents

More Related Answers

command to truncate a database

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.