Solved - median (was Re: mean/median/mode)

On Wednesday, December 3, 2003, at 06:27 PM, Robert Citek wrote: How can I calculate the mean/median/mode from a set of data using SQL? After a bit of googling, I found this link: http://mysql.progen.com.tr/doc/en/Group_by_functions.html and a few answers in the comments towards the bottom. Belo

Lost connection to MySQL server during query - pls help

Hi Guys, I have a problem with "Error 2013 - Lost connection to MySQL server during query" I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro. They turn out to have the same error. My problem is: I have a Java program which is actually a thread to send emails, so it

Re: Large data set load and access

>So, if you were willing to give up a little storage space, >make the gbl_locus field a Char(20) instead of a varchar(20) >and see if it speeds things up. I found noticable speed >increase in my selects doing this. Thanks for the heads up on this. Unfortunately the only varchar is the gbl_l

Re: How to query

I'm stumped... Now, I need to generate reports for a specific client. In the end, for a given month, I have to tell the client 1. Which invoices were for the purchase of blue widgets, only. 2. Which invoices were for the purchase of blue widgets and yellow widgets, together. 3. Which invoices for

Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS

Hello, Thanks for the response. There is one thing that is not clear however. Regardless of whether or not I perform the fulltext search with or without the SQL_CALC_FOUND_ROWS keyword, the results that I get are exactly the same. Also, the notion of stopping after the limit is reached cannot

error when inserting long string from cgi

Hi there, I am attempting to insert a string into a longtext field (from a CGI program using the C API) and I keep getting an error message. The string is not that long actually, 78,069 characters. (Originally this was mediumtext, but I changed it to longtext as I debugged this problem.) The comm

Re: Named Pipe crashes on MySQL (4.1.1 alpha) WinXP

Hi Ed, Yeah, I just installed today's 4.1.1-alpha-nt on Win2k SP3 and get the same thing. :-( Sucks, 'cause named pipes are a lot faster for me than TCP/IP. And I was really looking forward to this release. It's just not the same with TCP/IP. :-( Matt - Original Message - Subject: N

RE: automate MSAccess into MySQL

Visit my web site and look at data converters Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London EC2N 2JX Tel +44(0)870 922 0247 Fax +44(0)1323 419554 email [EMAIL PROTECTED] URL www.bpenet.net Also in Dublin & Luxembourg -Original Message- From: McKeever

Re: MySQL vs. MaxDB

from http://www.mysql.com/press/release_2003_35.html "The MySQL database is a high performance relational database management system that is noted for its speed, stability and ease of use, while MaxDB is certified for SAP applications and includes features such as stored procedures, triggers and

Re: Tree-like structure: make it simply

