configure.in

Dear MySQL Devloperes. When compile mysql-3.23.31 with db-3.2.3h, BerkeleyDB cannot detect in configure There are two plan patches for compile MySQL with db-3.2.3h I think this is better than current configuren. plan A: +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+= umine

MyODBC installation

I have downloaded the win95 version for MyODBC and when i tried instaling using setup.exe it says cannot copy MFC30.DLL which is already present in the system directory. can you help me please. I have a 3.23.25 beta version of server. regards

Re: SECURITY issue in remote tcp/ip connecting?

> > Any measures I could take (like SSH) to encrypt the transaction? >Use CIPE tunnel. You can find it: >http://sites.inka.de/sites/bigred/devel/cipe.html Is this anything like ipsec? http://www.openbsd.org/faq/faq13.html (I'm using OpenBSD.) Or, rather, could I use ipsec for this same thing a

Fatal bug in 3.23.31

We have just discovered a fatal bug in 3.23.31 that will cause mysqld to segfault if the client closes connection without a call to mysql_close() -- very common situation with many clients, including earlier versions of PHP 4. The bug is very serious. We recommend that you either apply the patc

OT: Alpha XL300 Server Buying Advice?

Greets All: Sorry about the off-topic, but, not finding much useful out there w/ respect to a buying decision. e-Mail me off-list, please. Have an opportunity to pick up this unit very cheap with 18GBytes of scsi storage, 192 MBytes RAM, on a 300MHz Alpha XL300 Processor. Looking at setting it

Re: What degree of concurrency does MySQL support?

>On Fri, Jan 19, 2001 at 06:58:34AM -0500, Bob Hall wrote: > > > > MySQL has only table level locking, which means that each update > > will lock the entire table, which means that updates must be done > > one at a time. There are a couple of open source extensions of MySQL > > that are suppo

Re: Setting Up Users!

Muhanad Mustafa wrote: > > Ok, i'm very new to Mysql. . The documentation is a little confusing for me to >figure out so I thought this might help. I had created a database on my system >called "customer15" > > I did this > > mysql>create database customer15 > > Now I want to setup a mysql

Re: MySQL and Oracle

Jason Radley wrote: > > I am currently using php and mysql and I was wondering if you can take the > data from a mysql database and move it to a oracle database? > Thank you, mysqldump exports data from MySQL database and them Oracle should be able to import it. -- MySQL Development Team __

Re: SECURITY issue in remote tcp/ip connecting?

Derek Sivers wrote: > searched the lists & books & found no mention of this: > > Are there any security issues in doing lots of remote-connecting (TCP/IP) > to my MySQL database server? Anything can be broken with this. MySQL limits this by amount of max_connections but if someone else occupi

Re: Setting Up Users!

MySQL has nothing to do with /etc/passwd You need to look at the mysql by typing in mysql -u root -p mysql Then you type in DESCRIBE mysql You should see somehting like the user table. All you have to do is use INSERT INTO sql statements or even look up the mysql manual for the usage of GR

Re: A report generator MySQL

-Hello - You can try the following methods:- Use php to code the report. This is easy once you have experience with php but there are many free php code out there such as phpwizards.net which can assist you. Cystal Report by Seagate is also a very good report generator. I am sure Cystral Repo

RE: A report generator MySQL

What output media do you want? Paper or web? Some text formating tools I have found are: http://www.geocities.com/SiliconValley/Ridge/4280/GenericReportWriter/grwhom e.html http://mytextreport.sourceforge.net/en/manual.html Or, if you want to output to HTML, you could use the PHP programing lang

Re: examples of large mysql databases

On Fri, Jan 19, 2001 at 08:12:49PM -0600, Brett Paden wrote: > I am curious as to other people's experiences with larger amounts of > data, like 5 to 50 million record tables (I am assuming each record > has dozens of columns of various datatypes). ~35 million records in one table without any tr

Re: replication of tables with 10 million rows?

On Sat, Jan 20, 2001 at 03:58:44AM +0100, Jan Kirchhoff wrote: > > i just wondered if someone has a replication running with that > number of rows or even more in one table? One of the tables in our replication setup has ~35 million rows in it. The rows are similar in nature to yours. We've not

