Data handling during exports

Good day all... I have some questions regarding data handling when doing exports in mysql. This is a follow up on my mails yesterday about the exports within a cron. What we found now was places where the users for instance manually

Re: Another Inserting Multiple Values with Set Problem

On Fri, Jan 8, 2010 at 2:26 AM, Thiyaghu CK theyaho...@gmail.com wrote: Hi Victor, You have given space after the comma(shown here: ('Small, Medium, XSmall')). Take out the space and try, it will work. Example: mysql insert into products(sizes) values ('Small,Medium,small,medium'); Query

Rename mysql database

Hi All,I want to rename my database. but as per the mysql documentation it says, RENAME DATABASE command has been removed from mysql 5.1.Can anyone help me with this, that is there any other way I can rename it. Thanks in advance.--Regards, Manasi Save

Re: Rename mysql database

You can try this one. http://preetul.wordpress.com/2009/07/27/rename-database-in-mysql/ Note: I have not tested. On Fri, Jan 8, 2010 at 5:04 PM, Manasi Save manasi.s...@artificialmachines.com wrote: Hi All, I want to rename my database. but as per the mysql documentation it says, RENAME

Export into txt file (comma delimited)

Hey guys! Is there a way to export a table into a txt file but delimited *with comma*? I'm using this expression: select * from ae_a222 where ano=2009 and dia_juliano between '1' and '365' into outfileC:\\Documents and Settings\\rbastos\\Meus documentos\\teste.txt Thanks in advance! Rodrigo

Re: Export into txt file (comma delimited)

- Rodrigo A. de Brito Bastos rodrigo...@gmail.com wrote Hey guys! Is there a way to export a table into a txt file but delimited *with comma*? Hello! you can use this syntax: select * from ae_a222 where ano=2009 and dia_juliano between '1' and '365' into outfileC:\\Documents and

Re: Another Inserting Multiple Values with Set Problem

Hi Victor, Take out the double quotes from[ ('Small,Medium,XSmall'), ('teal_E2725B,black_FF,yellow_9ACD32')]. Its working fine for me. mysql insert into products (sizes, colorsShadesNumbersShort) values(('Small,Medium,XSmall'), ('teal_E2725B,black_FF,yellow_9ACD32')); Query OK, 1 row

Re: Another Inserting Multiple Values with Set Problem

On Fri, Jan 8, 2010 at 9:29 AM, Thiyaghu CK theyaho...@gmail.com wrote: Hi Victor, Take out the double quotes from[ ('Small,Medium,XSmall'), ('teal_E2725B,black_FF,yellow_9ACD32')]. Its working fine for me. mysql insert into products (sizes, colorsShadesNumbersShort)

Re: FW: MySQL export and import into Oracle

http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_if On Fri, Jan 8, 2010 at 5:52 PM, machiel.richards machiel.richa...@gmail.com wrote: Hi guys, Can you please assist me in rewriting this query in order to run this against a mysql database? It seems that the

Re: Export into txt file (comma delimited)

HI, Just add this at the end of your command fields termininated by ',' like below, select * from ae_a222 where ano=2009 and dia_juliano between '1' and '365' into outfile C:\\Documents and Settings\\rbastos\\Meus documentos\\teste.txt fields termininated by ',' ; - Partha www.mafiree.com

RE: FW: MySQL export and import into Oracle

Thank you for the link but seeing that I am still new with MySQL , this does not mean anything to me. From: prabhat kumar [mailto:aim.prab...@gmail.com] Sent: 08 January 2010 4:22 PM To: machiel.richards Cc: mysql@lists.mysql.com Subject: Re: FW: MySQL export and import into Oracle