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

MySql' 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_schem

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

uessing that browser creates 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 d

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

u must do the same for Testdb Database) HTH M- - Original Message - From: "Kerry Frater" <[EMAIL PROTECTED]> To: "'Sebastian Mendel'" <[EMAIL PROTECTED]>; "'MySql'" Sent: Friday, January 18, 2008 10:03 AM Subject: RE: creati

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

r <[EMAIL PROTECTED]> > Subject: RE: creating temp file, modifying data and putting into other table > To: [EMAIL PROTECTED], "'Sebastian Mendel'" <[EMAIL PROTECTED]>, "'MySql'" > > Date: Saturday, January 19, 2008, 12:45 AM > Y

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

7;; [EMAIL PROTECTED] 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 Frat

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

that why I am getting > problems and I > should be testing 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

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

nd I should be testing 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

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

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 archi

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

rom: Jochem van Dieten [mailto:[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

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 a table into another whilst making a > modification. > create temporary table Ttable1 (select * from masterlist where ref='ABCDE');