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 http://

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

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 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 decode function do

Re: Another Inserting Multiple Values with Set Problem

On Fri, Jan 8, 2010 at 9:29 AM, Thiyaghu CK 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) > values(('Small,Medium,XSmal

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: Export into txt file (comma delimited)

- Rodrigo A. de Brito Bastos 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 outfile"C:\\Documents and Settings\\rbastos\\Meus d

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 outfile"C:\\Documents and Settings\\rbastos\\Meus documentos\\teste.txt" Thanks in advance! Rodrigo

FW: MySQL export and import into Oracle

Hi guys, Can you please assist me in rewriting this query in order to run this against a mysql database? It seems that the decode function does not exist in mysql. select decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No') email_corr, count(*) tot from profiles where email i

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, > R

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: Another Inserting Multiple Values with Set Problem

On Fri, Jan 8, 2010 at 2:26 AM, Thiyaghu CK 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 OK, 1 row

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 ent