RE: creating temp file, modifying data and putting into other table

2008-01-21 Thread Kerry Frater
a session to execute the line in? Kerry -Original Message- From: Saravanan [mailto:[EMAIL PROTECTED] Sent: 18 January 2008 18:18 To: 'Sebastian Mendel'; 'MySql'; [EMAIL PROTECTED] Subject: RE: creating temp file, modifying data and putting into other table Kerry, Post the error you get

RE: creating temp file, modifying data and putting into other table

2008-01-21 Thread Kerry Frater
' Subject: Re: creating temp file, modifying data and putting into other table the default DB is mysql to verify execute mysql client and then show the databases mysql show databases; ++ | Database | ++ | information_schema | | catalog

Re: creating temp file, modifying data and putting into other table

2008-01-18 Thread Jochem van Dieten
On Jan 17, 2008 9:02 PM, Kerry Frater wrote: Thanks for the input Jochem. If you wish to ignore my code and continue with your own code that of course is fine with me. But why do you expect me to continue to help you if you ignore me anyway? Jochem -- MySQL General Mailing List For list

RE: creating temp file, modifying data and putting into other table

2008-01-18 Thread Saravanan
January 2008 13:24 To: [EMAIL PROTECTED]; 'MySql' Subject: Re: creating temp file, modifying data and putting into other table Kerry Frater schrieb: Can someone please advise. I am looking to create a multiuser friendly way of getting a subset number of rows from a table into another

RE: creating temp file, modifying data and putting into other table

2008-01-18 Thread Kerry Frater
] Subject: RE: creating temp file, modifying data and putting into other table Hi, Are you using mysql browser? If yes. It will run only the current line statement. It will not execute all the three statements. So try one after the other. Saravanan --- On Fri, 1/18/08, Kerry Frater [EMAIL PROTECTED

RE: creating temp file, modifying data and putting into other table

2008-01-18 Thread Kerry Frater
in another way? Kerry -Original Message- From: Sebastian Mendel [mailto:[EMAIL PROTECTED] Sent: 18 January 2008 13:24 To: [EMAIL PROTECTED]; 'MySql' Subject: Re: creating temp file, modifying data and putting into other table Kerry Frater schrieb: Can someone please advise. I am looking

Re: creating temp file, modifying data and putting into other table

2008-01-18 Thread Martin Gainty
do the same for Testdb Database) HTH M- - Original Message - From: Kerry Frater [EMAIL PROTECTED] To: 'Sebastian Mendel' [EMAIL PROTECTED]; 'MySql' mysql@lists.mysql.com Sent: Friday, January 18, 2008 10:03 AM Subject: RE: creating temp file, modifying data and putting into other table I

RE: creating temp file, modifying data and putting into other table

2008-01-18 Thread Saravanan
PROTECTED] Subject: RE: creating temp file, modifying data and putting into other table To: [EMAIL PROTECTED], 'Sebastian Mendel' [EMAIL PROTECTED], 'MySql' mysql@lists.mysql.com Date: Saturday, January 19, 2008, 12:45 AM Yes it is the mysql browser. I have tried one after the other with the same

Re: creating temp file, modifying data and putting into other table

2008-01-18 Thread Sebastian Mendel
Kerry Frater schrieb: Can someone please advise. I am looking to create a multiuser friendly way of getting a subset number of rows from a table into another whilst making a modification. I thought that this could be done using a temporary table in a batch script that is unique to that session

Re: creating temp file, modifying data and putting into other table

2008-01-17 Thread Jochem van Dieten
On Jan 17, 2008 2:22 PM, Kerry Frater wrote: Can someone please advise. I am looking to create a multiuser friendly way of getting a subset number of rows from a table into another whilst making a modification. create temporary table Ttable1 (select * from masterlist where ref='ABCDE');

RE: creating temp file, modifying data and putting into other table

2008-01-17 Thread Kerry Frater
:[EMAIL PROTECTED] Sent: 17 January 2008 19:34 To: MySql Subject: Re: creating temp file, modifying data and putting into other table On Jan 17, 2008 2:22 PM, Kerry Frater wrote: Can someone please advise. I am looking to create a multiuser friendly way of getting a subset number of rows from