Sorry the lines and error were "hidden" in my last message. The 3 lines typed in the browser query are:
create temporary table ttable1 (select * from testnames where ref='ABCDE'); update ttable1 set ref='12345678'; select * from ttable1; cursor on 1st line , click execute - no error cursor on 2nd line , click execute - error table does not exist mydb.ttable1 cursor on 3rd line , click execute - error table does not exist mydb.ttable1 So my gues is that the browser executes the 1st line then after completion of the statement the temp table is destroyed. i.e. guessing 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 data and putting into other table Kerry, Post the error you get. First select the database you are going to use in the right panel. execute the create table statement. update the table. execute the select statement as last. Saravanan --- On Sat, 1/19/08, Kerry Frater <[EMAIL PROTECTED]> wrote: > From: Kerry Frater <[EMAIL 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 > 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] ____________________________________________________________________________ ________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
