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]