Warning

I;m using redhat linux 9.0 and MySQL 4.1.9 I found this lines on my log file 050411 11:31:50 [Warning] Asked for 196608 thread stack, but got 126976 050411 11:31:50 [Warning] Asked for 196608 thread stack, but got 126976 Is it bad ? -- MySQL General Mailing List For list archives: http://lists.mysq

foreign key design stratgies

Hey folks - I'm having a little problem understanding ON DELETE foreign key constraints. Here's my options from the manual: [ON DELETE {RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT}] When do I use each one? I can find anything in the online manual that suggests how to construct a data

Re: UDF Request "AGGLOM()"

Hi Dan, On Sat, 2005-04-09 at 02:59, Dan Bolser wrote: > Who can I prod about setting up a UDF repo at MySQL. I think 'they' should > do this ;) Yep it's an existing idea, a very good one, and it's on the todo. Putting such an infrastructure into place will take some time though. Would a special

Getting Started with MySQL

Help, please, for a beginner to mysql, but with a (long time ago) background in 'C'. 1. I can install and get running version 4.1.11-nt of mysql. I cannot ugrade this to version 5 - it simply will not install properly depite doing all the things it says in the documentation. I hope to use the f

Re: Recreating primary index on MyIsam table

Hi Peter, thanks a bunch, I new that it must have been something simple like this. I am just no programmer. ;-) Thanks a bunch !! Best regards Nils Valentin Tokyo / Japan On Sunday 10 April 2005 23:41, Peter Brawley wrote: > Nils, > > >So the task is to recreate the current primary key (c_

Re: retrieving a value from mysql and use it later

On Apr 10, 2005, at 11:30 AM, Eko Budiharto wrote: Hi, I would like to ask about how to retrieve a value from mysql and use it later. What I mean is like this This is really a perl question, not mysql. my is a scoping operator. Variables declared with my disappear when they go out of scope. my

retrieving a value from mysql and use it later

Hi, I would like to ask about how to retrieve a value from mysql and use it later. What I mean is like this my $ref = $sth->fetchall_arrayref(); foreach my $row (@$ref) { my ( $passengerIndex, $passengerName, $passengerEmailAddress, $passengerLoginPassword ) = @$row; my $new = $passengerIndex;

Find valid numeric values in a string field?

I have a column like this "my_col varchar(20) null". The values in the column can be text or numbers. How can I select only those rows where the value in this column is a valid number? I need something like IS_DECIMAL(), but I can't find that function. The following SQL fails to do the job (pro

Re: Recreating primary index on MyIsam table

Nils, >So the task is to recreate the current primary key (c_serial),so that the >current index would start with 1,2,3,4, SET @i=0; UPDATE c1 SET c_serial=(@i:[EMAIL PROTECTED]); PB - Nils Valentin wrote: Hi MySQL fans ;-), I was just asked recently with the task to recreate a tables index

Recreating primary index on MyIsam table

Hi MySQL fans ;-), I was just asked recently with the task to recreate a tables index "gracefully" on a MyIsam table. This is the table layout: CREATE TABLE `cl` (   `c_serial` int(11) NOT NULL auto_increment,   `cname` tinytext NOT NULL,   `cl_vals` text NOT NULL,   `utime` int(11) NOT NUL