replication of tables with 10 million rows?

one of my tables has ~10 million rows (but just 4 columns: int,double,double,date (date,int as primary key)) and when i started a replication on that database it crashed within 48 hours without any messages in the error-log. the mysql-server stays, up, just the replication dies. i don't have

A report generator MySQL

I am writing a database to store student academic records at my local high school. I wish to generate attractively published reports home to parents. Does anybody know of a method or product that will produce elegantly formatted reports from MySQL? -

Re: Connection Refused

AMEN. On Fri, Jan 19, 2001 at 06:44:22PM -0700, Colin Faber wrote: > !!! localhost.localdomain is not a TLD!! Don't break the RFC with this redhat crap. > > > [EMAIL PROTECTED] wrote: > > > The line is > > 127.0.0.1 localhost.localdomain localhost > > > > > Do you hae the line > > > > > > 127

examples of large mysql databases

I have been using mysql for many years and have failry reliable web-based applications using tables with 3 million+ records. I am curious as to other people's experiences with larger amounts of data, like 5 to 50 million record tables (I am assuming each record has dozens of columns of various da

Re: Connection Refused

!!! localhost.localdomain is not a TLD!! Don't break the RFC with this redhat crap. [EMAIL PROTECTED] wrote: > The line is > 127.0.0.1 localhost.localdomain localhost > > > Do you hae the line > > > > 127.0.0.1 localhost.mydomain localhost > > > > in your /etc/hosts file? > > It sounds like

copying a table

I too am having trouble with the simple task of copying a table. I am using 3.22.23b. I wanted to use the create with insert but was told this isn't supported by 3.22. So i have created the new table and figured I would use an insert. i can't get this to work either. insert into NewTable (field

Insert-Select problem

I am performing a query in two tables and output it into a temporary table for further sorting. The problem is that in one of the tables (TableB), I have an additional id that I want to be added to the temptable. This id is not present in TableA. I get this error message when I run the query for T

MySQL for Cobalt RaQ3 + INSTALLATION INSTRUCTIONS

At 11:39 AM 1/19/01 , you wrote: >Need some help. I need the RPM files for the Cobalt Rack 3. Any ideas. Don't use RPM. The RPMs for the Cobalt RaQ3 suck. I have 8 different Cobalt RaQ3's and here's the way I've used to install: I've installed it this way successfully each time. Sounds like a bi

SECURITY issue in remote tcp/ip connecting?

searched the lists & books & found no mention of this: Are there any security issues in doing lots of remote-connecting (TCP/IP) to my MySQL database server? (My Apache/PHP is on a different webserver from the MySQL server. And sometimes across the country.) Won't that password be somehow sn

Setting Up Users!

Ok, i'm very new to Mysql. . The documentation is a little confusing for me to figure out so I thought this might help. I had created a database on my system called "customer15" I did this mysql>create database customer15 Now I want to setup a mysql username and password so this customer has

Re: Database access Logging

Hi, I only want to log commands that server processed and which users ran those commands bye! - Original Message - From: Jeremy D. Zawodny <[EMAIL PROTECTED]> To: Arslan Saeed <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, January 20, 2001 3:24 AM Subject: Re: Database acce

MySQL and Oracle

I am currently using php and mysql and I was wondering if you can take the data from a mysql database and move it to a oracle database? Thank you, Jason - Before posting, please check: http://www.mysql.com/manual.php (the m

Re: What degree of concurrency does MySQL support?

On Fri, Jan 19, 2001 at 06:58:34AM -0500, Bob Hall wrote: > > MySQL has only table level locking, which means that each update > will lock the entire table, which means that updates must be done > one at a time. There are a couple of open source extensions of MySQL > that are supposed to offer ro

MySQL is safe (enough?)

Dear all, I know that many MySQL developers are subscribers of this list and I decided to ask this question with all the possible respect that the developers and MySQL itself deserves. I think it's the most appropriate list to do this and the place where I will receive the most precise answers. I

Re: Database access Logging

On Sat, Jan 20, 2001 at 12:34:28AM +0500, Arslan Saeed wrote: > Hi, > > I want my mysql to track user login information and commands they > run at mysql client? Any one can help me to do this please? Even if those commands are never sent to the server? Or do you only want to log queries that the

Re: encode() question

Oops My mistake. I was not using the "salt" option. Now I can get the same result each time that I encrypt the same string. Thanks again, Lonnie --- "Gerald L. Clark" <[EMAIL PROTECTED]> wrote: > Lonnie Cumberland wrote: > > > > Hello All, > > > > I have noticed that the Encrypt() is a

Re: mysql++: How to save a row[i] as a char*

Hi, I don't really understand what you mean row[i] is the same as char *. This is a line of code i'm currently using to insert a row[i] into a QListBox Tables_List_Box->insertItem( QString::fromLatin1( row[0] ), cnt ); Regards Jorge MySQL Development Team __ ___ __ __

Re: Replication

On Fri, Jan 19, 2001 at 05:16:16PM -0500, Paul Mattheis wrote: > I never like doing the simple things, it's the complex things that > are more fun... > > I would like to be able to create my own backend for the replication > slave server. Meaning, I would like to recieve the replication log > d

Replication

I never like doing the simple things, it's the complex things that are more fun... I would like to be able to create my own backend for the replication slave server. Meaning, I would like to recieve the replication log data from the master (getting all the benefits) and then do something comple

Re: inserts with now() resulting in replication-problems

> "JK" == Jan Kirchhoff <[EMAIL PROTECTED]> writes: JK> If the Slave gets out of sync (loses the connection to the server), connects JK> again and tries to catch up, it processes those two queries *within one JK> second* which would result in an duplicate primary key on the slave. The JK>

Re: ANNOUNCE: myrepl - automate inital mysql replication setup on master server without down-time

> > * It'd be handy to create a compressed tar file (.tar.gz). I'll > probably add that. great ;) but i'll transfer it compressed with scp, so it's no big problem for me. But a "-z"-switch would probably be useful for lots of people. > * It'd be nice to specify which databases/tab

