RE: get table name from select staement as output as field

2003-03-29 Thread Don Read
On 30-Mar-2003 Daniel Rossi wrote: > hi guys is this possible ? select tablename1 as table1, id from > tablename1 , tablename2 ? > select 'tablename1' as table1, id from ... Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So

get table name from select staement as output as field

2003-03-29 Thread Daniel Rossi
hi guys is this possible ? select tablename1 as table1, id from tablename1 , tablename2 ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

OS X install for Unix dummy

2003-03-29 Thread Ken Tozier
I just downloaded and installed the "mysql-max-4.0.12.pkg", ran cd /usr/local/mysql sudo ./bin/mysqld_safe (Enter your password) (Press CTRL+Z) (Press CTRL+D to exit the shell) bg as specified in the readme. When attempting to set the root password, I successfully ran /usr/local/mysql/b

Re: embedded select / left join question

2003-03-29 Thread Bruce Feist
Jim Miller wrote: I want to do a join and select of these tables that will give me all the Entrants who did NOT enter contest 1 (i.e., Mary and Bill). Try: select entrant.name from entrant left join contestEntries on entrant.id = contestEntries.entrant AND contestEntries.ContestN

Cannot connect to mysql server

2003-03-29 Thread Reuben D. Budiardja
Hello, I have an interesting problem. I installed mysql client and server from Redhat 7.3 RPM. Then I set up a username and password for a user monty (to use example from the manual). Then I grant priveleges for the user with: mysql> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] ->

RE: Nested SQL QUERY

