RE: Trancate table from command line?
>-Original Message- >From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com] >Sent: Wednesday, March 17, 2010 10:07 AM >To: '??? '; 'John Oliver' >Cc: mysql@lists.mysql.com >Subject: RE: Trancate table from command line? > >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 > [JS] Obviously, I meant "truncate table sometable". >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:ekilimc...@gmail.com] >>Sent: Wednesday, March 17, 2010 1:57 AM >>To: John Oliver >>Cc: mysql@lists.mysql.com >>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 >> >>> 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 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/mysql?unsub=ekilimc...@gmail.com >>> >>> >> >> >>-- >>Best regards, >> >>Eugene Kilimchuk > > > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe:http://lists.mysql.com/mysql?unsub=jschwa...@the- >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Trancate table from command line?
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:ekilimc...@gmail.com] >Sent: Wednesday, March 17, 2010 1:57 AM >To: John Oliver >Cc: mysql@lists.mysql.com >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 > >> 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 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/mysql?unsub=ekilimc...@gmail.com >> >> > > >-- >Best regards, > >Eugene Kilimchuk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Trancate table from command line?
John I think you can do this way on shell: mysql -h db_server -u user -pPASSWORD -e "truncate table table1" Carlos Eduardo Caldi > Date: Tue, 16 Mar 2010 14:12:42 -0700 > From: joli...@john-oliver.net > To: mysql@lists.mysql.com > Subject: Trancate table from command line? > > 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 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/mysql?unsub=ce_ca...@hotmail.com > _ Não deixe rastros ao navegar na Internet. Instale Grátis o Internet Explorer 8 agora. http://go.microsoft.com/?linkid=9707132
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 > 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 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/mysql?unsub=ekilimc...@gmail.com > > -- Best regards, Eugene Kilimchuk
Re: Trancate table from command line?
On Tue, Mar 16, 2010 at 02:12:42PM -0700, John Oliver wrote: > 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 truncate table > table1 ? Just to leave an answer behind for the next character who runs into this... for i in table1 table2 table3 ; do mysql -h db_server -u user -pPASSWORD -e "truncate table $i" DATABASE; done -- *** * 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/mysql?unsub=arch...@jab.org
