Yes it is the mysql browser. I have tried one after the other with the same result.
So it looks as though I am using the wrong testbed Kerrry -----Original Message----- From: Saravanan [mailto:[EMAIL PROTECTED] Sent: 18 January 2008 15:12 To: 'Sebastian Mendel'; 'MySql'; [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 Frater <[EMAIL PROTECTED]> wrote: > From: Kerry Frater <[EMAIL PROTECTED]> > Subject: RE: creating temp file, modifying data and putting into other table > To: "'Sebastian Mendel'" <[EMAIL PROTECTED]>, "'MySql'" <mysql@lists.mysql.com> > Date: Friday, January 18, 2008, 9:33 PM > I have just tried it with lowercase with the same result. > > To test I have opened up the query browser and typed 3 > lines > > create temporary table ttable1 (select * from testnames > where ref='ABCDE'); > update ttable1 set ref='12345678'; > select * from ttable1; > > I leave the cursor on the 3rd line and click on execute. I > get the result > > Testdb.ttable1 doesn't exist error 1146 > > If I leave the cursor on the first line then it appears to > execute the first > line as I do not get an error but no data is shown. > > Does the browser run a script? Is 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 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 e.g. > > > > create temporary table Ttable1 (select * from > masterlist where > ref='ABCDE'); > > update Ttable1 set ref='SMI0C001'; > > insert into sublist select * from Ttable1; > > drop Ttable1; > > > > I know the above syntax doesn't work but it shows > the steps I am looking > to > > take. > > > > Hope this makes enough sense to be able to answer. > > did you tried with lowercase table names (ttable1) too? > > -- > Sebastian > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] ____________________________________________________________________________ ________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