I think I can help with questions 1 and 3... see below, - Original Message - From: "Alex E.Wintermann" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 04, 2003 11:44 PM Subject: Tree-like structure: make it simply > Hello mysql, > > I have some table: > /* BEGIN D

Tree-like structure: make it simply

Hello mysql, I have some table: /* BEGIN DUMP */ CREATE TABLE `sp_tovar_vid` ( `id` int(11) NOT NULL auto_increment, `id_tovar_vid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `description` varchar(255) NOT NULL def

MySQL vs. MaxDB

Hola, I was wondering if anyone could point me to any articles or URLs that could give me an idea of the differences between MaxDB and MySQL, specifically if one were to use MaxDB instead of MySQL, what disadvantages would come with the advantages (which to me are basically some of the features

Re: automate MSAccess into MySQL

On Thu, 04 Dec 2003 15:00 , Warren <[EMAIL PROTECTED]> sent: >Is there a way to automate an export of a single table from a MS Access >DB into a Temp MySQL DB? > >I would like to make a front end that the client can select the correct >MS Access DB and then the correct table and once those are

Re: Large data set load and access

[EMAIL PROTECTED] wrote: mysql> create table gb_locus ( -> gbl_id int primary key, -> gbl_fileID int, -> gbl_locus varchar(20), -> gbl_sizeint, -> gbl_datedate, -> gbl_phylum char(3),

Re: Off Topic: MySQL Icons

Try google images... It's where I go every time I need to find an image that I don't have on hand. Drew On Thu, 2003-12-04 at 18:01, Daniel Kasak wrote: > Hi all. > > I'm prettying up my Gnome desktop, and I'm after a MySQL icon for my > MySQLCC launcher. > Anyone know of some icons? > > -- >

Off Topic: MySQL Icons

Hi all. I'm prettying up my Gnome desktop, and I'm after a MySQL icon for my MySQLCC launcher. Anyone know of some icons? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROT

Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS

Hi, Yes, you would have similar results with any query that uses SQL_CALC_FOUND_ROWS. That's because MySQL has to see how many rows would be found without the LIMIT. So in your case, it can't just abort the query after it finds 10 rows. All rows that match the WHERE need to be found. You might wa

Large data set load and access

Folks, Just completed an interesting task utilizing mySQL 4.0.16. The database I'm creating is some summary information from the GenBank info from the NCBI. I must say that I am quite impressed by the performance that I am seeing. The data set is pretty substantial, consisting of almost 30M

Re: automate MSAccess into MySQL

Warren wrote: Is there a way to automate an export of a single table from a MS Access DB into a Temp MySQL DB? I would like to make a front end that the client can select the correct MS Access DB and then the correct table and once those are selected the table will be exported into the MySQL D

automate MSAccess into MySQL

Is there a way to automate an export of a single table from a MS Access DB into a Temp MySQL DB? I would like to make a front end that the client can select the correct MS Access DB and then the correct table and once those are selected the table will be exported into the MySQL DB for my C++ fr

MySQL/InnoDB-4.1.1 is released

Hi! The long-awaited MySQL/InnoDB-4.1.1 has been released. It is still labeled as alpha, because there are so many new features and bug fixes in it compared to 4.1.0. IMPORTANT NOTE: if you upgrade to InnoDB-4.1.1, you cannot downgrade any more! That is because earlier versions of InnoDB are not

Running Multiple Servers

Hi, Has anyone on this list ever been successful in running two MySQL servers at one? I'm assuming they have ;-) I am having some issues and am hoping for some help or pointers to help. When I try to run my second server I get this error message in the log: 031204 11:35:01 mysqld started 0312

Optimizing a cross-reference table: tips?

I am in in the processing of laying out a database for a consulting firm. My basic structure is like so: placement_candidate (candidates listing) primary key = CandidateID placement_primarytech (skills listing) primary key = PrimaryTechID I have created an intended cross-referen

RE: stopping or aborting a long query

From: Robert Citek [mailto:[EMAIL PROTECTED] > How does one stop or abort a query? > > I was doing some experimenting with MySQL and created a table with > 100,000 records. I then did a join like so: >create table foo select foo.name, foo.val from foo, foo x, > foo y, foo > z ; > > This

stopping or aborting a long query

Hello all, How does one stop or abort a query? I was doing some experimenting with MySQL and created a table with 100,000 records. I then did a join like so: create table foo select foo.name, foo.val from foo, foo x, foo y, foo z ; This took a long time. So, I aborted with Ctrl-C (^C) whic

Re: How do I know what my MySQL server IP is ??

On Thursday 04 December 2003 03:42 pm, Stéphane Bischoff wrote: > Hi, > > w do I know what my MySQL server IP is ?? > > thanks How about ifconfig? James Hicks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED

How do I know what my MySQL server IP is ??

Hi, w do I know what my MySQL server IP is ?? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: New Microsoft Critical Patch

I've been getting these for about a week, sometimes several times a day. This also was before I subscribed to this list. However: we have a mail system that automatically scans e-mails, especially those with attachments. Our system is flagging these up as containing the W32/[EMAIL PROTECTED] vi

Re: Record Locking

I dont know if you can lock entries in a table but a table you can. More info: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#Locking_Issues --- Mike Doanh Tran <[EMAIL PROTECTED]> wrote: > hi all, > > Can someone show me how to lock a record in mySQL? > As

RE: New Microsoft Critical Patch

I have checked almost every M$ critical patch and other messages with the same content and as far as I can tell none came via this or any other list. Easy enough to find out: look at the headers. If it says: Received: from lists.mysql.com (lists1.mysql.com [213.115.162.31]) List-ID: Precedence:

Re: Record Locking

I dont know if you can lock entries in a table but a table you can. More info: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#Locking_Issues > --- Mike Doanh Tran <[EMAIL PROTECTED]> > wrote: > > hi all, > > > > Can someone show me how to lock a record in

RE: New Microsoft Critical Patch {OT}

[snip] Okay, let me ask a slightly different question. I am getting several of these Microsoft emails every day and I think that they are coming via this list. Is anyone else having similar problems or am I following a red herring? [/snip] Red-herring. We get several dozens of these each day from

RE: New Microsoft Critical Patch

Hi John, I've been getting those fake e-mails for a month, but I joined this mailing list only a week ago, so they definitely did not start coming from this list. Bob -Original Message- From: John Griffin [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 11:30 AM To: [EMAIL PR

Record Locking

hi all, Can someone show me how to lock a record in mySQL? As far as my understanding goes, only innoDB tables support record locking level. I am currently using mySQL version 3.23 and my tables are in myISAM. Thanks in advance for any assistance. Mike -

RE: New Microsoft Critical Patch

Okay, let me ask a slightly different question. I am getting several of these Microsoft emails every day and I think that they are coming via this list. Is anyone else having similar problems or am I following a red herring? John -Original Message- From: B. van Ouwerkerk [mailto:[EMAIL

Re: Out-of-control log file

Seriously, can anyone help me out here? I've searched the list and I've searched around the Internet. I've found other people reporting a similar entry into their log files, but no one answered them either. I've read up on a few things, and I have a feeling that this error is related to some

Replication Error 1053

Mysqlians, The sql_thread on our slave slave server has been stopping with error 1053 ERROR: 1053 Server shutdown in progress 031203 16:05:01 Slave: error 'Server shutdown in progress' on query 'INSERT INTO INTEREST ( ID, PERSON_ID, COMMENT, DATE_CREATED, INTEREST_ID ) VALUES

Re: Install of mysql 4.1.x on RH 9

Rudy Metzger wrote: Dear all, I am positive this has been asked a 1000 times before, but i cannot find it anywhere on the archive. Maybe a good search function there would help :) There is a search function for the archive, though I admit it's hard to see. In the thin blue bar at the top of th

[OT] RE: New Microsoft Critical Patch

> Can we do anything about these? I am getting several of them a day. Do delete them WITHOUT having read them as soon as possible! Someone wants to abuse M$ Security issues for him/her and to infect your PC! These mails almost like M$, but only almost. Have close look at the sending address. If it

Re: Openssl support?

I realized that I should probably mention that I've got OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and Debian hosts. I compiled MySQL 4.0.16 --with-openssl --with-vio and when I look at the variables, "has_openssl" is set to "NO". What could have happened to cause this? -Greg g

sql 3.23.51 installation errors

I came across the following errors after install I am not able to start server from terminal (only progress with root not user) 1. ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 2. WARNING: The host 'localhost' could not be looked u

Re: WHERE with CASE colums?

On Thursday, December 04, 2003 6:22 PM CET, Martijn Tonies wrote: > Cause the WHERE clause only works on columns. If you want to > do a match on the result of the CASE, you have to do your case > thingy again: > > WHERE ( case ...yourstuff... end ) = 'something' Wouldn't HAVING help here? -- Yv

Openssl support?

I compiled MySQL 4.0.16 --with-openssl --with-vio and when I look at the variables, "has_openssl" is set to "NO". What could have happened to cause this? -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROT

How to query

I'm stumped... I have a pretty standard invoice system: create table invoice( InvoiceNum varhcar(16), ClientInfo ) create table line_items( InvoiceNum varchar(16), ProductCode varchar(10), Description varchar(25), Quantity . ) Three is, of course, a one-to-many relation betwe

Re: WHERE with CASE colums?

Hi Scott, === When searching and listing them I want to remove any preceeding 'The ', 'An ', or 'A ' that occurs in the title and I also want to be able to search it. The case statement as follows seems to work fine: SELECT CASE WHEN title LIKE 'The %' THEN RIGHT( title, length( title ) -4 )

Re: MySQL 4.1 : curious privilege problems (grant, use, show databases)

Hi. Upgrading to 4.1.1 from 4.1.0 seems to solve my problem. There is no more (at the moment) curious privileges problems. Everything seem OK. Thanks to MySQL. N.B.: Please se the history of the problem bellow. Christophe. On Tue, 2 Dec 2003, Sergei Golubchik wrote: > Hi! > > On Nov 25, Chri

Re: FRM file disappears -- any way to rebuild or recover?

* Reverend Deuce aka Robert > I am examining the file in a HEX editor right now and have identified the > pattern. The table size divided by the pattern byte length is 8 bytes. The > last byte is always one of three characters ('S', 'B', or 'U') as > defined by > the program that feeds this table.

Re: Once again, three queries, same result, huge speed difference

It's not the order in which you execute the queries, it's how many time. Execute the first one 5 times, then the second one 5 times, then the third one 5 times. See if the times are different between each of the 5 runs for each query. Also, you could try reordering your query. Perhaps something

Openssl support?

I compiled MySQL 4.0.16 --with-openssl --with-vio and when I look at the variables, "has_openssl" is set to "NO". What could have happened to cause this? -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PRO

Re: FRM file disappears -- any way to rebuild or recover?

Hi! On Dec 04, Reverend Deuce wrote: > > I'm having a time deciphering this stuff. The mediumint and int say they use > 3 bytes and 4 bytes each, respectively, but using that in the table > definition yields invalid numbers. > > Any ideas? As you still have MYI file, you can simply use myisamch

Re: Licence question

We have company 1 that make's a product that communicate with MySQL server using TCP/IP. This product (company 1) does not use the MySQL client to connect to MySQL server. (Don't ask me how, I don't know) (By the way, this product really exist, that is why I am asking this question). Therefore, if

RE: String Functions

What programming language are you using? You could write a method to compare each character and return only those 0-9 as the output and discard the rest. -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 10:26 AM To: Victor Pendleton; MYSQL-List

Possible benchmark for mySQL?

Hello, I'm in the midst of using mySQL for some genetic information searching based upon the GenBank data from the NCBI, National Center for Biotechnology Information. In doing some testing on using mySQL, and began to wonder if this data set would be of interest as a benchmark for the databa

Re: RAID Strip size

Actually, you want to try to match the stripe size to your data size. The ideal would be to have a stripe size equal to the size of a record in your database. This way the disk needs only one read or write for each database record. You really don't want to fragment a record. A large stripe size

WHERE with CASE colums?

I have a table called 'Journal_Info' containing titles of various journals When searching and listing them I want to remove any preceeding 'The ', 'An ', or 'A ' that occurs in the title and I also want to be able to search it. The case statement as follows seems to work fine: SELECT CASE WH

Re: Install of mysql 4.1.x on RH 9

On Thursday 04 December 2003 16:27, Rudy Metzger wrote: > Dear all, > > I am positive this has been asked a 1000 times before, but i cannot find > it anywhere on the archive. Maybe a good search function there would > help :) > > Ok, here my problem: I am trying to install mysql 4.1.1 on RH 9.0, bu

Aliases

If you can do this: SELECT table_a_alias.col_name FROM table_a table_a_alias; Why can't you do this: SELECT 1 AS A, A + 1 AS B, B + 1 AS C; Why can't you use column aliases later in the select? When you can use table aliases even before they are defined. thnx, Chris -- MySQL Gen

RE: Licence question

Hi Stéphane, I share the comments already expressed by Roger. But would like to add the following: - If you represent company 2 you will not have to purchase the client licenses. - It seems to me it is the sole responsibility of company 1 to secure the legality and the compliance to the GPL lice

fulltext search speed issue with SQL_CALC_FOUND_ROWS

I have some_table with 100,000 rows and with an average of 500 words in some_column of each row. When i do a fulltext search on this table using a query such as the following, all of my results are under 0.1 seconds: SELECT something FROM some_table WHERE MATCH (some_column) AGAINST ('some_search_

Install of mysql 4.1.x on RH 9

Dear all, I am positive this has been asked a 1000 times before, but i cannot find it anywhere on the archive. Maybe a good search function there would help :) Ok, here my problem: I am trying to install mysql 4.1.1 on RH 9.0, but get the following errror: [EMAIL PROTECTED] mysql]# rpm -Uvh --fo

RE: String Functions

That I can do REPLACE(REPLACE(REPLACE(REPLACE(str,'(',''),')',''),'-',''),' ','') Looks kinda horrid to handle removing just four characters ( ) - and space And if any other characters end up in str, then they are not handled, and my "formula" is broken. So there is no functions that would do wha

4.1.1. -> WITH QUERY EXPANSION

Hi, In 4.1.1. new features there is: * Added `MATCH ... AGAINST( ... WITH QUERY EXPANSION)' and the `ft_query_expansion_limit' server variable. What is WITH QUERY EXPANSION? I found no details in manual. mirza -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: FRM file disappears -- any way to rebuild or recover?

Roger, Thanks for the info! I am examining the file in a HEX editor right now and have identified the pattern. The table size divided by the pattern byte length is 8 bytes. The last byte is always one of three characters ('S', 'B', or 'U') as defined by the program that feeds this table. So I *kn

RE: String Functions

Try the Replace function replace the `-` character with `` -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 10:09 AM To: MYSQL-List (E-mail) Subject: String Functions Is there any function to strip non numeric characters from a string? Such

RE: Once again, three queries, same result, huge speed difference

Hmmm, if I execute this 3 queries at any time in any order I get the same execution time. Yes, explain... explain select artists.name , cds.title , tracks.title from artists, tracks, cds where artists.artistid = tracks.artistid and cds.cdid = tracks.cdid and MATCH (artists.name) AGAINST ('mado

RE: New Microsoft Critical Patch

Can we do anything about these? I am getting several of them a day. -Original Message-From: Microsoft Corporation Technical Services [mailto:[EMAIL PROTECTED]Sent: Thursday, December 04, 2003 11:07 AMTo: ConsumerSubject: New Microsoft Critical Patch   Mic

RE: MySQL 4.1.1 has been released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 4 Dec 2003, Boehn, Gunnar von wrote: > Any chance to offer binaries for PowerPC Linux as well ? (Preferable > tgz) Yes, we plan to offer Linux/PPC binaries in the near future - we're currently working on purchasing a system for that. I h

String Functions

Is there any function to strip non numeric characters from a string? Such that FUNCTION('1-(519)-473-3853') would return '15194733853' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: FRM file disappears -- any way to rebuild or recover?

* Robert > It seems that the .FRM file for one of my largest tables has disappeared. > 180 million rows. I am not so much concerned about finding out WHY it was > deleted as I am trying to figure out how to recover the table. > > I've tried making a new table using a similar data structure (the tab

RE: MySQL 4.1.1 has been released

Hi Lenz, Lenz Grimmer wrote: > MySQL 4.1.1, a new version of the popular Open Source/Free Software > database management system, has been released. It is now available in > source and binary form for a number of platforms from our > download pages Any chance to offer binaries for PowerPC Linux

Re: Once again, three queries, same result, huge speed difference

You need to take cache into consideration when doing your testing. Both MySQL cache and the OS cache. That means rebooting between each query that you run to clear the database and OS cache. -or- Run each query 3 or 4 times (or 5, or even 10) consecutively and either take the average or the fast

MySQL 4.1.1 has been released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.1.1, a new version of the popular Open Source/Free Software database management system, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ a

mysql user

i find problem while compiling the UDF in windows. the function returns an integer and so i set the type as "long long" but this datatype is not recognised by VC++ 6.0 and i end up with a compilation error. how can i resolve this and what the prototype for functions that returns integer values

FRM file disappears -- any way to rebuild or recover?

It seems that the .FRM file for one of my largest tables has disappeared. 180 million rows. I am not so much concerned about finding out WHY it was deleted as I am trying to figure out how to recover the table. I've tried making a new table using a similar data structure (the table is only three c

RE: mean/median/mode

From: Robert Citek [mailto:[EMAIL PROTECTED] > Hello all, > > How can I calculate the mean/median/mode from a set of data using SQL? > > Mean seems to exist as the average (avg): >select name, avg(value) from table group by name > > Is there a way to calculate median and mode with a group b

Re: Licence question

* Stéphane Bischoff > Thank you for all your response, but my question is very simple : > > Example : > > We have company 1 that make's a product that communicate with MySQL server > using TCP/IP. > This product (company 1) does not use the MySQL client to connect to MySQL > server. (Don't ask me h

RE: Once again, three queries, same result, huge speed difference

Another thing that I noticed is : This query takes less than sec : SELECT artists.name, cds.title, tracks.title FROM artists, tracks, cds WHERE artists.artistid = tracks.artistid AND cds.cdid = tracks.cdid AND MATCH ( name ) AGAINST ( 'madonna' ) But when I add one more AND it takes more tha

RE: Licence question

Thank you for all your response, but my question is very simple : Example : We have company 1 that make's a product that communicate with MySQL server using TCP/IP. This product (company 1) does not use the MySQL client to connect to MySQL server. (Don't ask me how, I don't know) (By the way, thi

Re: mysql UDF in windows

At 11:45 4/12/2003 +, Prem Soman wrote: Hi, how can i resolve this and what the prototype for functions that returns integer values. i searched the manual but got no solution. In the \sql\udf_example.cpp you find: #ifdef __WIN__ typedef unsigned __int64 ulonglong; /* Microsofts 64 bit typ

Deleting using a table as reference.

Hi All! I have a problem deleting from a table and using another as reference. I use a query like: DELETE tableA FROM tableB WHERE tableA.idB = tableB.id AND tableA.data1= AND tableB.data2= (I'm using MySQL 4.0.12 on Red Hat 8

mysql UDF in windows

i find problem while compiling the UDF in windows. the function returns an integer and so i set the type as "long long" but this datatype is not recognised by VC++ 6.0 and i end up with a compilation error. how can i resolve this and what the prototype for functions that returns integer values

MySQL 4.1.1 Download

Are binaries of MySQL 4.1.1 available or we need to compile it from the source. Karam __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h

Re: Once again, three queries, same result, huge speed difference

On Thu, 4 Dec 2003, Uros Kotnik wrote: > I posted this few days ago, but with no answer, also posted it to > benchmark list.. > > Executing this SQL, takes ~5 sec. > > select artists.name , cds.title , tracks.title from artists, tracks, > cds > where artists.artistid = tracks.artistid and cds.cdi

Re[2]: MySQL 4.1.1 Download

>> Are binaries of MySQL 4.1.1 available or we need to >> compile it from the source. > No, binaries are not available yet. They will be available very soon, most probably this week (yes, I know today's Thursday :-). Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH

Double execution of queries?

One of my apps in a test enviroment is showing some strange behaviour. Up-front-answer: No, there are no loops in this segment of code. Snippet: $password = sha1(stripslashes($eval['tpassword'])); $query = "INSERT INTO logins (login_parent, login_name, login_password, fname, lname) values ($id,

Re: Query Help

On 2 Dec 2003 at 7:20, Greg Jones wrote: > > select l.ltsysid,l.lientraknum, c.name from lientrak as l, customer as c > where l.custsysid=c.custsysid > and l.ltsysid in (select l2.ltsysid from lientrak as l2 where l2.lientraknum > like '2003-%') > > Hi greg Yopur problem is that you are

Re: Error 2002

jeepcreep <[EMAIL PROTECTED]> wrote: > > I did and it is not running. Look into error log file. You can find causes why MySQL server doesn't start. > > Victoria Reznichenko <[EMAIL PROTECTED]> wrote:jeepcreep wrote: >> >> That is what I did. > > Check with > > ps ax | grep mysqld > > if MyS

Once again, three queries, same result, huge speed difference

I posted this few days ago, but with no answer, also posted it to benchmark list.. Executing this SQL, takes ~5 sec. select artists.name , cds.title , tracks.title from artists, tracks, cds where artists.artistid = tracks.artistid and cds.cdid = tracks.cdid and MATCH (artists.name) AGAINST (

Re: MySQL 4.1.1 Download

Karam Chand <[EMAIL PROTECTED]> wrote: > Are binaries of MySQL 4.1.1 available or we need to > compile it from the source. No, binaries are not available yet. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net

Error when running mysql for the first time

Hi, I downloadet the mysql 4.1 development tree made a windows source tree, and compiled with VC++6. After running mysql in console I got this error: D:\MySQL\bin>mysqld-max.exe --console InnoDB: Error: log file group too small for innodb_thread_concurrency 031204 10:33:08InnoDB: Assertion failur

RE: Query to emulate what mysqldump does

On woensdag 3 december 2003 22:56 Andrew Braithwaite told the butterflies: > You could try to use the "select into {OUTFILE | DUMPFILE} > from tablename where blah=blah..." > > I think you may be able to do "select into local outfile from > blah" > > Which will put the file on the same serv

Re: Licence question

1. Free use for those who are 100% GPL 2. Free use for those who never copy, modify or distribute 3. Commercial use for everyone else OK. But 2nd statement is not taken from GPL. Example: SUSE ships non GPL programs such as StarOffice (not OpenOffice), SUN ships Java etc. in it's Linux... This