Upgrading mySQL

2004-11-14 Thread GH
I would like to know how to upgrade mySql from 4.0 to 4.1? I am running mandrake 10 I am using the preinstalled versions of both mySQL and PHP (php4). I am a newbie to Linux and am a bit nervous. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: How many rows?

2004-11-14 Thread Michael Satterwhite
On Saturday 13 November 2004 06:40 am, Jerry Swanson wrote: This is my query select id, status from sale where user_id = 1 GROUP BY id; I need to know how many rows or how many entries this query returns. I tried to use count and sum. But the result is wrong. I want to be able to make

Conditonal where

2004-11-14 Thread Stuart Felenstein
Question - I'm creating a dynamic query (using PHP) but my question I think is more related to mysql syntax. Right now I have these statements: ?php $sql .= SELECT PostStart, JobTitle, Industry, LocationState, VendorID FROM VendorJobs; if ($s_Ind){ $sql .= WHERE VendorJobs.Industry IN

Test post to test new client

2004-11-14 Thread Robb Kerr
I'm posting to test a new newsgroup client. Please post several replies. Thanx, Robb

RE: Test post to test new client

2004-11-14 Thread John Berman
Hope it works John B -Original Message- From: Robb Kerr [mailto:[EMAIL PROTECTED] Sent: 14 November 2004 17:35 To: [EMAIL PROTECTED] Subject: Test post to test new client I'm posting to test a new newsgroup client. Please post several replies. Thanx, Robb -- MySQL General

RE: Test post to test new client

2004-11-14 Thread John Berman
Really hope it works John B -Original Message- From: Robb Kerr [mailto:[EMAIL PROTECTED] Sent: 14 November 2004 17:35 To: [EMAIL PROTECTED] Subject: Test post to test new client I'm posting to test a new newsgroup client. Please post several replies. Thanx, Robb -- MySQL

Re: Conditonal where

2004-11-14 Thread Chris
Stuart Felenstein wrote: Question - I'm creating a dynamic query (using PHP) but my question I think is more related to mysql syntax. Right now I have these statements: ?php $sql .= SELECT PostStart, JobTitle, Industry, LocationState, VendorID FROM VendorJobs; if ($s_Ind){ $sql .= WHERE

Re: Conditonal where

2004-11-14 Thread Rhino
- Original Message - From: Stuart Felenstein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 14, 2004 12:30 PM Subject: Conditonal where Question - I'm creating a dynamic query (using PHP) but my question I think is more related to mysql syntax. Right now I have

Re: Conditonal where

2004-11-14 Thread Stuart Felenstein
--- Rhino [EMAIL PROTECTED] wrote: No offense, Stuart, but I really can't make out what you are asking; the question is bordering on incoherent. Well it's probably true that I'm losing it :) Chris though understood even through my inane babbling. Except while the statements are correct,

Re: Conditonal where

2004-11-14 Thread Stuart Felenstein
--- Chris [EMAIL PROTECTED] wrote: What I tend to do in this situation is have a WHERE array: $sql .= SELECT PostStart, JobTitle, Industry, LocationState, VendorID FROM VendorJobs; $aWHERE = array(); if(isset($s_Ind)) $aWHERE[] = VendorJobs.LocationState IN ($s_Ind)

Re: How many rows?

2004-11-14 Thread Michael Stassen
Your sample query doesn't really make sense, but perhaps you are looking for SQL_CALC_FOUND_ROWS. From the manual, SQL_CALC_FOUND_ROWS (available in MySQL 4.0.0 and up) tells MySQL to calculate how many rows there would be in the result set, disregarding any LIMIT clause. The number of rows

Re: Test post to test new client

2004-11-14 Thread Kenneth Wagner
Here's is your test reply. Wishing you complete success... Ken Sugar Creek - Original Message - From: Robb Kerr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 14, 2004 11:34 AM Subject: Test post to test new client I'm posting to test a new newsgroup client. Please

Re: 4.1.7: bug in FT search? (cont.)

2004-11-14 Thread Przemyslaw Popielarski
Przemyslaw Popielarski [EMAIL PROTECTED] wrote: SELECT TYTUL FROM tKsidata WHERE MATCH (TYTUL) AGAINST (space) ORDER BY TYTUL TYTUL Shaping Space 2ed National Air Space Museum Light Space Free Space Architecture Does Economics Space Matter ? [...] ...and compiling own binary from

Connecting to MySQL using C API

2004-11-14 Thread premal mishra
I'm using MySQL version 4.0.20a on win98. Compiler is Bloodshed Dev-C++ version 4. My program compiles and links but gives a page fault error on running. I'm linking the '\mysql\lib\opt\mysqlclient.lib' file. Linker gives the warning ignoring duplicate section '.text' CODE: #include

Re: Test post to test new client

2004-11-14 Thread Jeff Smelser
On Sunday 14 November 2004 11:34 am, Robb Kerr wrote: I'm posting to test a new newsgroup client. Please post several replies. Does it work with mysql? Just curious. Jeff -- === Jabber: tradergt@(smelser.org|jabber.org)

Re: Test post to test new client

2004-11-14 Thread Robb Kerr
Thanx for the posts. The software seems to work great. It's actually an addition to MS Outlook that allows it to be used as a news client so that you don't have to run MS Outlook Express just to check newsgroups. Thanx again, Robb Robb Kerr Digital IGUANA Helping Digital Artists Achieve their

Re: Connecting to MySQL using C API

2004-11-14 Thread Paul DuBois
At 21:20 + 11/14/04, premal mishra wrote: I'm using MySQL version 4.0.20a on win98. Compiler is Bloodshed Dev-C++ version 4. My program compiles and links but gives a page fault error on running. I'm linking the '\mysql\lib\opt\mysqlclient.lib' file. Linker gives the warning ignoring

syntax question..

2004-11-14 Thread kalin mintchev
hi everybody.. can somebody please explain what is wrong with this command: select t1.data from table1 as t1 where t1.zip=(select * from table2 as t2 where t2.chain like %carmike%); thank you... -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

RE: syntax question..

2004-11-14 Thread Peter Lovatt
Hi sub selects are only supported from MySql 4.1 onwards, so it may be invalid if you have an earlier version. you may also cause a conflict by using the database alias (t1) as the name of the result Peter -Original Message- From: kalin mintchev [mailto:[EMAIL PROTECTED] Sent: 14

Re: syntax question..

2004-11-14 Thread Jeff Smelser
On Sunday 14 November 2004 05:05 pm, kalin mintchev wrote: can somebody please explain what is wrong with this command: select t1.data from table1 as t1 where t1.zip=(select * from table2 as t2 where t2.chain like %carmike%); If your no usiing 4.1, subselects are not even allowed.. If so..

Re: syntax question..

2004-11-14 Thread Rhino
- Original Message - From: kalin mintchev [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 14, 2004 6:05 PM Subject: syntax question.. hi everybody.. can somebody please explain what is wrong with this command: select t1.data from table1 as t1 where t1.zip=(select *

Re: syntax question..

2004-11-14 Thread Rhino
- Original Message - From: kalin mintchev [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 14, 2004 6:05 PM Subject: syntax question.. hi everybody.. can somebody please explain what is wrong with this command: select t1.data from table1 as t1 where t1.zip=(select *

RE: syntax question..

2004-11-14 Thread kalin mintchev
thanks to all... yes, Rhino - i'm new. my first post. the version is the problem indeed. it's 4.0.13-standard. how would i achieve the same query in this version?... thank you.. Hi sub selects are only supported from MySql 4.1 onwards, so it may be invalid if you have an earlier version.

Solaris 8 error make on mysql_4.1.7

2004-11-14 Thread webmaster
Sorry form my english, I am Italian. I have a problem when run make, the error is following g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I../include -g -DSAFE_MUTEX -D_FILE_OFFSET_BITS=64 -DHAVE_CURSES_H -I/download/mysql_4.1.7/mysql-4.1.7/include -DHAVE_RWLOCK_T -c -o mysql.o `test -f

Re: syntax question..

2004-11-14 Thread Adam
Kalin, Kalin thanks to all... yes, Rhino - i'm new. my first Kalin post. the version is the problem indeed. it's Kalin 4.0.13-standard. how would i achieve the same Kalin query in this version?... You'll need to provide the following: (1) What is the result you want to achieve? (2) What are the

MySql Administrator

2004-11-14 Thread karigna
I just did a clean install of Fedora Core 3 and installed mysql administrator but when I go to execute the app nothing happens. No error message etc. Is there a problem with this combination? The version of mysql admin is the latest from the website and is not the stripped down version. Thanks.

Re: [PHP-DB] Upgrading mySQL

2004-11-14 Thread Ardilla Roja
this one will be usefull ... 2.10.2 Upgrading from Version 4.0 to 4.1 - http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html On Sun, 14 Nov 2004 09:30:49 -0500, GH [EMAIL PROTECTED] wrote: I would like to know how to upgrade mySql from 4.0 to 4.1? I am running mandrake 10 I am using

Re: syntax question..

2004-11-14 Thread kalin mintchev
Kalin, Kalin thanks to all... yes, Rhino - i'm new. my first Kalin post. the version is the problem indeed. it's Kalin 4.0.13-standard. how would i achieve the same Kalin query in this version?... You'll need to provide the following: (1) What is the result you want to achieve? well:

Re: syntax question..

2004-11-14 Thread Rhino
- Original Message - From: kalin mintchev [EMAIL PROTECTED] To: Adam [EMAIL PROTECTED] Cc: MySQL General [EMAIL PROTECTED] Sent: Sunday, November 14, 2004 11:33 PM Subject: Re: syntax question.. Kalin, Kalin thanks to all... yes, Rhino - i'm new. my first Kalin post. the