truncate table via command line in Linux

12,598

Solution 1

You can use mysql command line client to do it

mysql -h dbserver_hostname -e "truncate table schema_name.table_name"

Solution 2

localhost=hostname
root=username
''=password
demo=db name
language=table name   

#to truncate a table from database
mysql -h localhost -u root -p'' demo -e "truncate table demo.language"
Share:
12,598
Neha Mangla
Author by

Neha Mangla

Updated on June 24, 2022

Comments

  • Neha Mangla
    Neha Mangla over 1 year

    I want to truncate one of my db table using mysqldump command so that I can place that command in sh file for executing it on daily basis. Do any one know about this command? Thanks in advance

  • Neha Mangla
    Neha Mangla over 9 years
    Thanks for the solution :)