mysql++: How to save a row[i] as a char*

How can I get a row[i] in a char* or a qstring variable? thank for helping! juergen leeb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: Replicating MySQL

On Fri, Jan 19, 2001 at 11:54:34AM -0700, Karl J. Stubsjoen wrote: > How could we replicate our MySQL DB from one server to another? Yes. And it's documented in the fine manual: http://www.mysql.com/doc/R/e/Replication.html > As a back up measure, incase our pages fail to connect to ServerA,

Re: Weird update where something != otherthing

Diogo Zulli wrote: > > Maybe this the correct behavior, but I am confused about > the statments below: > > CREATE TABLE testing ( fmsg CHAR(1) DEFAULT 'N' ); > INSERT INTO testing VALUES (NULL); > INSERT INTO testing VALUES ('Y'); > INSERT INTO testing VALUES ('X'); > INSERT INTO testing VALUE

Re: temp tables lock unrelated tables

Michael Griffith wrote: > > Earlier I posted a message about SHOW PROCESSLIST reporting queries "locked" >whenever another thread is "Copying to tmp table" > > After many more hours of diagnosis, the actual problem is somewhat different: > > MySQL does report other processes as locked. But the

Re: encode() question

Lonnie Cumberland wrote: > > Hello All, > > I have noticed that the Encrypt() is a oneway function that will also give > different resulting messages for the same message being encrypted multiple > times. > > I have also noticed that the Encode() will result in a message that is a binary > type

inserts with now() resulting in replication-problems

My Replication-Slave crashed a few days ago with an error in the error-log saying something like "duplicate primary key processing query "INSERT INTO testtable (time,name,number) VALUES (NOW(),'Hello',10)" testtable's primary key was (time,name) time: datetime name: varchar number: int What I

Weird update where something != otherthing

