RE: nested ORDER BY statements

Drop the second ORDER BY clause in favor of a comma. ORDER BY table1.time_created DESC, table1.name LIMIT 50 Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Dave Terrio [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 7:38 AM To: [EMAIL PROTECTED] Subject: nested

Re: out f memory error

# [EMAIL PROTECTED] / 2003-06-04 16:37:08 +0300: > I have a program that runs a loop,in every loop I execute a query. > the query itself is very efficient, the result of the query is 4 rows at > most but... > after a while I get the following error: > Out of memory! > Bus error (core dumped) > >

Re: nested ORDER BY statements

Hi David, > Hello - I'm a relative newcomer to development with MySQL and am having a > problem with ordering my query results... This is a general SQL question. Try this: ... ORDER BY time_created DESC, name LIMIT ... In general, you can't declare a clause twice, except for the

Re: debuggine 1205 / LOCK wait timeout exceeded errors

Roman, looks like your application fails to commit this transaction: " 030604 13:52:21 INNODB MONITOR OUTPUT ... LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 407759, ACTIVE 2090 sec, OS thread id 10251 10 lock struct(s), heap size 1024, undo log entries 5 MySQL thread id 1, query id 91

Re: Specifics on using join & multiple tables

At 09:48 AM 6/4/2003, you wrote: Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2003-06-04 09:17:01 -0400: I need all data in sales1 and sales2, but only for records from acc that are in either/both sales1, sales2. SELECT acc.name, acc.phone, acc.acctno, sales1.amt AS mo1sales, sale

Re: Specifics on using join & multiple tables

Patrick Shoaf wrote: At 09:48 AM 6/4/2003, Bruce Feist wrote: I suspect that sales1 and sales2 should really be a single 'sales' table with an extra column indicating which month the sales are for (and maybe one for year as well), but I don't have enough information to be sure. Table sales1 & sa

Re: Specifics on using join & multiple tables

Hi Patrick! > I need: > > acc.name, acc.phone, acc.acctno, sales1.amt as mo1sales, sales2.amt as > mo2sales, (sales1.amt - sales2.amt) as diff SORT by diff > > I need all data in sales1 and sales2, but only for records from > acc that are in either/both sales1, sales2. > > I tried: > select f

RE: nested ORDER BY statements

Aah, in that case I am not sure you can do what you need to do with a single query... A UNION may allow it. (SELECT * FROM table1 WHERE 1=0) UNION (SELECT * FROM table1 ORDER BY table1.time_created DESC LIMIT 50) ORDER BY table1.name; Or something to that effect may work. You may even be able to

Re: debuggine 1205 / LOCK wait timeout exceeded errors

# [EMAIL PROTECTED] / 2003-06-04 17:11:19 +0300: > Roman, > > looks like your application fails to commit this transaction: > > " > 030604 13:52:21 INNODB MONITOR OUTPUT > ... > LIST OF TRANSACTIONS FOR EACH SESSION: > ---TRANSACTION 0 407759, ACTIVE 2090 sec, OS thread id 10251 > 10 lock struct(

RE: nested ORDER BY statements

I had a little time to test, and this should work fine without the UNION (SELECT * FROM table1 ORDER BY table1.time_created DESC LIMIT 50) ORDER BY table1.name; Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Mike Hillyer Sent: Wednesday, June 04, 2003 8:41 AM To: Dave T

Terrifyingly different results on different 4.0.X versions

Last night I was looking over one of my applications on my development box, and realized that the results I was getting were rather different from what I had expected. It was still working fine on my working server. I copied over the current version of the tables to the dev box, and made sure tha

Threads in Redhat 8 not working...

Forgive me for posting again, but this is a server that WAS going to be production soon, but the thread problem is making me worry a bit. To reiterate on my Redhat 8 installation with the RPMs from www.mysql.com, when you start mysql from init.d using the startup script that calls mysqld_sa

Re: nested ORDER BY statements

Hi, I am a bit new to mysql but have extensive experience with Oracle. Does MYSQL allow a select like: select data1,data2,name1 from (select data1,data2,name1,rownum from table order by time) table1 where rownum < 51 order by name1 Cheers, Ton - Original Message - From: "Mike Hillyer"

RE: nested ORDER BY statements

SubSelects are allowed in MySQL 4.1, but not in any earlier versions. If I recall what rownum is (a number generated to represent the rownum of the returned data set), it has no equivalent in MySQL, as the LIMIT clause is available. Regards, Mike Hillyer www.vbmysql.com -Original Message-

RE: MySQL Errno: 2013

Nils: sorry for the delay getting back to you. this morning we modified the variables mentioned below. Following are current 'time' related values . . . +--+---+ | Variable_name| Value | +--+---+ | connect_timeout | 3

Re: efficient query or not?

Hi Anthony, 'As Miles' just names that column in the output, and if you want to retrieve locations within a radius, you need that name, eg SELECT loc1.name, loc1.lat, loc1.lon, loc2.name, loc2.lat, loc2.lon, 3963 * acos(cos(radians(90-loc1.lat)) * cos(radians(90-loc2.lat)) + sin(radians(90-

Re: debuggine 1205 / LOCK wait timeout exceeded errors

# [EMAIL PROTECTED] / 2003-06-04 17:11:19 +0300: > Roman, > > looks like your application fails to commit this transaction: > > " > 030604 13:52:21 INNODB MONITOR OUTPUT > ... > LIST OF TRANSACTIONS FOR EACH SESSION: > ---TRANSACTION 0 407759, ACTIVE 2090 sec, OS thread id 10251 > 10 lock struct(

PLEASE ADD THIS TO DOCUMENTATION...

Well, I just discovered through trial and error that threads ARE being spawned on Redhat 8. The problem is that the "ps" that came with 7.2 7.3 was compiled to show threads as separate processes it seems. On Redhat 8 you have to add the "-m" switch to "ps" to make it show all threads. Just th

RE: table copying/replication

This sounds like the best idea yet :) I have a couple of questions: - I need to keep the data in x_shadow while still creating table x.. will copying accomplish the same thing? I'm guessing it will be slower, but keeping the 'shadow' table around is important. - Will either / both of these (r

Please ADD this to documentation on website...

Well, I just discovered through trial and error that threads ARE being spawned on Redhat 8. The problem is that the "ps" that came with 7.2 7.3 was compiled to show threads as separate processes it seems. On Redhat 8 you have to add the "-m" switch to "ps" to make it show all threads. Just th

Re: Can't open privilege tables: Table 'mysql.host' doesn't exist

Nils, most probably you have some other difference in the my.cnf files. Regards, Heikki - Original Message - From: "Nils Valentin" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, June 04, 2003 6:22 PM Subject: Re: Can't open privilege ta

Apologies for the double posting...

I just thought that perhaps group rules had permitted the posting of my all caps subject line. I have nothing but praise for MySQL, it was just this one threads topic that was impossible to find any info on. :( Thanks for listening to me. --- Tim Meader ODIN Unix Group ACS Government Services

RE: table copying/replication

I have looked at this idea as well, and I am unsure what problems issuing a 'flush tables' could cause: - will it take a long time to complete with lots of tables and indexes? - does any locking happen while this is going on, or is each table available after it's been re-read from disk? - iirc,

RH 8.0 InnoDB: Assertion failure in thread 122911 in file mem0pool.c line 477

I have reported this before, but MySQL-Max-3.23.56-1 (official rpm's) is repeatedly crashing. Often when executing queries on an InnoDB table with about 1300 rows that are similar to this: select MEET, count(*) from RATINGS_WHENU where MEET in ('N','Y') and SITE = '63' group by MEET I can run

another replication question..

I have another question that doesn't seem to be addressed in the mysql manual. Does any sort of locking occur while a slave is updating it's local databases? Can I still read any/all tables while this process is occurring? If there is locking, is the lock table-based or for the entire db? My sl

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in file mem0pool.c line 477

Richard, please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it. Also note that you should make sort buffer and record buffer smaller, s

RE: table copying/replication

Hi Ross, On Wed, 2003-06-04 at 16:35, Ross Simpson wrote: > This sounds like the best idea yet :) > > I have a couple of questions: > > - I need to keep the data in x_shadow while still creating table x.. > will copying accomplish the same thing? I'm guessing it will be slower, > but keeping t

Re: malloc'ing 2GB+ of memory in mysql

> best to test first with a borrowed Opteron. I want to see the stability and > that fsync() and other kernel calls work fast. A customer tested recently a > big Itanium II box and its performance looked ok. Tom's Hardware did some benchmarking of MySQL 3.23.52 with the Opteron: http://www.tomsha

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in file mem0pool.c line 477

Hello Heikki, Sorry, last version of the MySQL-Max rpm was missing the symbols file. This version has it, so I did as you asked. Here is the output of the most recent 4. Regarding mem usage, the machine has 1gb, mysql is using 374MB which is fine as far as I am concerned. I can decrease the nu

FW: WWDC 2002 Tracks

FYI -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anjo Krank Sent: Monday, June 02, 2003 1:41 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: WWDC 2002 Tracks Hi everybody, I haven't seen a message yet, so: Apple has made the video tracks from last

detailed FULLTEXT index and search help needed

Hello All. I have a table that is about 1.5GB with about 400 records. As you can tell, every record is about 4MB, all of which is text. I've created a fulltext index on the table, with > alter table table2002 add fulltext data (data); After this is done (takes about 20 minutes to do) I check out

Re: efficient query or not?

Hi, ok thank you, If i do the following SELECT userid FROM location WHERE longitude BETWEEN -80 and -94 AND latitude BETWEEN 30 and 49 AND 3963 * acos(cos(radian(90-place.lat)) * cos(radians(90-mylat)) + sin(radians(90-place.lat)) * sin(radians(90-mylat)) * cos(radians(place.lon-mylon))) < 100

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in filemem0pool.c line 477

Richard, - Original Message - From: "Richard F. Rebel" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 04, 2003 7:50 PM Subject: Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in filemem0pool.c line 477 > Hello Heikki, > >

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in filemem0pool.c line 477

Hello Heikki, On Wed, 2003-06-04 at 13:26, Heikki Tuuri wrote: > the memory deallocation seems to happen usually in > > " > if (prebuilt->blob_heap != NULL) { > mem_heap_free(prebuilt->blob_heap); > prebuilt->blob_heap = NULL; > } > " > > select M

Re: authentification intranet

I guess the problem is with your authentication. Mysql 4.1 uses a new auth schema. You might want to try use mysql; update user set password=old_password("your password") where user='your username'; J. - Original Message - From: antoine druon <[EMAIL PROTECTED]> Date: Wednesday, June 4

Re: URGENT: Problems compiling mysql 3 and 4 on IRIX indy 6.5 IP22 mips

Look at http://gcc.gnu.org/ml/gcc-bugs/2000-11/msg00293.html (I don't know anything about this, but that page seems very relevant.) -S > > From: Jason Buchanan <[EMAIL PROTECTED]> > Date: 2003/06/04 Wed AM 08:22:29 CDT > To: [EMAIL PROTECTED] > Subject: URGENT: Problems compiling mysql 3 and

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 infilemem0pool.c line 477

Richard, - Original Message - From: "Richard F. Rebel" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 04, 2003 8:38 PM Subject: Re: RH 8.0 InnoDB: Assertion failure in thread 122911 infilemem0pool.c line 477 > Hello Heikki, > > O

mysql4 query cache pruning unnecessarily?

Hi- Can anyone tell me why mysql4 would prune queries from the cache if the Qcache_free_memory is still very big? I'm confused why we get so many Qcache_lowmem_prunes: | Qcache_queries_in_cache | 175011 | | Qcache_inserts | 343244 | | Qcache_hits | 4041221| |

Re: NEWBIE QUESTION: Copying Databases from local to server

I'd suggest using phpMyAdmin on the remote server for your setup. Depending on the application, it might make further transfers easier in the future. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Creative Solutions New Media" <[EMAIL PROTECTED]> To:

Mysqlhotcopy usage problem

Hello All, I am facing following error while I am trying to use mysqlhotcopy utility for hot backups. I am not sure that how can I check the perl correct installation. Please see below [EMAIL PROTECTED]:/usr/local/mysql/bin > mysqlhotcopy --help Can't locate DBI.pm in @INC (@INC contains: /opt/pe

FW: MySQL for our production reporting data warehouse

> -Original Message- > From: Sonia Ghadially > Sent: Wednesday, June 04, 2003 12:59 PM > To: '[EMAIL PROTECTED]' > Subject: MySQL for our production reporting data warehouse > > Dear Sir/Madam: > > My company is thinking of using MySQL for our production reporting data

MySQL for our production reporting data warehouse

Dear Sir/Madam: My company is thinking of using MySQL for our production reporting data warehouse. Could you please tell me: 1) What is the latest release of MySQL, and what is the latest stable release of MySQL? 2) On the MySQL website, what is the difference between the following (releases?)

good or bad?

Hi, going to back to the thread of best SQL statment i did: this EXPLAIN SELECT * FROM `zip` WHERE longitude BETWEEN - 98.315 AND - 94.662 AND latitude BETWEEN 31.696 AND 34.587 AND 3963 * acos( cos( latitude ) * cos( 33.1414 ) + sin( latitude ) * sin( 33.1414 ) * cos( - 96.5883 - longitude )

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 infilemem0pool.c line 477

Hello Heikki, On Wed, 2003-06-04 at 14:29, Heikki Tuuri wrote: > Richard, > hmm... maybe mysqld is reporting a wrong query in a crash. Do you have any > BLOB (or TEXT) tables and what kind of queries you run on them? How big are > the BLOBs if any? > > The hex dump looked like parts of some lo

Re: mysql4 query cache pruning unnecessarily?

LS <[EMAIL PROTECTED]> writes: > Hi- > Can anyone tell me why mysql4 would prune queries from the cache if the > Qcache_free_memory is still very big? I'm confused why we get so many > Qcache_lowmem_prunes: Mysql will prune queries if the tables are updated, maybe this is what you are experienc

Re: MySQL for our production reporting data warehouse

Sonia Ghadially <[EMAIL PROTECTED]> writes: > Dear Sir/Madam: > > My company is thinking of using MySQL for our production reporting data > warehouse. > > Could you please tell me: > > 1) > What is the latest release of MySQL, and what is the latest stable release > of MySQL? Go to http://www.

Problem with mysql replication

I'm currently trying to setup replication following the directions from the mysql manual, however, once I configure the slave server with the server-id parameter, it fails to load. If I remove server-id=2 from my.cnf then the server starts up fine. I'm hoping someone can help me out: Master and

Re: mysql4 query cache pruning unnecessarily?

The tables certainly get updated and therefore those queries should be ejected from the cache, but it's not a memory issue. Does that mean that Qcache_lowmem_prunes is actually the sum of low memory prunes and dirty queries? The manual doesn't seem to suggest this, so it would be cool if someone co

RE: NEWBIE QUESTION: Copying Databases from local to server

Thanks everyone for the replies. I know I should probably be using phpMyadmin or the command line to export my info out of my local mySQL setup but... I'm using mySQL control center. Using this tool I can't seem to export. There is a button to do it but it is always greyed out. Is there a step

Re: RH 8.0 InnoDB: Assertion failure in thread 122911infilemem0pool.c line 477

Richard, - Original Message - From: "Richard F. Rebel" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 04, 2003 10:28 PM Subject: Re: RH 8.0 InnoDB: Assertion failure in thread 122911infilemem0pool.c line 477 > > Hello Heikki, > >

Re: FW: MySQL for our production reporting data warehouse

Sonia, >> My company is thinking of using MySQL for our production reporting data >> warehouse. If you intend to use MySQL for production purposes, you should go to http://www.mysql.com/ and download the database server labeled "Production" (currently 4.0.13). MySQL has fast release cycles, and i

URGENT: Problems compiling mysql 3 and 4 on IRIX indy 6.5 IP22 mips

Hi! > "Jason" == Jason Buchanan <[EMAIL PROTECTED]> writes: Jason> hi, Jason> I'm having a hard time getting mysql 4 and mysql 3 to compile on IRIX 6.5... Jason> Does anyone have a solution to this? Jason> Below is an example of compiling mysql 4.0.13 (looks practically Jason> identical

RE: NEWBIE QUESTION: Copying Databases from local to server

You can see more in-depth descriptions in the documentation, but for a simple shot at migrating data and database structures from one machine to another, you can try: Prompt> mysqldump --add-drop-table <> -uroot -ppassword | mysql --host=new.host.ip.add -uroot -ppassword You can dink around wit

Re: RH 8.0 InnoDB: Assertion failure in thread 122911infilemem0pool.c line 477

Hello Heikki, On Wed, 2003-06-04 at 16:27, Heikki Tuuri wrote: > actually, it probably is reporting the right query :). It is the TEXT column > `FEEDBACK` text. TEXT is essentially the same as a BLOB. > > > > I have exorcised the code we have that updates and interacts with this > > table in o

MySQL List Stats for May, 2003

As some of you know, we host the MySQL list searchable archives at ListSearch.com as a free service to the MySQL community. To access said archives, visit . The archives not only allow you to search on various fields of information (body, date, subject, au

Count on Multiple Tables

I've been stuck on this one all morning. Can't seem to figure it out. I have 2 tables, one with affiliate sales and another with affiliate clickthroughs. I have to query both tables, so that I can get clickthrough dates, hits, and then query affiliate sales table to get number of orders for each d

How to exporting MySQL table for web publishing

Could you please advise me on how to export data in LINUX/MySQL table for web publishing? Thanks Lili -- MySQL General Mailing

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

Hi Neil. On Wed, Jun 04, 2003 at 02:33:22AM -0230, Neil Zanella wrote: > I believe that MySQL is in error in reporting the following message just > because I did not specify that the PRIMARY KEY should not be NULL. These > days there are standards and SQL92, AFAIK, specifies that if the primary >

[Correction] MySQL List Stats for May, 2003

--- Please ignore my prior post on this. The numbers were wrong as it turned out I inadvertently based a portion of the report on numbers from June, 2003. Please find below the correct report. --- As some of you know, we host the MySQL list searchable archives at

Re: Replication over SSL

Hi Gareth. On Tue, Jun 03, 2003 at 09:59:52AM +0100, Gareth Davis wrote: > I guess this is right place for this. I'm trying to setup replication > between two hosts over the Internet. > > My problem is that i can't seem to solve an authentication problem > between the slave and the master. Before

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

I'm unsure what you see as a problem here? The only conflict with relational theory would occur if MySQL *permitted* NULL values in primary keys. According to the error message you received, MySQL is doing a fine job of preventing this. CREATE TABLE test ( col1 INT PRIMARY KEY,

RE: How to exporting MySQL table for web publishing

>Could you please advise me on how to export data in > LINUX/MySQL table > for web publishing? If you need the data in a mysql table displayed in an HTML table, a quick and dirty way to get a static file is to run this from the command line... #mysql -uroot -p -H -e"SELECT * FROM Employee"

MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

Hi, We agree that statements of the form CREATE TABLE table-name (column1 INT PRIMARY KEY) should be legal -- it should not be necessary to say CREATE TABLE table-name (column1 INT PRIMARY KEY NOT NULL) The requirement, that primary keys should explicitly be declared as NOT NULL

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Becoming Digital wrote: [snip] > from http://www.mysql.com/doc/en/CREATE_TABLE.html: > a.. A PRIMARY KEY is a unique KEY where all key columns must be defined as NOT > NULL. If they are not explicitly declared as NOT NULL, it will be done > implicitly

Cannot build mysql 3.23.56 on AIX 4.3.3

[Second copy just in case] >Description: makeinfo fails to build the manual.txt file and kills the build Also having the same problem with 3.23.51 (needed to build the upgrade). >How-To-Repeat: after running the configuration program, run gmake >Fix: No idea - hoping you could

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

> You have to remember that the manual is kept in sync with the _latest_ > version of the server ... I know. I chose to avoid that in my comments, even though the original post was regarding v3.23.54 > This change happened in 4.0.13 (implictly and quietly) :) I saw that after I checked out the

bug in replication?

Before I send this to [EMAIL PROTECTED] I would like to see if anyone else is hitting a replication bug in 3.23.5x Last_Errno Last_error 4294967295 | error 'unexpected success or fatal error' on query 'UPDATE member_stats1 SET view7=0' Notice the Errno, it's the not the errorno for the error

RE: bug in replication?

Let me clean up my grammar and explanation a bit. I rushed the email message. -->-Original Message- -->From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] -->Sent: Wednesday, June 04, 2003 5:26 PM -->To: [EMAIL PROTECTED] -->Subject: bug in replication? --> -->Before I send this to [

Re: FW: MySQL for our production reporting data warehouse

1) www.mysql.com >> look at the top left corner 2) - Gamma (widely deployed, no more critical bugs reported by users, thus "almost production"), - Beta (not so widely deployed, so the server might still contain critical bugs that show up only in certain environments / situations), - Alpha (no b

Re: MySQL List Stats for May, 2003

I am not sure if I will use it often, but definitely well done ;-) Very clear organization of the data. Thats definitely something which will be highly appreciated by most list members (and MySQL AB) I am sure !! Best regards Nils Valentin Tokyo/Japan 2003年 6月 5日 木曜日 06:55、Bill Doerrfeld

