Re: MySQL UDF questions

On Thursday, 11. April 2002 02:11, Fei Chen wrote: How do I write a UDF to handle a entire tuple, e.g. is it possible to have select my_udf(*) from myTable; ? Parmeters in the UDF could also be fields from a table. Also, is there a way for a UDF to return a data structure, say, a multi

nvarchar

hi, what is the function of nvarchar...is it can use in mysql7. sql thanks in advance _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

Wich version of FreeBSD is better?

Hi all. I've read the manual of mysql and it says that for mysql is better use FreeBSD 3.x because the thread package is much more integrated (2.6.4.1 FreeBSD Notes). I have the doubt if this it's comentary refers to FreeBSD 3.x and next versions (FreeBSD 4.x) or it refers that FreeBSD 3.x is

Re: Wich version of FreeBSD is better?

On Thu, Apr 11, 2002 at 09:39:56AM +0200, Iago Sineiro wrote: Hi all. I've read the manual of mysql and it says that for mysql is better use FreeBSD 3.x because the thread package is much more integrated (2.6.4.1 FreeBSD Notes). That's a bit outdated now. I have the doubt if this it's

Re: MySQL UDF questions

Dear Georg, Thanks for replying. I have read the mysql manual but unfortunately have not been able to find the answer. I realize UDFs can have field names as their parameters, as in select my_udf(fld1, fld2, fld10) from myTable; but here the field names have to be specified explicitly. What I'm

Problem with very large Indexes

Hi all, we have a little problem with the size of our index file. We need to set a lot of combined Indexes and singel Indexes (we have a table with ca. 40.000.000 entries and something about 20 Columns). I'm pretty sure that the index file will get over the 4 GB size. We use Linux 2.4.x with a

Math Computations

Hi, I have this table that looks like this Computers | Department | Price per PC | TotalAmount | 15 | Marketing | $500.00| | 5 | Purchasing | $ 300.00 | | I want this table to display the total price wherein

get date

hi everybody, I want to get date expire according to their term joining...let say 6 month term..so i have to get the date when reach 6 month can anyone help me... query sql thanks in advance. _ Join the world’s largest e-mail

Re: Math Computations