Maybe this the correct behavior, but I am confused about the statments below: CREATE TABLE testing ( fmsg CHAR(1) DEFAULT 'N' ); INSERT INTO testing VALUES (NULL); INSERT INTO testing VALUES ('Y'); INSERT INTO testing VALUES ('X'); INSERT INTO testing VALUES ('Y'); INSERT INTO testing VALUES (

temp tables lock unrelated tables

Earlier I posted a message about SHOW PROCESSLIST reporting queries "locked" whenever another thread is "Copying to tmp table" After many more hours of diagnosis, the actual problem is somewhat different: MySQL does report other processes as locked. But they do not wait until the temp table is

Re: isamchk error

"Gerald L. Clark" wrote: > > Stuart Fox wrote: > > > > Hi > > > > Can anybody tell me what this error means > > > > user@server#isamckh -av {database}/*.ISM > > > > isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all > > tables) > > > If this was part of a script, then database wa

encode() question

Hello All, I have noticed that the Encrypt() is a oneway function that will also give different resulting messages for the same message being encrypted multiple times. I have also noticed that the Encode() will result in a message that is a binary type. What I need to do is to find a way to cha

Re: How do I use index files?

> Don wrote: > > > > > > Prior to updating, I want to search the table to see if my Key exists. > > > > That way, I can add it or just update the associated fields. How do I > > > > tell my script which Index file to use? I can't seem to find the > > > > equivalent of the dBase style "Set Order

4Gb tables problem

I have MySQL Server "Ver 3.23.27-beta for Win95/Win98 on i32" installed on Windows 2K machine and NTFS filesystem. As soon as one of my tables reaches 4Gb size every attempt to insert new records into it leads to 'ERROR 1114: The table 'table_name' is full'. >From MySQL manual I know that "MyISA

Re: How do I use index files?

Don wrote: > > > > Prior to updating, I want to search the table to see if my Key exists. > > > That way, I can add it or just update the associated fields. How do I > > > tell my script which Index file to use? I can't seem to find the > > > equivalent of the dBase style "Set Order to". > > >

Re: forcing tcp/ip connect when connecting to localhost

Pete, thanks for your exhaustive answer. I didn't try using '127.0.0.1' instead of 'localhost', as I though that anything that points to the lo interface would be using a socket. luckily, speed is no concern to me, as this connection is only used to make php development while being able to conne

Re: Connection Refused

The line is 127.0.0.1 localhost.localdomain localhost > Do you hae the line > > 127.0.0.1 localhost.mydomain localhost > > in your /etc/hosts file? > It sounds like your resolver is not working. > > [EMAIL PROTECTED] wrote: > > > > Doing that was just a test, and I didn't think it would w

Database access Logging

Hi, I want my mysql to track user login information and commands they run at mysql client? Any one can help me to do this please? bye! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Simple DoS scenario against mysql slaves

Fix confirmed. Thanks for the fast response! On 19-Jan-2001 Sasha Pachev wrote: > On Friday 19 January 2001 11:16, Andreas Steinmetz wrote: >>Referring to my post "instant slave crash (signal 11) on 'set password'" to >>[EMAIL PROTECTED]: >> >>The scenario is still valid for 3.23.31. This means t

3.22.23 table problem

I'm not sure exactly what happened, but mysql was freezing everytime I tried to access a particular table...everytime I tried to select anything from it, alter it, drop it, whateverjust nothing worked and mysql crashed. I ended up having to temporarily remove the table files, kill mysql and re

RE: installing and configuring Mysql on red hat linux 6.2

To install will you be using a tarball or RPM? -Original Message- From: Stephen Lambert,CSI [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 11:18 AM To: [EMAIL PROTECTED] Subject: installing and configuring Mysql on red hat linux 6.2 Hi, I would like to know where i can find i

Could anyone help me with locked table?

My set-up: MySQL server 3.23.30 with MSAccess97 via MyODBC 2.50.36 (all latest patches to everything) I have no trouble running this set up, BUT... Even when I am the only person connected (after flush and restart of server) and I open my Access database and go directly to edit one particular t

Re: forcing tcp/ip connect when connecting to localhost

>> can I force the mysql clients to use a tcp/ip connect if connecting to >> 'localhost'? > Normally connecting to the true DNS hostname or the ip address of > the machine will do the trick. Connecting to localhost will connect > via the loopback address of 127.0.0.1. If you connect to the true

Re: Connection Refused

Do you hae the line 127.0.0.1 localhost.mydomain localhost in your /etc/hosts file? It sounds like your resolver is not working. [EMAIL PROTECTED] wrote: > > Doing that was just a test, and I didn't think it would work since Inetd is > not running on the box at all. In fact the only way

Need MYSQL for COBALT Rack3

Need some help. I need the RPM files for the Cobalt Rack 3. Any ideas. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

Re: How do I use index files?

> > Prior to updating, I want to search the table to see if my Key exists. > > That way, I can add it or just update the associated fields. How do I > > tell my script which Index file to use? I can't seem to find the > > equivalent of the dBase style "Set Order to". > > Errr... If I understand

RE: Replicating MySQL

"Mirror" is the word you're looking for. -Original Message- From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 11:55 AM To: MySql list Subject: Replicating MySQL Hello, How could we replicate our MySQL DB from one server to another? As a back up measure,

RE: TRUNCATE causes corrupted tables

Hi! No, I can't repeat it on command, sorry. However, I can give a little more info. When inserting, the index file got bigger. It was the data file that was set to 0 bytes, but did not get bigger on inserts. Doing a repair fixed it. I have some tables truncated via scripts, so I turned on mysq

RE: The function of auto_increment and Premier Key? - Thanks!

Thanks you for your good explain of this all - now I have a good idea of how it works. Ps. I meant that I'm familiar to simple databases like MS Access etc. but not of course MySQL witch I think is great! :) Sumarlidi -Original Message- From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED

Re: Simple DoS scenario against mysql slaves

On Friday 19 January 2001 11:16, Andreas Steinmetz wrote: >Referring to my post "instant slave crash (signal 11) on 'set password'" to >[EMAIL PROTECTED]: > >The scenario is still valid for 3.23.31. This means that any valid mysql user >can cause the replicating slaves to crash using the 'set pass

Replicating MySQL

Hello, How could we replicate our MySQL DB from one server to another? As a back up measure, incase our pages fail to connect to ServerA, it'll then try to connect to ServerB? Thanks! Karl ...and what is the word I am looking for, it isn't replicate but something else? -

installing and configuring Mysql on red hat linux 6.2

Hi, I would like to know where i can find information how to: Install and configure My sql on red hat linux 6.2 Create,manage and backup database, several client. Where can i find professional and not expensive support to learn how to manage my sql. Thank.. Stephen T.

RE: [PHP-DB] Date function.

mysql> select name from tableName -> where month(birthDate) = 7; -Original Message- From: Sharif Islam [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 8:56 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Date function. This is a simple mysql question i am having problme with.

Re: bug in 3.23.22-beta

> "MS" == Marc Swanson <[EMAIL PROTECTED]> writes: MS> As you can see the date field has been updated to the current date/time even MS> though the update query was only supposed to modify the text field. For MS> claarity the date field started out with 2001-01-07 08:00:00 and ended up MS> wi

Re: MySQL 3.22.32 shutting down

What OS and version? Is it patched to current patch levels? - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Michael L. Smeby, Jr." <[EMAIL PROTECTED]> To: "Mysql Mailing List" <[EMAIL PROTECTED]>

RE: The function of auto_increment and Premier Key?

> Hi I'm relatively new to MySQL though I familiar to other simple > databases. Ahem... [takes Sumarlidi aside and explains very carefully how the MySQL developers feel about hearing MySQL being called a "simple database" ;-) ] > I have been reading the manual but not doing well understanding

Connection Freeze (new feature proposal)

Hi! I've been thinking here about databases and their use in WEB developemnt and have come to a conclusion that transactions are very often useless in real web applications, because creating one logical object in database (sorry for OO notatitions, but I often use RDBMSes for mapping object orien

RE: How do I use index files?

> Hi, > > I have installedMySQL 3.23.31 Good. > I have read many docs. Even better! > ... [cut] > Prior to updating, I want to search the table to see if my Key exists. > That way, I can add it or just update the associated fields. How do I > tell my script which Index file to use? I can't

MySQL 3.22.32 shutting down

We use MySQL 3.22.32 on a high-volume web server with Apache 1.3.14/PHP 4.0.3pl1 on a Compaq RS6000. Randomly, MySQL shuts down mysteriously with no reason in any of the log files. The .err log shows: mysqld ended on Fri Jan 19 09:50:49 EST 2001 mysqld started on Fri Jan 19 10:04:12 EST 2001

Simple DoS scenario against mysql slaves

Referring to my post "instant slave crash (signal 11) on 'set password'" to [EMAIL PROTECTED]: The scenario is still valid for 3.23.31. This means that any valid mysql user can cause the replicating slaves to crash using the 'set password' command. So any valid user can even unintendedly cause a

The function of auto_increment and Premier Key?

Hi I'm relatively new to MySQL though I familiar to other simple databases. I have been reading the manual but not doing well understanding the function of auto_increment and Premier Key. Lets say I have a table with a few columns. One of them is an ID with auto_increment. It has 1000 rows. If I

Re: Connection Refused

Doing that was just a test, and I didn't think it would work since Inetd is not running on the box at all. In fact the only way to get to these boxen (aside from walking over) is via SSH. I find it interesting that on the box that I want to actually do the logging to I can telnet to port 3306 if

How do I use index files?

Hi, I have installedMySQL 3.23.31 I have read many docs. I have successfully crated a database with tables and index files. Several of my tables have two index files. One is the PRIMARY field that I specified. The other is a seperate index I created on other fields, using the "alter table and

Re: temp tables lock unrelated tables

My TMPDIR is actually not separate from the data. There is plently of disk space. In fact, thinking it was some sort of RAM problem I reduced the size of the database by almost 30% with no change in performace. You say this should not happen, yet as I've been searching the mailing list there's at

Re: Feature Request:

Hi, > I am BEGGING you to please make the describe command OPTIONALLY display the > Privileges column. Before 3.23, I was able to see the describes properly. Now > the command is almost totally useless to me! I agree! On any table you care to describe the output is usually always wider than even

Re: temp tables lock unrelated tables

Michael Griffith writes: > Using SHOW PROCESSLIST or mysqladmin proc > > Every time a table reports status of 'copying to tmp table' all other UPDATE queries >are locked, even in unrelated tables. > > For example: > > Query #1: SELECT * FROM a JOIN B WHERE Status: copying to tmp

Re: 3.23.31 gives FULLTEXT problems on sparc64 Linux

Hi! On Jan 19, Tibor Simko wrote: > Hello > > After upgrading to 3.23.31, FULLTEXT selects give often "error -1 from > table handler" for me. The error log says "ft_read_first: Got error > -1 when reading table foo". I think I have not seen those for older > 3.23.x versions (x=28 or so), at le

how to count rows in JDBC ResultSet ?

Hello, I want to know the number of rows in a JDBC-ResulSet just by calling a function like it's done in PHP with mysql_num_rows($result) There seems to be no such function in the ResultSet interface as defined in Java 2. cheers Oliver Doepner -

MySQL Ver 11.11 Distrib 3.23.31 & JDBC

Hello, I am having an error while trying to connect through JDBC to mysql using the "mm.mysql-2.0.2-bin.jar" driver. The error occurs whether I run my Java program locally or remotely. SQLException: Server configuration denies access to data source SQLState: 08001 VendorError: 0 j

Re: HELP with SQL statement

I think that this will do SELECT -(Sum(Rating-2)) AS Total FROM Rating GROUP BY 1; - Original Message - From: "Mike Podlesny" <[EMAIL PROTECTED]> To: "Tomi Junnila" <[EMAIL PROTECTED]>; "mySQL Mailing List" <[EMAIL PROTECTED]> Sent: Friday, January 19, 2001 4:50 PM Subject: HELP with SQ

Re: HELP with SQL statement

* Mike Podlesny <[EMAIL PROTECTED]> wrote on 19.01.01 17:52: > Actually let me reword this because Tomi's answer won't quite work. The > table has a field called Rating. A number 1 is stored to represent positive > a 2 is stored for neutral and a 3 is stored for negative. I need to query > that

temp tables lock unrelated tables

Using SHOW PROCESSLIST or mysqladmin proc Every time a table reports status of 'copying to tmp table' all other UPDATE queries are locked, even in unrelated tables. For example: Query #1: SELECT * FROM a JOIN B WHERE Status: copying to tmp table Query #2: UPDATE C SET x=x+1 WHERE..

RE: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

Ivanisevic, Irena writes: > Hi ! > > I am trying to implement BDB tables on windows NT. > I have installed mysql 3.23.31 and have downloaded Berkeley db file 3.2.3. > I am new to mysql. I have tried to look for instructions but I have no luck. > > Thanks > Irena > Hi! Support for B

Feature Request:

I am BEGGING you to please make the describe command OPTIONALLY display the Privileges column. Before 3.23, I was able to see the describes properly. Now the command is almost totally useless to me! Aaron - Before posting, pl

Is there any probleme with datatype DATE ??

I have just install the source distrib. 3.23.30g of MySQL. I have this (while I am testing ) : mysql> CREATE TABLE t1 ( datum DATE ); Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1-1" ); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t1 VALUES ( "2000-1

Re: Front End Needed

Hello, > I need to find a web front end that I can use to update a table in MySQL. > What I'm looking for is a program that will display an entire table with > records as a web page for editing. Something like a submit button at the > bottom to send in the updates to the server. Does something

Re: Please remove me

You have to remove yourself Jenny Lie wrote: > Hi, Please remove my name from the list. Thanks! > > Jenny Lie > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mys

HELP with SQL statement

Actually let me reword this because Tomi's answer won't quite work. The table has a field called Rating. A number 1 is stored to represent positive a 2 is stored for neutral and a 3 is stored for negative. I need to query that will query up all the number 1's (positives) and subtract all the nu

myisampack - segmentation fault

Hy! i have some trouples to compress one table (http://www.notz.ro/table.tar.gz) with myisamcheck. myisampack always terminate with a segementation fault. here an example: istanbul:/var/mysql/sms_plus # /usr/local/mysql/bin/myisampack -vf message_archiv_25 Compressing message_archiv_25

Re: HELP with SQL statement

* Mike Podlesny <[EMAIL PROTECTED]> wrote on 19.01.01 17:25: > I have a table called RATING and two fields one called POSITIVE and the > other called NEGATIVE. I need to write an SQL statement for my mySQL > database that will return the value of the total of POSITIVEs minues the > total of the N

how to use count to compare number?

dear all: I need some help from you. The dataset is as following maker pc.id a1 a2 a3 b4 b5 I need to retrieve the maker which include at least 2 pc.id. I try to write in this form, but it is error! select maker from table1 where count(pc.id) > 2 group by maker. thank y

HELP with SQL statement

I have a table called RATING and two fields one called POSITIVE and the other called NEGATIVE. I need to write an SQL statement for my mySQL database that will return the value of the total of POSITIVEs minues the total of the NEGATIVEs. Any ideas? -

Re: Crashing MySQL on FreeBSD4.2 with Apache/php4

Nicolai, As I sent you earlier, on the 17th, you MUST upgrade your FreeBSD to FreeBSD-stable of January 10th or later, or apply the patch I sent you and recompile, or use the contributed binary on the mysql web page: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.30-gamma-unknown- freebsde

Re: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

On Fri, Jan 19, 2001 at 12:48:44PM +, Greg Cope wrote: > > But does the conspiricy not continue ? Yes, I suppose it does. I guess my secret spy status as enemy of the state is now out in the open, plain as day. > Do you not need to patch aclocal.m4 as this contains a referance to > 3.2.3

Re: Connecting to MySQL with Visual Basic

You can also use MyVbQL.dll ... take a look at http://www.icarz.com/mysql/index.html Eric Rolf Hopkins wrote: > Someone sent me some samples of various connection type (ADO, DAO, etc) > about a month ago but I'll post off list. > > - Original Message - > From: "Dwight Mowbray" <[EMAIL

RE: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

Hi ! I am trying to implement BDB tables on windows NT. I have installed mysql 3.23.31 and have downloaded Berkeley db file 3.2.3. I am new to mysql. I have tried to look for instructions but I have no luck. Thanks Irena -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTE

Re: MYSQL and ODBC

Firstly, you should respond to the list as you'll get a better response this way. I may not know the answer or I may not have time to answer. Did you install MyODBC? Try using that instead. That's it from, I'm on holidays for a week. Cheers Rolf - Original Message - From: "James "B

  1   2   >