Re: [Correction] MySQL List Stats for May, 2003

Hi Bill, Such a pitty. For a moment I thought I am the new No.1 ;-) (see previous posted data) Best regards Nils Valentin Toko/Japan 2003年 6月 5日 木曜日 07:29、Bill Doerrfeld さんは書きました: > --- > Please ignore my prior post on this. The numbers were wrong as it > turned out I inadv

Re: detailed FULLTEXT index and search help needed

Hi Kunzmann, I might be wrong but to answer your question I think three things are necessary: 1) we will need to know the table structure(s) 2) we wil need to know which column you indexed 3) we wil need to know which request(s) you used Is it possible that you indexed a column in the big tabl

Re: authentification intranet

Dont forget "FLUSH PRIVILEGES" ;-) otherwise you might be wondering why the new settings dont apply. Best regards Nils Valentin 2003年 6月 5日 木曜日 02:55、jinal jhaveri さんは書きました: > I guess the problem is with your authentication. Mysql 4.1 uses a new auth > schema. You might want to try use mysql;

Re: Can't open privilege tables: Table 'mysql.host' doesn't exist

Hi Heikki, Thank you for the reply. I understand that this is related to the host.frm. Thank you very much. The part which I don't get is why would a standard my.cnf file (skipping innodb) start up and the my.cnf file containing the innodb settings give me such an error ? I understood your adv

