- 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,
>
> 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 achi
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
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.
K
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
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 'm
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.
>
- 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=(s
- 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=(s
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
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
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 unsubscri
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 duplic
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 Dr
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)
Quot
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
#include
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
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. Pleas
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 ca
--- 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)"
--- 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 corre
- 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
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:
if ($s_State){
$sql .= " AND VendorJobs.LocationState IN ($s_State)";
}
What I think I need is some kind of default "WHERE" in
th
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 Gener
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 Maili
I'm posting to test a new newsgroup client. Please post several replies.
Thanx,
Robb
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:
http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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 unsubsc
29 matches
Mail list logo