Something like ? $db = mysql_connect(localhost,database_user,password); mysql_select_db (database_name); $query = SELECT * FROM table_name; $result = mysql_query($query); echo Computers | Department | Price Per PC | Total Amountbr; while ($row = mysql_fetch_row($result)){

mysqladmin security

Hello, When I execute mysqladmin drop database database_name it drops the database without asking for a user or password. How are the security features are set about mysqsladmin? Regards Okan - Before posting, please check:

Re: MySQL UDF questions

On Thursday, 11. April 2002 10:26, Fei Chen wrote: Dear Georg, * notation. Just as normally I can say select * from myTable; can I write a UDF to handle select my_udf(*) from myTable; ? There is the builtin function select count(*) from myTable; But the manual does not say how this is

Re: Core dump when execute safe_mysqld

Truc, Wednesday, April 10, 2002, 8:25:35 PM, you wrote: TT Description: TT I have downloaded a binary version of mysql, perform all installations steps TT from the manual. As soon as I started to execute safe_mysqld --user=mysql TT I got a core dump and the program

Re: mysqladmin security

Okan, Thursday, April 11, 2002, 12:52:04 PM, you wrote: OC When I execute mysqladmin drop database database_name it drops the database OC without asking for a user or password. How are the security features are set OC about mysqsladmin? Check permissions on databases. Looks like the anonymous

Re: share/mysql/mysql.server start does somthing but also shuts down mysql.

Chris, Thursday, April 11, 2002, 8:22:40 AM, you wrote: CT the command (run from my mysql basedir) share/mysql/mysql.server start CT gives me this message CT - CT Starting mysqld daemon with databases from /usr/local/ CT mysql/var CT 020411 17:25:51 mysqld ended CT CT Thats it. MySql

Re: mysql Ver 3.23.49 installation issues with binary

TruthXayer, Wednesday, April 10, 2002, 9:53:15 PM, you wrote: T I downloaded mysql Ver 3.23.49 binary to T a local directory. other than (/usr/local) T I changed ./bin/mysqlaccess for MySQL location, etc. T but for some reason it dies as sooon as starts.

Re: modifying varchar to char on the fly

ensembl, Thursday, April 11, 2002, 6:18:04 AM, you wrote: e Description: e When attempting to modify a column from varchar(40) to char(40) the command returns successfully, however the table is unaltered e How-To-Repeat: e (prepare a table table_name with a column column_name

Re: Problem with mysqldump when using query caching

Nick, Wednesday, April 10, 2002, 7:27:20 PM, you wrote: NP I'm using Mysql 4.0.1 with query caching: NP set-variable = query_cache_limit=10M NP set-variable = query_cache_size=10M NP set-variable = query_cache_startup_type=1 NP

Re: get date

saraswathy, Thursday, April 11, 2002, 12:41:29 PM, you wrote: ss I want to get date expire according to their term joining...let say 6 month ss term..so i have to get the date when reach 6 month can anyone help me... Take a look at MySQL date and time function, such as DATE_ADD(), DATE_SUB():

-- OpenSSL and MySSL ... Is it real?

Hello All In MySQL 4.x MySQL Reference Manual for version 3.23.49 in 1.1.6 The Main Features of MySQL there is a support OpenSSL. Who used that this opportunity in MySQL + php? What impressions? Difficulties? Features? -- Best regards, maxim mailto:[EMAIL

Another question of Date.

Hi, I got a small problem I like to be able to read a DATE but I don't want to read the Year. I only want to read the month and the date. For example, I like to read the a Birthday Field to see who Bithday is today. Also like to be later be able to read that same field but this time the year so

Re: Another question of Date.

http://www.mysql.com/doc/D/a/Date_and_time_functions.html mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y'); - 'Saturday October 1997' mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s'); - '22:23:00' mysql select DATE_FORMAT('1997-10-04 22:23:00',

Re: Another question of Date.

Thanks but I want to be able able to use this in SQL statement not format the output. Chuck on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote: http://www.mysql.com/doc/D/a/Date_and_time_functions.html mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y'); - 'Saturday October

Re: Another question of Date.

SELECT DATE_FORMAT(date column,'%W %M %Y') as date FROM table; Mike - Original Message - From: Chuck PUP Payne [EMAIL PROTECTED] To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 7:53 AM Subject: Re: Another question of Date. Thanks but I want to be able

Re: Another question of Date.

Sorry, Do you mean to use the date in a WHERE clause? I've use php's date function to supply a date for a WHERE clause in a sql statement. Mike - Original Message - From: Chuck PUP Payne [EMAIL PROTECTED] To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 7:53

RE: Another question of Date.

* Chuck PUP Payne Thanks but I want to be able able to use this in SQL statement not format the output. SELECT * FROM table WHERE DATE_FORMAT(birthday,'%M %D') = DATE_FORMAT(now(),'%M %D'); -- Roger query -

Re: Another question of Date.

Mike and the mysql list, This is the SQL statement I am using now; SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) =7 AND (TO_DAYS(D\ OB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB, Lname But it

Re: Another question of Date.

Sorry that second 2002 should be year. I don't want to change year to get it to work. Chuck on 4/11/02 8:10 AM, Chuck PUP Payne at [EMAIL PROTECTED] wrote: Mike and the mysql list, This is the SQL statement I am using now; SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email

RE: Another question of Date.

About midway down the page...: http://www.mysql.com/doc/S/t/String_functions.html SUBSTRING(str,pos) SUBSTRING(str FROM pos) Returns a substring from string str starting at position pos: mysql select SUBSTRING('Quadratically',5); -

Connection

I have the following message: Microsoft OLE DB Provider for ODBC Drivers- Fehler '80004005' [TCX][MyODBC]Can't open named pipe to host: 192.168.97.2 pipe: MySQL (5) /hopital/Web/De/TMP20w8iuel5u.asp, line 5 can anybody help me?

SBS and MySQL

Hello all, We recently Installed MySQL on M$ lovely Small Business Server, and since then we have been experience some problems. I was wondering if any one had experience with SBSand MySQL and if they did or did not have any problems with it. Personally I don't think it is MySQL that is crashing

Re: binlog and replication stuff

FLUSH LOGS safely rotates the binlog. Davide Giunchi wrote: You are right, but my master generate about 150Mb of binlog x day, i a slave fail after 4 day it will reexec a lot of query and take some time. how can i safely rotate the log in master+slaves without restarting them? The Mysql

Re: binlog and replication stuff

If the master crashes, you can move the ip of you master to the slave machine and it can become the new master. However, to move back to teh master, you will need to copy the stuff back to the master. There's some good information in the manual about how to plan disaster recovery:

Re: How to automate bin-log clean-up with replicated MySQL servers?

We have a slightly smarter script which checks each slave to find the furthest one behind and purges up to that number. However, it currently figures out who the slaves are by checking a process status on the master. Unfortunately, this doesn't work if one of your slaves is down. So, I'm going

Re: binlog and replication stuff

FLUSH LOGS in the master and all is ok? binlog will be rotate and slaves will see it, continue to work and update master.info? Regads Il 15:31, giovedì 11 aprile 2002, hai scritto: FLUSH LOGS safely rotates the binlog. Davide Giunchi wrote: You are right, but my master generate about

RE: How to automate bin-log clean-up with replicated MySQL servers?

-Original Message- From: Marc Prewitt [mailto:[EMAIL PROTECTED]] Sent: 11 April 2002 14:46 To: [EMAIL PROTECTED] Cc: paul Subject: Re: How to automate bin-log clean-up with replicated MySQL servers? PFIZER GLOBAL RESEARCH AND DEVELOPMENT

Re: Web based search

Hi, Thanks for the reply. Currently We are using fulltext index search only. What I am looking forward is another effective way of doing it -- On Wed, 10 Apr 2002 15:15:08 Cathy Cunningham (Blue World Lasso Evangelist) wrote: At 1:08 PM -0700 4/10/02, va ku wrote: We are developing a

About BLOBS

Hello, Does MySqL database supports BLOBs operation? (Insert, delete etc ...) If yes which API can use to do these operations? (MySqL++)? Thanks for help - Before posting, please check: http://www.mysql.com/manual.php

MYSQL 4.0 Beta

Hi, We want to use only MYSQL4.0 for our production database. Please let us know when the Beta release is scheduled. Regards See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp

RE: Connection -- Can't open named pipe error

http://www.mysql.com/doc/W/i/Windows_vs_Unix.html Can't open named pipe error If you use a MySQL 3.22 version on NT with the newest mysql-clients you will get the following error: error 2017: can't open named pipe to host: . pipe... This is because the release version of MySQL uses named

PHP Question

Ok so this really doesnt have anything to do with MySQL but I thought this might be a good placeto ask. Ok heres the problem. I am constructing a Message Board with MySQL and php (was usingASP) and I dont want the user to reload/repost data. For example, say the user goes to post amessage, after

Re: About escape character '\'

Kathy, You shouldn't have a problem here--it's Java, not MySQL, that requires the doubled '\' in a string literal. In Java, the string literal: INSERT INTO files (filepath) VALUES ('c:\\Repository\\Pack\\' ) represents the string whose content is INSERT INTO files (filepath) VALUES

MYSQL COMPILING ON HPUX 11.00

HELLO, ANYBODY HAS COMPILED MYSQL - MAX IN HPUX 11.0 ? THANKS, Ing. Gustavo A. Edelstein Tech. Mgr. Equiplus Argentina S.A. __ Visit us On Line at www.equiplus.com Email addresses: Operations: [EMAIL PROTECTED] Consulting: [EMAIL PROTECTED] Technical: [EMAIL

mysql install 3.23.49 *make* cobalt raq2

when running a make i get the follow errors: In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:685: warning: abstract declarator used as declaration make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/home/redhat/BUILD/mysql-3.23.49/client'

ADODB.Connection- Error

I have the following message since that time I installed the new MS-Securety Patch: ADODB.Connection- Fehler '800a0e7a' Der Provider kann nicht gefunden werden. Möglicherweise ist er nicht richtig installiert worden. can anybody help me? It's an Windows 2000 System (GERMAN) with myODBC 2.5 and

RE: PHP Question

Hi, Ok so this really doesnt have anything to do with MySQL but I thought this might be a good placeto ask. Why? As you say, it's not in any way related to MySQL. reload the page and postthe message again! doh! Anyways, has anyone come up against a similar problem and found a way around

Re: About BLOBS

Hello, Does MySqL database supports BLOBs operation? (Insert, delete etc ...) Yes. If yes which API can use to do these operations? (MySqL++)? Any. BLOB columns are just character columns. They need not be accessed in separate hunks like in some other databases. Thanks for help

Re: PHP Question

At 09:13 AM 4/11/2002, you wrote: Ok so this really doesnt have anything to do with MySQL but I thought this might be a good placeto ask. Ok heres the problem. I am constructing a Message Board with MySQL and php (was usingASP) and I dont want the user to reload/repost data. For example, say the

insert into select failing and read only tables

SQL SQL SQL SQL hi, i have 2 problems here. 1) i have 2 tables: currency rates +-+ ++ | code char(3)| | currency char(3) | | name varchar(10)| | rate double| | bcurrency

Re: About BLOBS

Thanks Paul, Hisseine - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Hisseine Dj. [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 10:40 AM Subject: Re: About BLOBS Hello, Does MySqL database supports BLOBs operation? (Insert, delete etc ...)

RE: Another question of Date.

Hi, I got a small problem I like to be able to read a DATE but I don't want to read the Year. I only want to read the month and the date. For example, I like to read the a Birthday Field to see who Bithday is today. Also like to be later be able to read that same field but this time the

RE:PHP Question

Thanks for all of you who responded with ideas. I think I'm going to go with the temp page,redirect solution. Seems to me that this is the simplest and easiest way to deal with it. I could have dont it with MySQL as some one stated by entering a unique identifier andkeeping track of that, but

Re: myODBC

Andrew, Wednesday, April 10, 2002, 7:26:01 PM, you wrote: AH I'm trying to use the old MS Visio Modeler with mysql. I have AH downloaded and installed the myODBC driver and set up a DNS. But I keep AH getting this connection error: AH Can't connect to MySQL server on 'www.jsicorp.com'(10060)

Re: About BLOBS

Hisseine, Thursday, April 11, 2002, 5:21:09 PM, you wrote: HD Does MySqL database supports BLOBs operation? (Insert, delete etc ...) HD If yes which API can use to do these operations? (MySqL++)? BLOB are just the same thing as other field types. You can use INSERT, UPDATE, DELETE statements to

mysqladmin

Hi all, I just downloaded the MySql rpm file : MySQL-3.23.49a-1.i386.rpm I did the installation on linux redhat 7.2, everything is ok, but I can't locate the msqladmin command. I try find command as root but nothing in the result. Does binary files are missing in this version? Thanks, Hisseine

Re: mysqladmin

Hisseine, Thursday, April 11, 2002, 7:13:58 PM, you wrote: HD I just downloaded the MySql rpm file : MySQL-3.23.49a-1.i386.rpm HD I did the installation on linux redhat 7.2, everything is ok, but I can't HD locate the msqladmin command. HD I try find command as root but nothing in the result. HD

Re: mysqladmin

Thanks Egor, I just did it now and I find that. I start the installation today so that's I am missing some elements. Again thanks for your help. Hisseine - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 12:22 PM Subject: Re:

MySQL package on HPUX, REDHAT and Windows

Hi, I am looking for MySQL package on HPUX, REDHAT and Windows. Can anyone tell me where I should look for standard package for MySQL? For HPUX, I found one at: http://hpux.cs.utah.edu/hppd/hpux/Development/Languages/mysql-3.23.42/ Thanks a lot! Zengfa

row count in tables

sql, query Is there a built-in to get the number of rows in a table.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Re: row count in tables

figured it out... - Original Message - From: destr0 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 11:51 AM Subject: row count in tables sql, query Is there a built-in to get the number of rows in a table..

question about Chinese Windows XP and MySql

Anyone has experience with Chinese Windows Xp Professional and MySql? I am not able to install MySql on Chinese Windows. I got an unknown character error message (The package I am using is from Canada). Do I have to use the package from Asia (China, Taiwan or Hong Kong). Please advise.

RE: About escape character '\'

sorry, I should say add 3 extra '\' and not just one in my previous email, since if I add 3 more and it becomes: INSERT INTO files (filepath) VALUES ('c:RepositoryPack') which represents the following string in Java: INSERT INTO files (filepath) VALUES ('c:\\Repository\\Pack\\')

ANN: EMS MySQL Manager 1.7 released

Dear Sirs and Madams, EMS HiTech company is announcing the next version (1.7) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 1.7?

Re: database setup

Sorry I am still having some problems with how to create random security keys. Would you mind please give me an example code? A few lines is fine. My codes are as follows. Regards, Norman // connect to mysql $authdb = mysql_connect('localhost', 'webauth', 'webauth') or die(Cannot

Possible issue with long pathnames and socket locations.

Description: The first of these problems is the long pathname. I've already tracked this down and fixed it in a local copy. The problem is that in the files: libmysql/errmsg.c libmysql_r/errmsg.c mysys/my_vsnprintf.c

MySQL Memory Leak ??

I am having a problem with a mysql server that I have that starts up with about 10-15 processes at 12MB each.and then JUMPS to a couple hundred processes at 100MB each. in just a couple minutes time. What can cause this, other than just some loop in a script? Any ideas anyone? This is

Converting VARCHAR 255 column to TEXT 64

Does converting one type of column to a bigger type such as listed in my subject lose the information that is contained in that row/column or does it just expand the limit? -- - Alex Pilson FlagShip Interactive, Inc. [EMAIL

Re: Converting VARCHAR 255 column to TEXT 64

It'll expand the limit. You'll lose the data if you convert from a larger form back to a smaller one. ( Text to Varchar.. if the text is longer than 255. ) -- sh On Thu, 2002-04-11 at 12:09, Alex Pilson wrote: Does converting one type of column to a bigger type such as listed in my subject

Re: search pattern matching

HI CRAIG, i'ts possible to use this query with multiple search terms? query: select * from TABLENAME where if(right(SEARCHFIELD,1)='s',left(SEARCHFIELD,lenth(SEARCHFIELD)-1),SEARCHFIE LD) like '%SEARCHTEXT%' i.e: one user search for: passaros jogos campos [in portugueze] the app is written

Can't change ft_min_word_length on mysql-max

Hi, All. I'm running mysql-max version 3.23.49a-max and am not able to change ft_min_word_length. It also does not show in the list when I run show variables. When I try to specify it on the mysql command line start mysqld just dies. Is this configurable with this version? thanks -Kevin

Access Denied

Hello, All: Once I complete the installation, I try to set up password for root user: /usr/bin/mysqladmin -u root -p password 'mypassword' It did prompt me for new password, I reentered. But I got error back: Connect to server at 'localhost' failed. Error: Access denied for user

Re: libmysqlclient on Darwin/OS X

Heya: in openBSD I have a cli interface for simple i/o to mysql database. Written in C. it works perfectly. On Darwin and OS X it won't compile. It gives the following errors. $ cc -lmysqlclient -I/usr/local/mysql/include testmy.c linklist.c /usr/bin/ld: Undefined symbols: _mysql_close

Re: Access Denied

Did you run the mysql_install_db? http://www.mysql.com/doc/P/o/Post-installation.html -- sh On Thu, 2002-04-11 at 13:53, Jane Tsai wrote: Hello, All: Once I complete the installation, I try to set up password for root user: /usr/bin/mysqladmin -u root -p password 'mypassword' It did

Re: Can't change ft_min_word_length on mysql-max

At 13:17 -0700 4/11/02, Kevin Lewandowski wrote: Hi, All. I'm running mysql-max version 3.23.49a-max and am not able to change ft_min_word_length. It also does not show in the list when I run show variables. When I try to specify it on the mysql command line start mysqld just dies. Is this

Re: MySQL concept question

On Thursday 11 April 2002 4:09 pm, Thi Cao wrote: All, When I insert records into a database, the records will be inserted in the order that I have them listed in my insert statement. So my question is, will the MySQL database always return the records in the order of insertion when I

RE: MySQL concept question

if you are interested in selecting records in the order in which they were inserted, apply an auto-increment/identity field to your table schema and when you select, use ORDER BY on that field. This is the only guaranteed way to retrieve records in the order in which they were inserted.

Re: Access Denied

Hello, All: Once I complete the installation, I try to set up password for root user: /usr/bin/mysqladmin -u root -p password 'mypassword' It did prompt me for new password, I reentered. The prompt is for your *current* root password. If you don't have one yet, just hit return. But I got

Re: Problem with very large Indexes

On Thu, Apr 11, 2002 at 10:46:43AM +0200, Stefan Siefert wrote: Hi all, we have a little problem with the size of our index file. We need to set a lot of combined Indexes and singel Indexes (we have a table with ca. 40.000.000 entries and something about 20 Columns). I'm pretty sure that

Re: MYSQL 4.0 Beta

On Thu, Apr 11, 2002 at 07:16:34AM -0700, va ku wrote: Hi, We want to use only MYSQL4.0 for our production database. Please let us know when the Beta release is scheduled. When it's ready. :-) Seriously, check the archives. This comes up a lot and the answer is nearly always the same.

regarding libmysqlclient and libmysqlclient_r

Hi, I'm using the mysqlclient_r library to access the database. I have written some code as an interface to access the MYSQL databse and have written the following test code to test the library. I'm using Linux 2.4.4-4 as the platform. I'm putting locks around my entire test case so that two

Re: Math Computations

Hi Adam, Thanks for your reply. How about if I have more than 3 rows and I'm continously adding entries in my table. What do I need to do? Delz - Original Message - From: Adam Alkins [EMAIL PROTECTED] To: delz [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 5:44

Re: binlog and replication stuff

Yes. Davide Giunchi wrote: FLUSH LOGS in the master and all is ok? binlog will be rotate and slaves will see it, continue to work and update master.info? Regads Il 15:31, giovedì 11 aprile 2002, hai scritto: FLUSH LOGS safely rotates the binlog. Davide Giunchi wrote: You are

Re: Replication incompleteness problem

A couple of questions below: Wendell Dingus wrote: ... cron entries: - Server2: 20 4 * * * /etc/rc.d/init.d/mysql stop 1/dev/null 2/dev/null # 25 4 * * * /bin/rm -f /var/lib/mysql/master.info 1/dev/null 2/dev/null Why are you deleting master.info? It's my

Replication problem

Hi. I got the problem with replication if I use SQL command LOAD DATA INFILE... to update data in master table the data change to the new one correctly but in slave table nothing happen the data still have the old value. how to solve this problem ?? Kittiphum Worachat,M.T. www.hatyailab.com

MySQL Bug

On my computer both old 'stable' releases and new alpha downloads of MySQL report this error: 020411 21:21:31 Can't find messagefile 'c:\mysqin\share\english\errmsg.sys' 020411 21:21:31 Aborting Although I have checked several times for the files existence. Any Idea?

Re: prefix

On Tue, Apr 09, 2002 at 05:45:04PM -0700, David Turner wrote: Thanks, but what I need to do is have make install install everything into /home/turner/mysql/test then I'll check everything out to make sure it is how I want it and last I'll copy it all to /usr/local. Any way to do this

Re: InnoDB tables

On Tue, Apr 09, 2002 at 10:17:56AM +0200, Luke van Blerk wrote: Hi everyone, I've been reading up about InnoDB tables and they seem to have lots of advantages. I'm particularly interested in using the foreign keys as this will save me some much need time. In the benchmark tests on the

Facing problems in transaction control

Dear Sir / Madam We at www.axistech.com are developing a web based application that requires transaction control we are using java 1.3 , jsp and MySql MySQL 3.23.49 we will be using windows version and linux version we would like to know which of the windows version supports --- Transaction

Re: conditionnal loops in mysql

On Tue, Apr 09, 2002 at 10:01:25AM +0200, Van Overbeke, Tom wrote: now, i'd like to change each record in table1 where a field contains a +ADSM entry, lookup the corresponding records in table 2, and, in this case for example, add 3 records to table1 where the +ADSM field is replaced by

Re: How to automate bin-log clean-up with replicated MySQL servers?

On Thu, Apr 11, 2002 at 09:46:18AM -0400, Marc Prewitt wrote: We have a slightly smarter script which checks each slave to find the furthest one behind and purges up to that number. However, it currently figures out who the slaves are by checking a process status on the master.

Re: performance for single/multiple databases

On Wed, Apr 10, 2002 at 12:12:32AM -0500, Truong Thai wrote: I have a performance question between having a single database for all tables or splitting up tables into multiple databases. The hosting service I use charges extra for multiple databases. Using PHP/MySQL for website. I

Re: nvarchar

On Thu, Apr 11, 2002 at 06:47:39AM +, saraswathy saras wrote: hi, what is the function of nvarchar...is it can use in mysql7. Huh? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL

Re: MySQL Memory Leak ??

On Thu, Apr 11, 2002 at 12:05:45PM -0700, Steven Deaton wrote: I am having a problem with a mysql server that I have that starts up with about 10-15 processes at 12MB each.and then JUMPS to a couple hundred processes at 100MB each. in just a couple minutes time. Can you get a