Re: nested ORDER BY statements

Hi David, can't give you detailed advice but I believe you look for SELECT...GROUP BY ... ORDER BY Please see the docs like "info mysql". Best regards Nils Valentin Tokyo/Japan \ 2003年 6月 4日 水曜日 22:37、Dave Terrio さんは書きました: > Hello - I'm a relative newcomer to development with MySQL and am

Re: MySQL Errno: 2013

Hi Kevin, thats alright, let me know when it worked, thats what I want to hear ;-) Best regards Nils Valentin 2003年 6月 5日 木曜日 00:12、Kevin A. Miller さんは書きました: > Nils: > > sorry for the delay getting back to you. > > this morning we modified the variables mentioned below. Following are > current

No Session Setup-Refused Connection

Hi All, Can someone help me debug this? [2003/06/05 09:24:45, 3] smbd/reply.c:reply_sesssetup_and_X(858) Domain=[] NativeOS=[Windows 2000 2195] NativeLanMan=[Windows 2000 5.0] [2003/06/05 09:24:45, 3] smbd/reply.c:reply_sesssetup_and_X(868) sesssetupX:name=[] [2003/06/05 09:24:45, 1]

Installation - libmysqlclient.so (Redhat 8)

Hi All, Newbie question. Stock Standard Redhat 8.0 install with MySQL 3.23. Have not started using, so thought I can upgrade to Version 4.0 it before I face more problems later on. RPM -e mysql* libmysqlclient.so.10 needed by perl-DBD-MySQL from the Mysql manual, it says that we can in

