RE: UNIONS & 'Got error 12 from storage engine'

Memory problem. Error 12 = Cannot allocate memory Marc. -Message d'origine- De : Cliff Daniel [mailto:[EMAIL PROTECTED] Envoyé : jeudi 21 avril 2005 07:43 À : mysql@lists.mysql.com Objet : UNIONS & 'Got error 12 from storage engine' Have a query that consists of 10 unions. For a peri

UNIONS & 'Got error 12 from storage engine'

Have a query that consists of 10 unions. For a period of time it will constantly return with an error 12. Moments later it might actually work once or twice. I can find nothing in any logs or whatever. The odd thing is that when it isn't working, simply reducing the unions to 8 or less returns

Re: ERROR 2013: Lost connection to MySQL server during query

Michael Gale wrote: > Hello, > > Earlier today I tried to make some table alterations on a mysql server > (4.0.24) and kept on receiving this error: > > ERROR 2013: Lost connection to MySQL server during query > > I would login to the server, either through the socket or using the > IP. Then conne

Re: many to many

On 21/04/2005 3:36 p.m., Perry Merritt wrote: Hi, I'm a novice. Hi Perry, I've designed a database that supports many to many relationships (actually many to many to many) and I need help creating the query to find my data. I know things like JOINs exist, but don't have a clue how to use them.

Re: many to many

An answer won't make much sense if you truly don't have a clue. W3schools has a good intro on joins. http://www.google.com/search?hl=en&q=sql+join+syntax&btnG=Google+Search cheers, KB On 4/20/05, Perry Merritt <[EMAIL PROTECTED]> wrote: > Hi, I'm a novice. > > I've designed a database that sup

ERROR 2013: Lost connection to MySQL server during query

Hello, Earlier today I tried to make some table alterations on a mysql server (4.0.24) and kept on receiving this error: ERROR 2013: Lost connection to MySQL server during query I would login to the server, either through the socket or using the IP. Then connect to a database and try the followi

many to many

Hi, I'm a novice. I've designed a database that supports many to many relationships (actually many to many to many) and I need help creating the query to find my data. I know things like JOINs exist, but don't have a clue how to use them. I have three main tables and two link tables, The main

Re: Question about combination PRIMARY keys and INDEX

