Am I missing something? Doesn't the -e parameter for the mysql CLI still work? I use it all the time in my scripts.
mysql -ulogin -ppassword -e "truncate sometable" your_dbname Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com >-----Original Message----- >From: ??????? ???????? [mailto:[email protected]] >Sent: Wednesday, March 17, 2010 1:57 AM >To: John Oliver >Cc: [email protected] >Subject: Re: Trancate table from command line? > >If you use *nix, you can use this form: > >*echo* "TRUNCATE TABLE you_table_name;" | *mysql* -A your_db_name -ulogin >-ppassword > >And: > >*cat* your_file.sql | *mysql* -A your_db_name -ulogin -ppassword > > >2010/3/17 John Oliver <[email protected]> > >> Is there a way to use mysqladmin (or mysql) to truncate a table as a >> one-off command from the command line? >> >> I have an issue with importing data from one database into another, but >> the second database might have columns that the first did not. >> >> On database 1, I use mysqldump to grab certain tables, and when I try to >> simply "overlay" those tables onto the new database, I get an error >> >> ERROR 1062 (23000) at line 24: Duplicate entry '378-4' for key 1 >> >> So we're thinking we should truncate the table first, but it appears >> this must be done manually in the mysql> shell, which won't work... this >> operation needs to be scripted, or to be presented as one command line >> that can be copy-and-pasted. >> >> How can I do something like : >> >> mysqladmin -h db_server -u user -pPASSWORD <DATABASE> truncate table >> table1 ? >> >> -- >> *********************************************************************** >> * John Oliver http://www.john-oliver.net/ * >> * * >> *********************************************************************** >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/[email protected] >> >> > > >-- >Best regards, > >Eugene Kilimchuk <[email protected]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