Re: good or bad?

Anthony, I think 5.2.1 Explain Syntax in the manual covers what you are asking about. PB - Original Message - From: Anthony Ward To: [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 2:26 PM Subject: good or bad? Hi, going to back to the thread of best SQL statment i d

Re: mysqld CPU usage is almost 100% !!!

On Thu, Jun 05, 2003 at 10:05:00AM +0700, nino wrote: > Hi folks, > > I'm experiencing some phenomenon that mysqld is consuming CPU at > almost 100%. At this time, I only assemble a few database with > record size is about 37000 rows. Is mysqld likely gonna crash or > something ?? > > I also not

Re: mysqldump

Hi Massimo, sorry for the late reply. I lost your e-mail for a moment (so many) ;-). I dont understand if you want to export to another database server or a completely other format. In case you are looking to transfer the datbase and /or tables then I think you can do the following: Export al

failure to build MySQL v4.0.13 on Solaris-9

Hi, I am struggling to compile version 4.0.13 under Solaris-9 using GCC version 3.2.3 : according to "http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html";, I have set the following variables BEFORE running configure: CFLAGS="-O3" CXXFLAGS="-O3 -felide-constructors -fno-

Re: mysqld CPU usage is almost 100% !!!

On Thu, Jun 05, 2003 at 11:33:23AM +0800, Ahmad Rezal Ibrahim @ PNSB wrote: > > check either your using ODBC - trace is on ? How would that impact the server? I'm not terrible ODBC-literate, so I don't know. Jeremy > -Original Message- > From: nino [mailto:[EMAIL PROTECTED] > Sent: Thu

testing concurrent connections

Hi, Does anyone know of a program/good way to test the number of concurrent connections a MySQL server can handle? I get errors building super smack (and I've also tried an old script called mysql-con_stress (by Sascha) with similar results...) Can anyone help? I'm using SuSE 8.2, gcc version

REPOST: FULLTEXT searching help needed. Please somebody help.

Hello All. I am using Redhat 9.0 with MySQL 4.0.12-0. I've hit something of a dead-end with fulltext searching and I don't know where to look next. I have a table that is about 1.5GB with about 400 records. As you can tell, every record is about 4MB, all of which is text. I've created a fullte

2 different Mysql DB on the same server

Hi to all, I need to have on the same PC (that is the Server) 2 different mysql DBs; I need it because I need some data on the standard mysql dir (for example ...\mysql\data\) and some data on a different dir. I installed mysql simply installing phpdev423; therefore I found out automatically the D

Stripping off commas

Hi All, I'm using Mysql as my database and php as my script to connect to the MySQL server. Supposed I have a number with a value of 10,000. How do I strip off the comma using php. I manage to use the number_format to put a comma. How do I go about this. Any help will be appreciated. Regards, De

Re: 2 different Mysql DB on the same server

This ? http://www.mysql.com/doc/en/Installing_many_servers.html Jerry - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 8:55 AM Subject: 2 different Mysql DB on the same server Hi to all, I need to have on the same PC (that is the Ser

Re: Stripping off commas

http://www.php.net/manual/en/function.substr-replace.php - Original Message - From: "delz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 8:57 AM Subject: Stripping off commas > Hi All, > > I'm using Mysql as my database and php as my script to connect to the

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

I think your index is corrupted because I expect a 1.5 GB index and not 8M! You can see word list wit a utility (sorry I don't remember te name ft_dump). I suggest You to drop fulltext index, duplicate database and remove some rrecords. Then create index index again. Some questions: Do You have d

RE: REPOST: FULLTEXT searching help needed. Please somebody help.

create fulltext index Name on Table(field) i didnt get this i usually do add fulltext field (field) i think , is that wrong ?? -Original Message- From: Santino [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 6:14 PM To: [EMAIL PROTECTED] Subject: Re: REPOST: FULLTEXT searching he

RE: 2 different Mysql DB on the same server

u need two different instances , totally different source directories for instance , an they run on ifferent pors say one on 3306 and one on 3307 mind u php ha problems connecting to something not on 3306 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday,

Problem with adding a new user by non root user with GRANT OPTION

Hi! I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS to that database. When logon with that new user and want to create a new user with some privileges a get an error. How I do it: mysql> grant all privileges on temp.* to [EMAIL PROTECTED] identified by 'haslo' with grant

Re: another replication question..

Hi Ross, On Wed, 2003-06-04 at 16:44, Ross Simpson wrote: > I have another question that doesn't seem to be addressed in the mysql > manual. > > Does any sort of locking occur while a slave is updating it's local > databases? Can I still read any/all tables while this process is > occurring? >

Getting the row back with the highest ID.

Hi List. I think I'm having a very off day and need some confirmations on how MySQL works with it's result sets. I have a couple of relational tables , the first holding the person's name and address for instance, and the other tables holds comments and complaints respectively. Each table has it'

ANN: EMS MySQL Manager for Linux 1.3 released

EMS HiTech company is pleased to announce MySQL Manager for Linux 1.3 -- the next version of our powerful MySQL administration and development tool! You can download the latest version and user's guide from http://www.ems-hitech.com/mymanager/download.phtml What's new in version 1.3? 1. We've ad

load file

Hi, I have a a text file delimited with | and I don't how to load the data into a table and say delimited by '|' I think it is this: LOAD DATA INFILE 'C:\data.txt' INTO TABLE table2 FIELDS TERMINATED BY '|'l Any clarification would help. Anthony -- MySQL General Mailing List For list archiv

Getting the last entered row from a relational table

Hi List. I think I'm having a very off day and need some confirmations on how MySQL works with it's result sets. I have a couple of relational tables , the first holding the person's name and address for instance, and the other tables holds comments and complaints respectively. Each table has it'

Re: Getting the row back with the highest ID.

Petre Agenbag <[EMAIL PROTECTED]> wrote: > > I think I'm having a very off day and need some confirmations on how > MySQL works with it's result sets. > > I have a couple of relational tables , the first holding the person's > name and address for instance, and the other tables holds comments and

Re: Problem with adding a new user by non root user with GRANT OPTION

"Marcin Blazowski" <[EMAIL PROTECTED]> wrote: > I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS to > that database. When logon with that new user and want to create a new user > with some privileges a get an error. > > How I do it: > > mysql> grant all privileges on temp.

  1   2   >