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"
Author by
Neha Mangla
Updated on June 24, 2022Comments
-
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 over 9 yearsThanks for the solution :)