2003-03-29 Thread Peter Lovatt
HI MySQL does not support sub selects/nested queries :( Peter -Original Message- From: Eric Leupold [mailto:[EMAIL PROTECTED] Sent: 29 March 2003 16:43 To: [EMAIL PROTECTED] Subject: Nested SQL QUERY I hope someone can help me with a syntax error I'm getting with a nested query. I'm a

MySQL-Max

2003-03-29 Thread Dave J. Hala Jr.
I'm running a recently up2dated RH 7.2 machine. I just downloaded all the My SQL 4x. RPMS from the MYSQL site: MySQL-4.0.1-2.i386.rpm MySQL-embedded-4.0.12-0.i386.rpm MySQL-bench-4.0.12-0.i386.rpm MySQL-Max-4.0.12-0.i386.rpm MySQL-client-4.0.12-0.i386.rpm MySQL-shared-4.0.12-0.i386.rp

Re: Using LIKE to search for occurence of a column value in a string

2003-03-29 Thread Jeff Moore
On Saturday, March 29, 2003, at 07:41 AM, Trevor Smith wrote: 2. your syntax just seems wrong. This should be: SELECT * FROM MyTable WHERE NeedleColumn LIKE '%needle%'; to search for the string 'needle' anywhere in NeedleColumn, if that's what you were looking for. I'm jumping in mid-stream so

RE: Nested SQL QUERY

2003-03-29 Thread Wynne Crisman
Nested SQL statements are not supported except in insert statements in MySQL (4.1 may include this feature, if not seems scheduled to be included soon). You can accomplish this query using an inner join. SELECT m.* FROM tblmarkets m INNER JOIN tblmarketproducts mp ON mp.MarketID = m.MarketID INN

Nested SQL QUERY

2003-03-29 Thread Eric Leupold
I hope someone can help me with a syntax error I'm getting with a nested query. I'm a newbie. Here is the statement: SELECT * FROM tblmarkets WHERE MarketID IN (SELECT MarketID FROM tblmarketproducts, tblproducts WHERE tblmarketproducts.ProductID = tblproducts.ProductID AND Produc

Re: Databases go away... But why?

2003-03-29 Thread Jeremy Zawodny
On Sat, Mar 29, 2003 at 07:53:32AM -0500, Bill Leonard wrote: > On 3/29/03 12:53 AM, "Jeremy Zawodny" <[EMAIL PROTECTED]> wrote: > > >> Every so often, once every couple days or so, the databases just disappear. > >> Doing a show databases command yields an empty set. Actually sometimes, it > >> s

Re: MySQL: Selecting a patricular row

2003-03-29 Thread R. Hannes Niedner
On 3/29/03 7:55 AM, "Marc Bakker" <[EMAIL PROTECTED]> wrote: > Hello, > I am working on a PHP/MySQL/Apache website. I have a MySQL table with 5 > rows. I want to select a patricular row using it's absolute row number. How > can I do this? I found mysql_row_seek() n te MySQL docs but this requires

MySQL: Selecting a patricular row

2003-03-29 Thread Marc Bakker
Hello, I am working on a PHP/MySQL/Apache website. I have a MySQL table with 5 rows. I want to select a patricular row using it's absolute row number. How can I do this? I found mysql_row_seek() n te MySQL docs but this requires me to get the whole table and then lets me within the result set sele

re: Fulltext search -- no wildcards in phrases?

2003-03-29 Thread Victoria Reznichenko
On Thursday 27 March 2003 20:59, Nick Arnett wrote: > It appears to me that fulltext phrase searches cannot include wildcards. > For example, I would expect "app* serv*" to match "application server," > "application services," etc. But it returns no results, so I'm having to > run each variation

re: table is read only

2003-03-29 Thread Victoria Reznichenko
On Saturday 29 March 2003 10:32, Joseph Bannon wrote: > I'm trying to update a table and I get this error > message. > > ERROR 1036: Table 'list' is read only Is your table compressed with myisampack? Check also permissions on the table files. -- For technical support contracts, goto https://o

re: Union Problems? Me too!

2003-03-29 Thread Egor Egorov
On Friday 28 March 2003 19:29, James wrote: > It seems that the union has problems when some values returned in the > selects are nulls like in left joines. Instead of seeing Nulls the rows > inherit the value of the previous row. Which make a real mess. I did how > ever found a work around. I use

UPDATE ... FROM query

2003-03-29 Thread Jakob Vedel Adeltoft
I have these tables: CREATE TABLE stack ( ProjectID INTEGER NOT NULL StatusID INTEGER NOT NULL ItemNumber INTEGER NOT NULL Stamp DATETIME NOT NULL ); CREATE TABLE queue ( ProjectID INTEGER NOT NULL StatusID INTEGER NOT NULL ItemNumber INTEGER NOT NULL Stamp DATETIME Wait BIT NOT NULL ); And thes

Re: Databases go away... But why?

2003-03-29 Thread Bill Leonard
On 3/29/03 12:53 AM, "Jeremy Zawodny" <[EMAIL PROTECTED]> wrote: >> Every so often, once every couple days or so, the databases just disappear. >> Doing a show databases command yields an empty set. Actually sometimes, it >> shows 1 or 2 in there. >> >> Any ideas as to what could be causing this,

Re: Using LIKE to search for occurence of a column value in a string

2003-03-29 Thread Trevor Smith
On Sat, 29 Mar 2003 05:43:53 -0500, Jeff Moore wrote: >However, this query does not work correctly If you generalize is to >include a database column: > >SELECT * FROM MyTable WHERE 'haystack needle haystack' LIKE CONCAT('%', >NeedleColumn, '%') Two things: 1. you don't seem to need the CONCAT

Re: Memory Leak

2003-03-29 Thread Jeff Kilbride
- Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Jeff Kilbride" <[EMAIL PROTECTED]> Cc: "Lopez David E-r9374c" <[EMAIL PROTECTED]>; "'DeepBlue'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 10:05 PM Subject: Re: Memory Leak > On Fri, Mar 28, 2

Re: Using LIKE to search for occurence of a column value in a string

2003-03-29 Thread Jeff Moore
I am having the same problem. This Query: SELECT 'haystack needle haystack' LIKE concat('%', 'needle', '%') returns 1 However, this query does not work correctly If you generalize is to include a database column: SELECT * FROM MyTable WHERE 'haystack needle haystack' LIKE CONCAT('%', NeedleC

table is read only

2003-03-29 Thread Joseph Bannon
I'm trying to update a table and I get this error message. ERROR 1036: Table 'list' is read only J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List