Re: Problem with LAST_INSERT_ID();

Hi, On Sat, Apr 28, 2001 at 05:12:42PM +0200, Antonino Chirco wrote: > Mysql : 3.23.33 > server : NT 4.0 S.P.3 > Client : Win98 > > This is the table structure: > CREATE TABLE `ordinit` ( > `ID_Ordine` int(11) NOT NULL auto_increment, > `Cod_Cliente` int(11) default NULL, > > .. OMISSIS ..

Index use, Perl DBI

I have a situation where a query should be using an index, running the query from the mysql terminal using the explain ... command indicates it will use the index, but the actual execution speed tells me the index is not being used: Execution is very slow. I have tried dropping and recreatin

Re: mysql 'top' application

> How can I tell which user on the system is responsible for the lag? > Ideally there would be a command like 'top' that would show which > databases are being accessed most frequently, or taking the most time to > access. > > - >

mysql 'top' application

I purchase web space on www.phpwebhosting.com, which offers PHP and mySQL services in a shared server environment. Each user gets their own database, in which they can create their own tables. Today, someone is using a LOT of resources: mysqld is pegged at 96% CPU utilisation, and I'm getting 'r

Re: New filter

On Sat, Apr 07, 2001 at 10:42:09AM -0600, Sasha Pachev wrote: > I have now installed the new spam filter on this list. It is very > simple - instead of having bad words, we now have good words. You > must mention one of the following: sql, database, query in the body > of your message to get past

Re: What is most stable??

On Fri, Apr 27, 2001 at 04:08:20PM -0700, Patrick Calkins wrote: > How stable is InnoDB, BDB, MyISAM, etc?? I am developing a > production system using MySQL, and wanted to know that stability > status on these table types. I wanted to use transactions if I > could - is the transaction-enabled t

Re: Problems with MySQL++

Well, cool. If that works I'm happy. I was trying to go by the README and use automake. Thanks! It'd sure be nice if somebody fixed the docs, or at least put a note on the web site that said they're broken. That probably cost me at least a day of confusion. :-( >> Howdy, >> >> I posted th

RE: Problems with MOD

isn't this the expected behavior? (1008306000-988344000)/86400 = 231.04 select mod(231.04,7); 0 231.04 mod 7 is .04, rounded down to 0. 7*33=231 the mod function rounds the result - that's expected, right? Other than that I don't see what the problem is. braxton -Original Message- Fr

Re: Viewing data from the previous row

>Actually, there is a way to do this by taking advantage of variables. If >you read my previous post on the matter, you can use variables to get a >cumulative total. >- Original Message - >From: "Steve Ruby" <[EMAIL PROTECTED]> >To: "Roger Karnouk" <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECT

Re: An interesting SELECT problem

>I've been creating a site for someone using MySQL and PHP4. >Basically the table concerned is structured like this; > >id int(5) UNSIGNED Noauto_increment Primary >ship varchar(50) NoIndex >year varchar(15) NoIndex Sir, change the type of this column to Date, whic

RE: Problems with MySQL++

> Howdy, > > I posted this question over on the plusplus list, but so > far I've not received a response. This list seems more > active, so perhaps someone here can offer me a hand. > > I'm trying to get the 1.7.8 distribution of MySQL++ to > build as directed in the README -- using auto

Problems with MySQL++

Howdy, I posted this question over on the plusplus list, but so far I've not received a response. This list seems more active, so perhaps someone here can offer me a hand. I'm trying to get the 1.7.8 distribution of MySQL++ to build as directed in the README -- using automake. When I run a

rpm upgrade database

Am running mysql 3.23.22 with problem with linuxconf. Want to upgrade to 3.23.36 or 37, but get following error messages: for 3.23.36 says: mysql = 3.23.22 is needed by mysql-server-3.23.22-6 libmysqlclient.so.9 is needed by mysql-server-3.23.22-6 libmysqclient.so.9 is needed by php-mysql-4.0.1

Re: What is most stable??

Hi! Difficult to say if InnoDB is alpha or beta. You can look at the bugs and fixes diary at my website www.innobase.fi, and form your own opinion. I am committed to fix all bugs you report, and to this day a fix has been available for any bug within 10 days. I have got bug reports from about 2

myodbc uses bash'ism and should not have #!/bin/sh

>Description: The following output occures when using ASH as /bin/sh. Your script seems to rely on non-POSIX features from bash and therefore should be called with #!/bin/bash. This works. -=(~/debian/mysql/ODBC/myodbc2.50.37-2.50.37)$ ./configure creatin

Problem with LAST_INSERT_ID();

Mysql : 3.23.33 server : NT 4.0 S.P.3 Client : Win98 This is the table structure: CREATE TABLE `ordinit` ( `ID_Ordine` int(11) NOT NULL auto_increment, `Cod_Cliente` int(11) default NULL, .. OMISSIS .. PRIMARY KEY (`ID_Ordine`) ) TYPE=MyISAM the query 'select last_insert_id()' after an

An interesting SELECT problem

I've been creating a site for someone using MySQL and PHP4. Basically the table concerned is structured like this; id int(5) UNSIGNED Noauto_increment Primary ship varchar(50) NoIndex year varchar(15) NoIndex voyage varchar(50) Yes sex varchar(50)Yes

Re: Problems with MOD

Roger Ramirez writes: > Why do I get the following results? > > mysql> select (1008306000-988344000)/86400/7, > mod((1008306000-988344000)/86400,7.); > ++-- > + > | (1008306000-988344000)/86400/7 | mod((1008306000-9883440

Re: AIX recommendations

Darren Henderson writes: > > This note is primarily meant to stuff something into the archives in case > other people have problems compiling mysql under AIX. > > There are a number of changes that need to be made that aren't detailed in > the documentation, (some alteration to those docs could

Re: Failed to compile.

Eric K. Dickinson writes: > All seemed to be going well untill... > > > sr/local/include/mysql -c get_table.cc > g++ -O3 -g -pipe -fforce-mem -fforce-addr -I. > -I../mysql++-1.7.8/sqlplusint -I/usr/local/include/mysql -c admin.cc > g++ -O3 -g -pipe -fforce-mem -fforce-addr -I. > -I../mysql

Re: select query syntax

supposed you numbered all rows in the table incrementally in field nid: select mydata from mytable where mod(nid, N)=offset; fill in N and offset (0..n-1) On Sat, 28 Apr 2001 14:26:46 +0400 Igor V Yermakov <[EMAIL PROTECTED]> wrote: > i have 400 rows in my mysql database table > and i wont ge

select query syntax

i have 400 rows in my mysql database table and i wont get each N row from table (say each sixth row)??? please help me??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.c

ZipSlack 486 installation problems

Hi, I am trying to set up Mysql on the following system (its only a test bed for home useage, for a small scale internet based project) Ideally, this system will be a MySQL, Apache, PHP setup. Low powered I know, but I am assured possible and OK for my purposes Proc: 486 DX2 66 Mem: 40MB HD:

Re: MySQL (3.23) connection bombardment question ..

just realised it: another thing might be the linux threading problems. when spawning multiple threads at once, the 2.2 kernel will delay the new threads more and more. Upgrading to kernel 2.4 solves this. read the lists' archives on this, there were several discussions on this subject. regards,

Re: MySQL (3.23) connection bombardment question ..

i'm just wondering: what hangs first: your scripts or the mysql database? if (one of your) scripts is in a endless loop, for one reason or the other, the symptons will be the same... I would try to figure out if there's one particulair query that hangs, or if it happens randomly. For cgi i wo