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
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
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
I'm posting to test a new newsgroup client. Please post several replies.
Thanx,
Robb
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
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
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
- 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
--- 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,
--- 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)
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
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
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
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
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)
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
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
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
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
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..
- 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 *
- 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 *
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.
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
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
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.
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
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:
- 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
29 matches
Mail list logo