At 21:21 -0700 9/21/02, Des Dougan wrote:
>I want to extract data into a temporary table such that unique
>records with the same primary key (in this case an invoice number)
>are written to one record, with each of the unique fields extracted
>being written to a separate field in the temporary
Thanks to Jeremy Zawodny for his great tool, I was
able to capture this during a server meltdown at the
hands of an upraded MySQL binary (From 3.23.32 to
3.23.52).
My story is a famliar one -- a db (MyISAM tables) that
ran fine for 3 years all of sudden brings our cpu to a
halt with an upgraded
I want to extract data into a temporary table such that unique records with
the same primary key (in this case an invoice number) are written to one
record, with each of the unique fields extracted being written to a
separate field in the temporary table record. I have created my temporary
tab
Hi all. I'm new to MySQL, so please forgive me if this issue is
already well-known.
I'm running MySQL server 3.23.28-gamma-debug on WinME. Yes, I know,
that version is almost 2 years old (and the OS is lousy, don't bother
to tell me). It came on a CD that came with a book, so I installed it
f
Hello,
I am running a rather simple query on a merge table that seems to be taking
much longer than it should.
First let me show the table status of the tables I have merged into table
'blah':
NameTypeRow_format RowsAvg_row_length Data_length
Max_data_length Index_length
I've seen this kind of question asked, but have not found any useful
answers. So, at the risk of being redundant and repeating what has
already been covered:
I want to join the groupings of table columns. The tables are
potentially different lengths. A toy example (I figure
bankers/accountant
At 20:17 -0400 9/21/02, alg wrote:
> >Description:
>
> I'm trying to install MySQL MAX 3.23.52 (MySQL, with
> transactions enabled). My rpm attempts goes like this...
>
> 1. Check for installed MySQL...
>[root@Zeke mysql]# rpm -q -a | fgrep -i mysql
>[root@Zeke mysql]#
>
>
>Description:
File: support-files/mysqld.server
This file has problems when run under RH Linux 7.0, and
I suppose in other Linux versions.
>How-To-Repeat:
1. Download: mysql-max-3.23.52-pc-linux-gnu-i686.tar.gz
2. Install as per instructions in INSTALL-
>Description:
I'm trying to install MySQL MAX 3.23.52 (MySQL, with
transactions enabled). My rpm attempts goes like this...
1. Check for installed MySQL...
[root@Zeke mysql]# rpm -q -a | fgrep -i mysql
[root@Zeke mysql]#
2. Nothing, so I attempt an install...
[r
On Sun, Sep 22, 2002 at 01:36:49AM +0300, cristian ditoiu wrote:
> I saw the using show status smth like Threads_cached .
> I searched the mysql site with no luck , finding just a simple explanation
> like : Number of threads in the thread cache.
> That wasn't very .. explainng , so searching furt
Hello Mysql .
I saw the using show status smth like Threads_cached .
I searched the mysql site with no luck , finding just a simple explanation
like : Number of threads in the thread cache.
That wasn't very .. explainng , so searching further i found how to enable
the thread cache , using
set-vari
Adrian,
- Original Message -
From: ""Adrian Liang"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, September 21, 2002 6:48 AM
Subject: Interesting innodb activity with 3.23.52
>
> Hi,
>
> We experienced some interesting things when we upgraded to Mysql-Max
> 3.23
Hi all:
I'm seeing a strange problem updating a field if
that field is referenced as a FK in another table.
Consider:
CREATE TABLE A (
id INTEGER NOT NULL AUTO_INCREMENT,
name VARCHAR(20),
PRIMARY KEY (id)
);
CREATE TABLE B (
id INTEGER N
Dear Sir,
I've found a bug in the function "mysql_real_escape_string". For
example, i use this function like below:
mysql_real_escape_string(auth_sql_server, escapeUser, user,
strlen(user));
now user = "cHm%Ilu!", but escapeUser equals to
"Chm134739000!"(random), instead of "cHm
On Sat, Sep 21, 2002 at 02:06:01AM -0500, Kevin wrote:
> Hello, I was wondering if anyone knows PERL & DBI, if so please respond to
>[EMAIL PROTECTED] personally, or to the list
>
>
> My question is, I'm trying to build a 'custom' querier for a survey program... based
>on the information s
Hello MySQL,
I send one message earlier questioning whether SQL really was not a
standard anymore. According to the documents I could find on the
issue, SQL is not truly a standard anymore, but may become one
again. Reference: http://www.tdan.com/i016hy01.htm and
http://www.zdnet.com.a
I unzipped and installed MySQL 3.23.52 from
free-download on my PC running WindowsMe. First time
it worked by running 'mysqld' and 'mysqlc' and I made
a table and loaded data into it. Then I deleted all
rows from 'mysql.user' table where 'host=localhost' in
my attempt to make it secure, however, I
Could you pls suggest me why this query is not working. I have to
delete all duplicate records from me table. here sno is auto increment
and domain is table field.
1.DELETE FROM tbl_raw_whois_lookup WHERE domain = '007X.COM' ORDER BY
sno LIMIT 1;
coulsd you pls send my a sql query for deletin
>Description:
While trying to login to the MySQL database (as root), I failed for no
apparent reason.
I believe this migth be because my password includes the ¤ (Euro / European
currency) char.
It works _perfectly_ if I remove that one char or replace it with another.
Hi all,
I have a table with three columns:
Destination varchar(254)
SentDatetimestamp(14)
UserID varchar(32)
I want to be able to get a list of the 100 most recently used numbers, based
on the timestamp (SentDate) column.
I want to have them ordered such th
Hi Michael,
This is kind of vague request:) MySQL will just store data, the
efficiency of searching is mostly depend on how good the database design
is, and how good your search program is.
However, MySQL offers a unique feature called "fulltext searching
capability" which will make your life so
hans,
Friday, September 20, 2002, 8:00:08 PM, you wrote:
hs> have done a succesful update 3.23.36 to 2.23.47 on my mandrake-box 8.2,
hs> but have now that question :
hs> as user root it is possible to login now with "mysql -p" the
hs> password-question appears, typing in the root-password is okay
Danny,
Wednesday, September 18, 2002, 6:26:37 PM, you wrote:
DH> -BEGIN PGP SIGNED MESSAGE-
DH> Hash: SHA1
DH> Victoria Reznichenko wrote:
DH> | As far as I remember there was found and fixed the similar bug in
DH> | 4.0.3. Could you provide output of SHOW CREATE TABLE for testing?
Hi!
i`ve tried to solve this problem, and i think i did it!
First of all:
I've tried with:
Tomcat 4.0.4
Mysql 3.23.49
You should have in your application's lib these libraries:
- commons-collections.jar
- commons-dbcp.jar
- commons-pool.jar
(You can find these jar in www.apache.org)
- mysql-uncomp
Okay, I've thought about this every way I can conceive of, but I
cannot figure out the sql query logic involved in joining three
tables together. Here is what I am trying to do:
I have three tables:
keywords
keywordlink
projects
keywords has these fields:
id
keyword
keywordlink has th
I have written a web application using Perl, DBI and MYSQL 3.23.41. I
have built the application so that only the interface logic is in the
perl cgi scripts (not fastcgi) and all of the real work is done is in
perl modules, one of which I call Mydefaults.pm which holds the db
connect informat
ok guyz
im lost
im creating my tables and after i ve created em i tried to change two of the
fields to FULLTEXT and this is what i get :
Database zabanDb running on localhost
Error
SQL-query :
ALTER TABLE `ctnt_inf` ADD FULLTEXT(`summary`)
MySQL said:
Error on rename of '.\zabandb\c
ok guyz
im lost
im creating my tables and after i ve created em i tried to change two of the
fields to FULLTEXT and this is what i get :
Database zabanDb running on localhost
Error
SQL-query :
ALTER TABLE `ctnt_inf` ADD FULLTEXT(`summary`)
MySQL said:
Error on rename of '.\zabandb\c
28 matches
Mail list logo