At 9:10 +1000 4/21/05, Daniel Kasak wrote: Daevid Vincent wrote: If I have a table with a primary key like this: CREATE TABLE `answers` ( `qid` INT UNSIGNED NOT NULL , `userid` INT UNSIGNED NOT NULL , `groupid` INT UNSIGNED NOT NULL , `comments` TEXT NOT NULL , PRIMARY ( `qid` , `userid` , `groupi

Re: Question about combination PRIMARY keys and INDEX

Daevid Vincent wrote: >If I have a table with a primary key like this: > >CREATE TABLE `answers` ( >`qid` INT UNSIGNED NOT NULL , >`userid` INT UNSIGNED NOT NULL , >`groupid` INT UNSIGNED NOT NULL , >`comments` TEXT NOT NULL , > PRIMARY ( `qid` , `userid` , `groupid` ) >); > >But I will also be s

Question about combination PRIMARY keys and INDEX

If I have a table with a primary key like this: CREATE TABLE `answers` ( `qid` INT UNSIGNED NOT NULL , `userid` INT UNSIGNED NOT NULL , `groupid` INT UNSIGNED NOT NULL , `comments` TEXT NOT NULL , PRIMARY ( `qid` , `userid` , `groupid` ) ); But I will also be searching in various pages, for all

LongText Warning

I have a table with a field that has a field of type LONGTEXT. I try to insert a utf8 string with a length of 114544 and I get a warning that text got truncated. According to the doc, the size of LONGTEXT is much bigger than this. Any reason I get this warning? -Jalil -- MySQL General Mailing

Charsets and Escaping

What is the relationship b/w the charset we use and the connection escape function? I have a few tables that use utf8 as encoding and I want to make sure the escaping works fine as the string I pass to the escape() call are in utf8 already. I use python/apache/MySQLdb and tried specifying unicode="

Re: Collecting the primary key using MAX during an insert

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] writes: > Dan Rossi <[EMAIL PROTECTED]> wrote on 04/20/2005 12:55:45 AM: >> Hi there, I was wondering how its possible to get the MAX of a primary >> key of a table during an insert. I basically want to create a ticket >> number, but use the prim

Re: Unique items from all columns, very slow

On 4/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Willie Gnarlson <[EMAIL PROTECTED]> wrote on 04/20/2005 01:56:03 PM: > > On 4/20/05, Dan Nelson <[EMAIL PROTECTED]> wrote: > > > In the last episode (Apr 20), Willie Gnarlson said: > > > > I have been attempting to uncover a fast method

Re: find duplicates - revisted

Yes - thanks. I did not define the data with keys because it does not come out of the source that way. Keys and replace does it nicely. Probably my question defined me as a newbie, if not well... Thank you very much for you help. On Wed, 20 Apr 2005, Duncan Hill wrote: > On Wednesday 20 April 2

Build problem

I am in the process of building MySQL version 4.1.11 as an upgrade from 4.0.16. This build is so we will be ready for 5.0 once out of beta. We are using the source distribution and when executing the make step I get the following error. Making all in mysql-test /usr/bin/rm -f mysql-

Re: Unique items from all columns, very slow

Willie Gnarlson <[EMAIL PROTECTED]> wrote on 04/20/2005 01:56:03 PM: > On 4/20/05, Dan Nelson <[EMAIL PROTECTED]> wrote: > > In the last episode (Apr 20), Willie Gnarlson said: > > > I have been attempting to uncover a fast method for retrieving unique > > > items from every column in a table. T

Re: Unique items from all columns, very slow

On 4/20/05, Dan Nelson <[EMAIL PROTECTED]> wrote: > In the last episode (Apr 20), Willie Gnarlson said: > > I have been attempting to uncover a fast method for retrieving unique > > items from every column in a table. The table has approximately 60 > > thousand rows. Each row has an index associate

Re: Collecting the primary key using MAX during an insert

Michael Stassen wrote: (correcting myself) I'm guessing that the prefix ('FAULT' in this case) varies according to the kind of incident, so you want to include it in your table. The best way to do that is to use a separate column (perhaps an ENUM column with the possible values). For example,

Re: Collecting the primary key using MAX during an insert

Dan Rossi wrote: Hi there, I was wondering how its possible to get the MAX of a primary key of a table during an insert. I basically want to create a ticket number, but use the primary key as part of the ticket number ie FAULT-001 or FAULT-0002 . I tried during a sub query on an insert

Re: Query Problem

Dto. Sistemas de Unitel wrote: Hi Roger, That was just I need. The order isn’t like you say: ++-+---++---+-+- ++---+-+ | id | select_type | table | type | possible_k

links to MySql tools

What does it take to get something like http://dabodev.com listed on the MySql site? (This not a request to have it listed, just wondering on behalf of the dabo team.) http://solutions.mysql.com/program/faq.html#b2 B3. What is the entry level membership fee in the Partner Program? The entry lev

Re: Collecting the primary key using MAX during an insert

Dan Rossi <[EMAIL PROTECTED]> wrote on 04/20/2005 12:55:45 AM: > Hi there, I was wondering how its possible to get the MAX of a primary > key of a table during an insert. I basically want to create a ticket > number, but use the primary key as part of the ticket number ie > FAULT-001 or FAU

where is "MySQL Workbench"? (DBDesigner's successor)

Ok, so I have been loving DbDesigner, but bumpted into a few bug-a-boos. http://www.fabforce.net/forum says "We will continue to host the DBD4 download till the release of the MySQL Workbench, its successor application that will be an official MySQL product. Then this project will rest in peace."

Re: find duplicates - revisted

On Wednesday 20 April 2005 16:55, [EMAIL PROTECTED] typed: > For the small number of records, this query takes a remarkable amount of > time, so clearly this solution does not scale. A query that uses keys should not take a long time to run - unless your key data is not maintained as a key in the

find duplicates - revisted

I have read the MySQL Cookbook and the last 6 months (or so) of threads on this. I have a slightly different problem. I use a billing system implemented in filemaker. Happily they are going a rewrite in MySQL/PHP, but for the present I maintain a MySQL database so I can track things otherwise not a

re: mysql 5.0.4 for Solaris, as a tarball

Hi James, everybody! Am Mi, den 20.04.2005 schrieb James Black um 17:15: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Is there somewhere where I can d/l the latest beta as a tarball? Yes, there is - the usual download pages. The problem is that the HTML page does not yet show both the

Online documentation

Is the online documentation for 4.0.x available? I was working with dates a while back. As it happens 4.1 added the very function I wanted. But that was not marked as added in 4.1, nor should be be as that would be an unbelieable amount of cruft. I would be nice however if maybe one level back was

Re: Query Problem

Hi Roger, That was just I need. The order isn’t like you say: ++-+---++---+-+- ++---+-+ | id | select_type | table | type | possible_keys | key | key_len | ref

re: mysql 5.0.4 for Solaris, as a tarball

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is there somewhere where I can d/l the latest beta as a tarball? Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment:

Collecting the primary key using MAX during an insert

Hi there, I was wondering how its possible to get the MAX of a primary key of a table during an insert. I basically want to create a ticket number, but use the primary key as part of the ticket number ie FAULT-001 or FAULT-0002 . I tried during a sub query on an insert but obviouslly no

Summ of numbers in field

Is that possible to count summ of numbers in field? If field has value 12, 3 must be returned. (1 + 2 = 3) -- Проник в школу через задний проход. WBR, Дмитрий Лукашин -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.c

Cube and rollup operators

Hi, I'm a mysql user for a long time and i would like to knoe if exists any implementation of cube operator in mysql. I already used rollup operator . Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Regarding the loading of data usning load data infile

May be a clue, for the data records you load into the table, the value for numeric field such as DEPARTMENT_ID, LOCATION_ID should not be enclosed in quote. If it is the case, mysql has to make a translation from character to numeric. Marc. -Message d'origine- De : [EMAIL PROTECTED] [m

Re: Query problem

Dto. Sistemas de Unitel wrote: [...] something like /indexes.id=productos.prod_id and indexes.id_termino=terminos.id_termino and termino="computer" and termino=”intel”/ I know that is impossible, but maybe there is another way to make that). Yes, there is another way. You _can_ join the same tab

Re: modifying InnoDB storage

From: "Gleb Paharenko" Hi Gleb, Thanks for your response. > http://dev.mysql.com/doc/mysql/en/adding-and-removing.html If it currently reads: innodb_data_file_path = /ibdata/ibdata1:2000M;/ibdata/ibdata2:2000M;/ibdata/ibdata3:2000M;/ibdata/ib data4:10M:autoextend Can you change this into: =

Re: modifying InnoDB storage

Hello. See: http://dev.mysql.com/doc/mysql/en/adding-and-removing.html Think also about per-table tablespaces. See: http://dev.mysql.com/doc/mysql/en/multiple-tablespaces.html "Jigal van Hemert" <[EMAIL PROTECTED]> wrote: > Hi list, > > If you have the InnoDB tablespace f

Regarding the loading of data usning load data infile

Hi, I had 99,990 records to be loaded into a table which is having unique constraints and foreign-key constraints as below CREATE TABLE `teldir` ( `NAME` varchar(21) default '', `PHONE_NO` varchar(26) default '', `PRIME_VALUE` char(1) default '', `COMMENT_TEXT1` varchar(30) defaul

Re: Using libmySQL with C/C++

Vicente wrote: Hello, Yesterday I asked for some help to create a program in C++ integrated with MySQL. Now I have installed MySQL 4.1.11 and I suppose I will need to include mysql.h in my code. But this header use 'libmysql.dll', where I have to define the path in Visual C++? Or where I have to

modifying InnoDB storage

Hi list, If you have the InnoDB tablespace files defined as two files of 2GB and an autoextend file, is there any way to add extra tablespace files in this case? Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Query problem

Hi, I’m trying to make a query that need to search throught a table and have to search different terms, and SUM their Rank (is for a small search engine I have to design), this is the table: Table Indexes ID – bigint ID_Termino -bigint Rank – double Table Terminos ID_Termino – bigint