Dear users
Can someone clarify is MySQL Spatial Extension support spatil join methods ?
Cheers
Saurabh Data
___
Saurabh Data
School of Computing
University of Leeds
Leeds LS2 9JT
U.K.
one who seeketh , will findeth and all door sh
Well it's hours later and I still have not found a solution to this. After
reading various posts on the net and the documentation I have tried several
things.
I've tried passing in useUnicode=true and characterEncoding=UTF8 and this
has done nothing. Then I read that by default the driver has the
Dear users
Can someone clarify if MySQL supports spatial join methods ?
cheers
Saurabh Data
___
Saurabh Data
School of Computing
University of Leeds
Leeds LS2 9JT
U.K.
one who seeketh , will findeth and all door shall open - jam
Howdy all,
Quick question about what I'm seeing in the BUFFER
POOL AND MEMORY section...
I've configured the innodb_buffer_pool_size to be 128M
and when I do a show variables like 'innodb%' I see
| innodb_buffer_pool_size | 134217728 |
So that looks good. However, I see the follow
At 19:07 -0700 4/20/04, <[EMAIL PROTECTED]> wrote:
I am attempting to write a C program to access MySQL. When I run
this program, it reports that mysql_init() returned NULL,
mysql_errno returned zero, and mysql_error returned "".
Here is the program:
#include
#include
int main( void )
{
At 18:47 -0700 4/20/04, Jon Nop wrote:
If memory serves me right, a number can not be greater than itself,
yet MySQL seems to disagree.
mysql> select score,score>7.64 from rateit_files where id=2382;
+---++
| score | score>7.64 |
+---++
| 7.64 | 1 |
+
I am attempting to write a C program to access MySQL. When I run this program, it
reports that mysql_init() returned NULL, mysql_errno returned zero, and mysql_error
returned "".
Here is the program:
#include
#include
int main( void )
{
MYSQL *db;
db = mysql_init( NULL );
Hi everyone,
Some quick background before I get to my question:
I have developed a fantasy football game that is based on an auction style
format. In any given game there are a consistant number of players, usually
10 or 12. There can be more than one game taking place at the same time on
the
If memory serves me right, a number can not be greater than itself, yet
MySQL seems to disagree.
mysql> select score,score>7.64 from rateit_files where id=2382;
+---++
| score | score>7.64 |
+---++
| 7.64 | 1 |
+---++
1 row in set (0.00 se
hi
my site is hosted on a machine on which i am not root.
so i don't have access to the mysql db. i'm quite sure
that the admin on that server doesn't know how to do
the security right. he gave my id almost root access
on his mysql server so that i could access it. two
three others have almost the
Thanks. I'd read that already but I re-read it and noticed this part here:
"When a client connects, it sends to the server the name of the character
set that it wants to use. The server sets the character_set_client,
character_set_results, and character_set_connection variables to that
character s
At 16:03 -0500 4/20/04, Dirk Bremer (NISC) wrote:
I have a couple of questions concerning the MySql client program.
1. Are the option for the client program, i.e. --auto-rehash, etc.
documented anywhere? I searched the included HTML file and could not find a
reference to the client options. What d
At 19:49 -0400 4/20/04, Stormblade wrote:
After reading a bit it seems my problem stems from the fact that although
my database and tables are all utf8 the "connection" charset seems not to
be. I have data that is unicode. I can view it in the database and they're
there. When I retrieve the data al
After reading a bit it seems my problem stems from the fact that although
my database and tables are all utf8 the "connection" charset seems not to
be. I have data that is unicode. I can view it in the database and they're
there. When I retrieve the data all the unicode chars are converted to
quest
hi,
I am trying to enter a genome sequence into mysql database. I have created
a database in mysql as:
create table sequence(seq blob);
the length of my sequence is approx. 170.
this is the error i get whe i run my python script:
OperationalError: (2006, 'MySQL server has gone away')
i
I just tried to load edited data from a text file separated by |
characters into a table in a simple data base
I was using PhpMyAdmin version 2.5.6 and MySQL 4.0.18 running on Windows
XP - I thought it was all set up right and configured properly
- and earlier was able to populate the table with
Don't quote me on this but I don't think it makes a difference what
datatypes you use with multiple languages (I never even considered it with
English, Japanese and Korean) as long as the field is large enough to handle
the multiple bytes. You might wish to check out the Unicode support pages o
Hi,
I also do a similar thing with my data pre-processing
scripts. I use a multiple insert command with INSERT
DELAYED. It has improved the performance by heaps. The
format is
INSERT DELAYED INTO table VALUES (c11, c12, c13),
(c21, c22, c23);
The INSERT DELAYED will delay the updates so that
Remi Mikalsen wrote:
Car
-
| ID | IDBrand | IDModel | Year | Price |
-
Characteristic
| ID | Description |
CarCharacteristics
| IDCar | IDCharac |
-
Leandro Melo wrote:
Hi,
i have a M:N relationship between PRODUCT and PRICE.
Is Price an Entity or an Attribute? I'm not accustomed to using price as
a Thing. What is it that causes a Product to have one, exactly, or more
prices? Is it its relationship to some other thing? Or is it a special
Hello.
I've got a tricky problem on my hands. It seems very easy, but I can't figure it out
anyway,
and I've already spent quite some time trying to solve it! I'm doing the whole thing
under
MySQL 4.0, which seems to be the real problem here! It doesn't support my query I
wrote! Well, I didn'
hi,
I am trying to enter genome sequences of length 170 and more into
mysql database.
I have created a table sequence like:
create table sequence(seq blob);
i am using python scripts to put the sequence into this field.
the python GUI gives me this error:
OperationalError: (2006, 'My
>The lack of error checking on the server side means better performance in
>my opinion. When you're throwing a couple thousand hits per second at it,
>this is visible.
If error checking is largely dispensed with, client and server will be both
be faster, except during crashes, which may be frequen
hi
I am trying to enter a genome sequence of length 170 in a table.
I have created the table as
create table sequence(Seq blob);
I am using Python script to enter this sequence into the table.
I am getting an error
OperationalError: (2006, 'MySQL server has gone away')
I am not able t
Hi,
i have a M:N relationship between PRODUCT and PRICE.
1 product may be associated to N prices and 1 prices
may belong to N products.
I got special cases the some kinda product MUST have
only 1 price associated with it.
I don't what would be the best way to model this
"flag" for the special case.
On 20.04.2004 17:53 (+0100), Lehman, Jason (Registrar's Office) wrote:
Does anyone know what is going on with the MySQL website?
No, it's accessible as usual. But with Firefox, only at the second try.
Could also be a browser problem, I'm using an older nightly build.
--
Yves Goergen <[EMAIL PROT
I got mine (even autographed) at the MySQL Users Conference. Excellent
reading -- definitely required for anyone whose livelihood depends on MySQL.
(this was a non-paid endorsement)
Robert Taylor
[EMAIL PROTECTED]
Jeremy Zawodny wrote:
MySQL users,
I just wanted to send a quick note to let any
> Create composite index on (cat, date). Use EXPLAIN to see if MySQL uses
index:
> http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
This partially solved my problem. Thanks a lot. However I am facing a new
problem here.
The query where I am ordering by a column is much more slowly than the same
que
MySQL users,
I just wanted to send a quick note to let anyone interested know that
"High Performance MySQL" (the book I started a long time ago) is now
available and shipping.
O'Reilly brought copies to the MySQL Conference last week and several
folks have reported Amazon.com shipping, so it's ti
I have a couple of questions concerning the MySql client program.
1. Are the option for the client program, i.e. --auto-rehash, etc.
documented anywhere? I searched the included HTML file and could not find a
reference to the client options. What does the --auto-rehash option do?
Heck, what do all
> The timestamp is when the query was written to the log. You will have to
> subtract the query time to get when the query began. Unless you have
queries
> that are running for long durations the timestamp and actual time should
be
> close.
OK, so, slow query shouldn´t be my problem, because there
The timestamp is when the query was written to the log. You will have to
subtract the query time to get when the query began. Unless you have queries
that are running for long durations the timestamp and actual time should be
close. Are you performing reads or writes to this disk? Have you captured
On Tue, Apr 20, 2004 at 01:54:37PM -0400, McConnell, Ann M. wrote:
> Does anyone have any experience with Innodb Hot Backup Tool?
Yes.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 219 days, proc
On Tue, Apr 20, 2004 at 01:13:14PM -0700, Eric wrote:
> Hi,
>
> The mysql administrator tool is a lot better for this. They still
> seem to be working out some bugs, but there is a lot of flexibility
> with the graphs. I have been able to see peaks in bandwidth and
> queries that I never noticed
On Tue, 20 Apr 2004 15:33:18 -0400, Peter J Milanese wrote:
> Just something I noticed missing here
>
>
> The lack of error checking on the server side means better
> performance in my opinion.
No doubt.
> When you're throwing
> a couple thousand hits per second at it, this is visible. I woul
Victor,
> Do you have any around the approximate time?
I know the time that the problem occurred.
In the slow-log, it shows the line "Time".
Is it line the hour the query ran?
> The timestamp will be will the
> query was written to the slow log and how long it took. What are the
> symptoms that
Do you have any around the approximate time? The timestamp will be will the
query was written to the slow log and how long it took. What are the
symptoms that lead you to believe that it is a slow running query?
-Original Message-
From: Ronan Lucio
To: Victor Pendleton; [EMAIL PROTECTED]
S
Hi there,
I'm currently writing a Data Mining program in Perl, my problem is that the
writing to the database takes awful long.
Are there any ideas how to speed up the inserting and the updating, besides
using the bind operator?!
the SQLstatement looks like
"INSERT INTO `Counts` (`id`, `d
Victor,
> Are you logging slow queries? If so, have you looked in the slow query
log?
Yes, I am.
But, it shows many of them and no one at this time.
Or, it doesn´t show slow queries when the problem is occurring.
I restarted the server 1 hour ago and after I did it, the server seems
to be OK.
I
We're using an evaluation version right now - works great, though I've yet
to test a backup (and I need to do that soon).
David.
- Original Message -
From: "McConnell, Ann M." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 20, 2004 10:54 AM
Subject: Innodb Hot Backup Tool
> -Original Message-
> From: Michael McTernan [mailto:[EMAIL PROTECTED]
> > if you don't have error checking in yourself, that's your problem
> > not mysql's problem.
>
> True, but still doesn't help when someone inexperienced with
> MySQL makes a
> mistake and buggers the database...
Hi,
The mysql administrator tool is a lot better for this. They still seem to be working
out some bugs,
but there is a lot of flexibility with the graphs. I have been able to see peaks in
bandwidth and queries that I never noticed before..
Thanks,
Eric
At 12:35 PM 4/20/2004, Peter J Mila
Guess you could use the rand() function and look for a matching row id!?!
> Is it possible to randomly select from all entries in a table, but have it
> be 2 different ones each time? If so, what documentation should I be
> looking
> at?
>
> I am using PHP and MySQL together, if this helps.
>
> Th
At 12:24 -0700 4/20/04, Matthias Eireiner wrote:
Hi there,
I'm currently writing a Data Mining program in Perl, my problem is that the
writing to the database takes awful long.
Are there any ideas how to speed up the inserting and the updating, besides
using the bind operator?!
the SQLstatement lo
Craig Gardner wrote:
Thank you very much. That's what fixed my problem.
Robert J Taylor wrote:
Can you restrict to Not Null instead of != ""? (I.e, can you scrub
the data not to have empty strings?).
The explain shows 3 extra where calculations per row...that's painful.
Great! Glad that sol
Are you logging slow queries? If so, have you looked in the slow query log?
-Original Message-
From: Ronan Lucio
To: [EMAIL PROTECTED]
Sent: 4/20/04 1:58 PM
Subject: Process Monitoring
Hi,
We have a MySQL-Server-4.0.17 installed in our enterprise
working fine... :-)
Some times our appl
try getting 'mytop'.
Do a google on it... It's like the 'top' utility, but displays information
regarding mysql procs.
P
"Ronan Lucio" <[EMAIL PROTECTED]>
04/20/2004 06:58 PM
To: <[EMAIL PROTECTED]>
cc:
Subject:Process Monitoring
Hi,
We have a MySQL
Is it possible to randomly select from all entries in a table, but have it
be 2 different ones each time? If so, what documentation should I be looking
at?
I am using PHP and MySQL together, if this helps.
Thanks,
Eve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
Just something I noticed missing here
The lack of error checking on the server side means better performance in
my opinion. When you're throwing
a couple thousand hits per second at it, this is visible. I would have to
agree that error checking does belong
on the client side (at least from
Hi there,
I'm currently writing a Data Mining program in Perl, my problem is that the
writing to the database takes awful long.
Are there any ideas how to speed up the inserting and the updating, besides
using the bind operator?!
the SQLstatement looks like
"INSERT INTO `Counts` (`id`, `d
Hi -
Is there any info out there on how to put together a capacity plan for
MySQL? My tables are filling up pretty quick - 20% more volume a month and
would like to be able to project a year by year analysis of memory,
resources needed.
Thanks,
Ann
Hi,
We have a MySQL-Server-4.0.17 installed in our enterprise
working fine... :-)
Some times our application takes too bandwidth from the
database server.
So, I´m trying to figure out what (perhaps what select) is taking
so manu bandwidth.
SHOW FULL PROCESSLIST shows me the follow:
mysql> show
--- Original Message ---
From: "Stormblade" <[EMAIL PROTECTED]>
To: Donny Simonton <[EMAIL PROTECTED]>
Cc:
Sent: Tue, 20 Apr 2004 12:59:58 -0400
Subject: RE: Gripe with MySQL
> On Tue, 20 Apr 2004 11:37:12 -0500, Donny Simonton wrote:
> Everybody should remember as well, if you run rm -rf /*.* on
On Tue, 20 Apr 2004 11:49:46 -0500, Paul DuBois wrote:
>>> Make sure the server really is picking up the option value:
>>>
>>>
>>> SHOW VARIABLES LIKE 'character%';
>>>
>>>
>>> Look for 'character_set_server'.
>>>
>>>
>>> If it's utf8, then perhaps your GUI tools are overriding the
>>> setting? Dun
On Tue, 20 Apr 2004 12:13:07 -0500, Paul DuBois wrote:
> At 13:03 -0400 4/20/04, Stormblade wrote:
>> On Tue, 20 Apr 2004 11:49:46 -0500, Paul DuBois wrote:
> Make sure the server really is picking up the option value:
>
>
> SHOW VARIABLES LIKE 'character%';
>
>
> Look f
Embarrassing but I blame it on hunger!
It's working now. Bottom line was I hadn't restarted the server. Now I know I
said I did. Here's where I blame hunger. I was restarted A server. My Tomcat
server. I kept restarting it thinking I was restarting the MySQL serverdon't
ask. Like I said I blam
On Tue, 20 Apr 2004 17:57:08 +0100, Michael McTernan wrote:
> Donny,
>
>
> I think you misunderstand the point of my comment, and possibly
> Stormblade's too.
>
> The point is that there are some things that are misleading, and it
> would be kinder for MySQL to report errors than silently performin
Does anyone have any experience with Innodb Hot Backup Tool?
Thanks,
Ann
At 12:33 -0400 4/20/04, Lou Olsten wrote:
I've found two methods that both seem to work fine (on 4.0.18) for
setting dynamic variables:
mysql> set @@session.autocommit=0;
mysql> set session autocommit=0;
Which is the preferred (latest) method? Is one eventually going to
be deprecated?
1) They'r
I have two queries that are very similar. One of the queries takes a few
minutes (3:43:07 last run) to complete, while the other takes less than
a second to complete.
I know these are two different queries and shouldn't take the same
amount of time, but I based the fast query on the slower one.
At 18:16 +0200 4/20/04, erri wrote:
I find this:
/mysql-standard-4.0.18-ibm-aix5.2.0.0-powerpc/lib/libmysqlclient.a
/mysql-standard-4.0.18-ibm-aix5.2.0.0-powerpc/lib/libmysqlclient_r.a
Is this mysqlclient ?
Yes, but it doesn't look like it's under /usr/local/mysql to me. :-)
At 9:51 +0200 4/20/
Rhino...
I'm with Joshua on this one. Any university that is still doing everything
with hardcopy and that has few if any computer systems to store things at
this point in time is scary. Fortunately, they appear to be getting at least
a glimmer of the idea that they could do much better with a com
At 13:03 -0400 4/20/04, Stormblade wrote:
On Tue, 20 Apr 2004 11:49:46 -0500, Paul DuBois wrote:
Make sure the server really is picking up the option value:
SHOW VARIABLES LIKE 'character%';
Look for 'character_set_server'.
If it's utf8, then perhaps your GUI tools are overriding the
settin
Peter,
I really appreciate your offer to help out! Since I'm fairly fresh in
the area, I appreciate any help I can get. Can you recomend any formal
online training resources for MySQL/PHP?
Thanks,
Mike Caskey
Peter Lovatt wrote:
Hi
I would echo this. We are finding that applications based o
Eric,
Right, I think the OO.o thing just isn't going to work for me, unless I
can get the IT department to like it, but they're already deeply
invested in MSO. The MS Access interface idea would be a quick
solution, but I wonder if there would be version conflicts in the
future, since the MSO
Thanks for the info Daniel,
Could you maybe link me to some of the projects you've seen for
uploading images too?
-Mike Caskey
Daniel Kasak wrote:
Mike T. Caskey wrote:
Hi all!
I'm wondering if anyone can help me find out how much time/training
is needed to accomplish my task using MySQL.
J,
Thanks for your response. I should say, it's not the entire university
which has fallen so far behind, just my department. Also, the records
we need to manage with this system will be only within this
department... at first. Could you possibly link me to some of those
projects on SF and
Donny,
I think you misunderstand the point of my comment, and possibly Stormblade's
too.
The point is that there are some things that are misleading, and it would be
kinder for MySQL to report errors than silently performing something
unexpected and continuing without warning - at least if you ru
At 02:48 pm 20/04/04, Victor Pendleton wrote:
What does the explain look like for this query?
Like this:
mysql> explain (SELECT DISTINCT g.id
-> FROM Broadcast b, Genre g
-> WHERE g.id IN (0)
->
-> ) UNION (
-> SELECT DISTINCT b.id
-> FROM Broadcast b,
On Tue, 20 Apr 2004 09:25:58 -0500, Peter Brawley wrote:
>>If you are going to have a database that will be centralized for the
> company
>>and will have many different clients accessing it, I would tell them not to
> use
>>MySQL.
>
> OK, though 5.0 makes it possible to write stored procs that pr
4.1.2 will probably not be beta or gamma. Not sure why. I've been using
4.1.1 in a production environment since it was released. I love it! We
still use 4.0.x or 3.23.x on some of our older stuff, and everytime I have
to use it I get aggravated. Once you use it and you find all of the
differen
Everybody should remember as well, if you run rm -rf /*.* on your server you
will delete everything from your server, but linux will stay running. Even
though that's not documented either.
If you use a client like PHPMyadmin or one of the other 80 million that are
around you won't have to worry a
I've found two methods that both seem to work fine (on 4.0.18) for setting dynamic
variables:
mysql> set @@session.autocommit=0;
mysql> set session autocommit=0;
Which is the preferred (latest) method? Is one eventually going to be deprecated?
Thanks,
Lou
I find this:
/mysql-standard-4.0.18-ibm-aix5.2.0.0-powerpc/lib/libmysqlclient.a
/mysql-standard-4.0.18-ibm-aix5.2.0.0-powerpc/lib/libmysqlclient_r.a
Is this mysqlclient ?
> At 9:51 +0200 4/20/04, erricharl wrote:
> >Hello.
> >I have installed binary version for aix 5.2 from www.mysql.net and
> >w
On Tue, Apr 20, 2004 at 08:28:54AM -0500, Boyd E. Hemphill wrote:
> Max:
>
> Thanks for the tip.
>
> Unfortunately I am not using a FreeBSD environment. My options are to
> either run a WinXP client remotely or to run something Linux based in a
> terminal emulator (Putty).
But that URL says "I
Max,
You can measure the elapsed time by writing a linux shell script to do the
inserts, then use the linux "time" command to run it. However, the user and
system times displayed will not include the amount of cpu time used by the
db server.
Do it a few times and vary the number of inserts to bui
> 1. MySQL only uses one index for each table in a JOIN; this query only
uses
> one table, so only one index is used.
> 2. DESC is slower than ASC
> 3. Try creating an index on two columns; try cat and date, and try date
and
> cat.
> 4. Check EXPLAIN SELECT id,name.. to see whether the right in
Hi everyone,
Some quick background before I get to my question:
I have developed a fantasy football game that is based on an auction style
format. In any given game there are a consistant number of players, usually
10 or 12. There can be more than one game taking place at the same time on
the
> select id,name,desc,cat,date from table where cat='12'
>
> however I need to order the results by date desc... I have indexes on both
> the cat and date (of type timestamp) fields however this operation is much
> more slowly when I used the order So the result is something like this
>
> selec
Does anyone know what is going on with the MySQL website?
Jason Lehman
Webmaster, Registrar's Office
(813)974-4157 Phone
574-4157 Suncom
(813)974-5271 FAX
[EMAIL PROTECTED] Email
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
Hi all,
I use a SET Value to keep track of my Replication Process on the
Main-Daemon.
So for every Daemon, how collects Data from a Branch, a have a Flags
as a SET ('daemon_on', 'slave_working', ...)
Now I wont to toggle only one Bit and lave the rest at it is.
Example:
Now I would like to toggl
Are you exporting/importing the DDL as well? Is the column type the same for
both tables?
What is that column type? TIMESTAMP(14)?
-Original Message-
From: Fajar Priyanto
To: Victor Pendleton; '[EMAIL PROTECTED] '
Sent: 4/20/04 9:16 AM
Subject: Re: error importing date
-BEGIN PGP SIGN
I am not certain but it appears that you date values are shifting to the
right. Can you create a test case using timestamp(14) and see if the error
occurs?
-Original Message-
From: Fajar Priyanto
To: Victor Pendleton; ''[EMAIL PROTECTED] ' '
Sent: 4/20/04 10:19 AM
Subject: Re: error import
>If you are going to have a database that will be centralized for the
company
>and will have many different clients accessing it, I would tell them not to
use
>MySQL.
OK, though 5.0 makes it possible to write stored procs that protect clients
from MySQL's gotchas, and that keep database-protecting
At 11:02 -0400 4/20/04, Stormblade wrote:
On Tue, 20 Apr 2004 09:21:00 -0500, Paul DuBois wrote:
At 9:38 -0400 4/20/04, Stormblade wrote:
On Tue, 20 Apr 2004 11:32:22 +0300, Victoria Reznichenko wrote:
Stormblade <[EMAIL PROTECTED]> wrote:
Hopefully this will be the last snag...least till the
Fajar Priyanto <[EMAIL PROTECTED]> wrote:
>
> Hi all,
> I encounter this error when importing database from one mysql server into=20
> another: the date imported is wrong. The type is timestamp.
>
> In the dump file, the date is : 0404121921, but when imported, it becomes:=
> 0004041219.
>
> Cou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Yes, I use the mysqldump command without any arguments.
But, by the way, the timestamp is timestamp(10), is it correct?
On Tuesday 20 April 2004 09:38 pm, Victor Pendleton wrote:
> Are you exporting/importing the DDL as well? Is the column type the sa
At 9:51 +0200 4/20/04, erricharl wrote:
Hello.
I have installed binary version for aix 5.2 from www.mysql.net and
when i try to compile cyrus-sasl with mysql support it don't find
mysqlclient libraries.
I use --with-mysql=/usr/local/mysql/ to build but i get:
checking for mysql_select_db in -lm
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Victor, thanks for responding. I really need help here.
I export/import the database using mysqldump (for exporting), and the mysql
command (for importing). One thing to be noted thought, the exported sql has
correct timestamps (they're exactly t
This will do it...
SELECT id, group_concat(distinct buddy_id)
FROM buddies
GROUP BY id
Ed
-Original Message-
Hi,
When using aggregate functions, I know you can retrieve the MAX, MIN,
SUM, etc from all the values in your specific group from the GROUP BY.
Is there any function to simply
I'm using amavisd-new -20030616p9, RH 3.0 ES and mysql 3.23.58-1 trying
to do sql lookups for user prefs. I've done this before and have
compared my sql statements and can't figure out the problem.
When i start amavisd-new with the debug switch, here's what i get:
# /usr/local/sbin/amavisd debu
"Arthur Radulescu" <[EMAIL PROTECTED]> wrote:
>
> I have a simple query on a table of about 1,000,000 records... The table is
> optimized and the query is pretty simple at this moment... something like
> this
>
> select id,name,desc,cat,date from table where cat='12'
>
> however I need to order
At 9:38 -0400 4/20/04, Stormblade wrote:
On Tue, 20 Apr 2004 11:32:22 +0300, Victoria Reznichenko wrote:
Stormblade <[EMAIL PROTECTED]> wrote:
Hopefully this will be the last snag...least till the next one :)
I'm having a problem setting the charset to unicode (utf-8). If I
understood what I
Hello!
I have a simple query on a table of about 1,000,000 records... The table is
optimized and the query is pretty simple at this moment... something like
this
select id,name,desc,cat,date from table where cat='12'
however I need to order the results by date desc... I have indexes on both
the
At 14:44 +0100 4/20/04, Andy Hall wrote:
Hi,
When using aggregate functions, I know you can retrieve the MAX,
MIN, SUM, etc from all the values in your specific group from the
GROUP BY.
Is there any function to simply return a list of the values in the group?
GROUP_CONCAT()?
Supported in MySQL
How are you exporting/importing the data?
-Original Message-
From: Fajar Priyanto
To: [EMAIL PROTECTED]
Sent: 4/20/04 3:51 AM
Subject: error importing date
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I encounter this error when importing database from one mysql server
into
an
Hi everyone,
Some quick background before I get to my question:
I have developed a fantasy football game that is based on an auction style
format. In any given game there are a consistant number of players, usually
10 or 12. There can be more than one game taking place at the same time on
the s
What does the explain look like for this query?
-Original Message-
From: James Fryer
To: [EMAIL PROTECTED]
Sent: 4/20/04 8:08 AM
Subject: Query that crashes MySQL
I'm using mysql-standard-4.1.0-alpha and I've found a query that
consistently crashes the server.
The form of the query is t
James Fryer <[EMAIL PROTECTED]> wrote:
> I'm using mysql-standard-4.1.0-alpha and I've found a query that
> consistently crashes the server.
>
> The form of the query is this:
>
>>(SELECT DISTINCT g.id
>> FROM T1 b, T2 g
>> WHERE g.id IN (0)
>>
>>) UNION (
>> SELECT DISTINCT b.id
>>
Never mind, I found the GROUP_CONCAT function but I am still using v. 3.23.37 so thats
that.
Looks like I'll be using PHP, unless anyone has a workaround of some kind?
Thanks
1 - 100 of 119 matches
Mail list logo
