Recall: SunUltra-60 compiler problem!!

2001-08-16 Thread Aru.Chen
Aru.Chen §Æ±æ¦^¦¬³o«Ê¶l¥ó [SunUltra-60 compiler problem!!]¡C

RE: SunUltra-60 compiler problem!!

2001-08-16 Thread Aru.Chen
Sinisa Milivojevic, I have do this 'export CXXLD=g++' config, but the problem still exist on solaris. attachments for you reference: Regards, Aru August -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 8:34 PM To:

Re: Problems starting the MySQL server.

2001-08-16 Thread Grigory Bakunov
You need to start mysql in RH version by service mysqld start or /etc/init.d/mysqld start ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___

RE: insert records

2001-08-16 Thread Venu
Hi ! )-Original Message- )From: rsaras [mailto:[EMAIL PROTECTED]] )Sent: Wednesday, August 15, 2001 10:23 PM )To: [EMAIL PROTECTED] )Subject: insert records ) ) )hai ) ) can anybody help me? ) )Table A )--- )name date )a2000/12/12 )b2000/12/12 )c

Dates: To Slash or to Hyphen. That is the question

2001-08-16 Thread Van
Greetings: Building a web form. There are 3 datetimes: RequestDate, FulfillDate, and CancelDate. New record populates a web form with the current date/time in -mm-dd hh:mm:ss format. RequestDate is current date, FullFillDate and CancelDate are -00-00 00:00:00. Updates present them

Re: Benchmarking

2001-08-16 Thread Jeremy Zawodny
On Mon, Aug 13, 2001 at 05:54:35PM +0100, Tadej Guzej wrote: How do I benchmark 2 queries that return same results without having mysql read from cache? The only certain way is to restart the server between the queries and do what you can to flush the OS cache, too, if you're concerned about

Re: Error with mysql_install_db

2001-08-16 Thread Grigory Bakunov
Date |Wed, 15 Aug 2001 11:02:00 -0700 From |Alex Cook [EMAIL PROTECTED] Hello! AC I'm attempting a source installation of mysql-3.23.40 on a Solaris 7 SPARC AC server. the compile process completed without any errors. After reading AC the various docs, I located the mysql_install_db script

Accessing the MySQL on a remote machine!!

2001-08-16 Thread Ganesh Krishnan
Hi, Is it possible for me to access a database on a remote machine by giving the IP address of the remote machine as the host??? If it possible, can I access a database of the root user by giving the password set for the root user??? How do I add a new user to MySQL?? I tried by

Re: Chinese PinYin/Traditional Support in mysql?

2001-08-16 Thread shiuwaitai
Hi, Have you tried to change your browser's encoding to Big5 in order to view Chinese characters? Have you tried to use mysql client to select those multi-byte characters? Have you seen they are OK? If you still cannot view strings properly, and you use Java to implement your system, try to

Explanation: Problems with MYSQL-D-MAX for win 98 DROP TABLE

2001-08-16 Thread Luciano Pulvirenti
I will try of to be clearer. Operating system: WIN98 Version of Mysql 3.23.40 EXE : Mysql-d-max I create a table of example. Create table test ( Field1 tinyint not null ) type=BDB The table is created regularly. The statement DROP TABLE testresponds Error 1051 - Unknown table test The

Re: auto_increment vs. heap tables

2001-08-16 Thread Leos Bitto
On Wed, 15 Aug 2001, Jeremy Zawodny wrote: On Tue, Aug 14, 2001 at 12:05:08PM +0200, Leos Bitto wrote: Hello, I am currently changing a simple PHP4-based application from PostgreSQL 7.1 to MySQL 3.23. Welcome to MySQL, then. :-) I am already using MySQL a lot, and now I am facing an

Re: Looks like any user can read the mysql db!

2001-08-16 Thread Benjamin David Hildred
On Thu, Aug 16, 2001 at 03:01:20AM -0700, Jose de Leon wrote: This is what I did: load data local infile '/var/lib/mysql/mysql/user.MYD' into table data; ^ At first I did it without the 'local' keyword. But with 'local' keyword it works. When you ad the local

Re: Dates: To Slash or to Hyphen. That is the question

2001-08-16 Thread karel pitra
hi, first - using php wouldn't it be much easier to use an integer to store datetime in the database? - i think it's faster and it allows you to manipulate the date much more easily. you could just tokenize the date string (using space,'/' and '-' or any ohter characters as the separators) -

How does MySQL generate it's web based documentation

2001-08-16 Thread David Herring
Good morning, Does anyone have any details on the how the MySQL searchable documentation is produced. Is the content held in MySQL with PHP to produce the frontend pages - and is this something that can be applied generally for web based doumentation services. Thx dave

sql query problem

2001-08-16 Thread Fabian Groene
Dear group members, I have a serious problem with an SQL query that has kept me busy for over a week. Doing my compusory service at a non-profit environmental organisation I was asked to experiment with SQL queries within the ArcView GIS program. My problem is quite simple indeed and only

Re: Accessing the MySQL on a remote machine!!

2001-08-16 Thread Stefan Hinz
Dear Ganesh, if you can connect to the MySQL server with mysql, you can create new users with the GRANT command. Is it possible for me to access a database on a remote machine by giving the IP address of the remote machine as the host??? For such a user, a GRANT statement would look like

Re: I'd like to use MySQL but actually I'm not sure ...

2001-08-16 Thread Paul Mallach
Or, you could write your business rules as a middleware application in C or Python (etc.) and access that middleware to do the rest of your application. A good idea. Or Perl. :-) I think it's a good idea as well and in fact our website is built that way. Having all database specific code

Re: Large data in tables

2001-08-16 Thread Sinisa Milivojevic
Jeremy Zawodny writes: On Wed, Aug 15, 2001 at 09:25:27PM +0300, Sinisa Milivojevic wrote: This limit is already increased in 4.0 to 4 Gb. 4.0 will be available next month. 4.0 will be in alpha/beta testing at that point, right? It's important not to set expections too high. :-)

Re: Trouble upgrading to mysql ver 3.23.41

2001-08-16 Thread Sinisa Milivojevic
sachin shetty writes: Hi i have successfully installed the 3.23.39 version of mysql. but the 3.23.41 version throws the following error when the mysqld daemon is started 010815 15:14:42 mysqld started 010815 15:14:42 Warning: setrlimit couldn't increase number of open files to more

Re: Dates: To Slash or to Hyphen. That is the question

2001-08-16 Thread Van
karel pitra wrote: hi, first - using php wouldn't it be much easier to use an integer to store datetime in the database? - i think it's faster and it allows you to manipulate the date much more easily. you could just tokenize the date string (using space,'/' and '-' or any ohter

MYSQL Connection Problems

2001-08-16 Thread O'SULLIVAN JOHN
Hi all, I am very new to MYSQL and I am running 3.23 on RedHat Linux 7.1. I have just set up a simple database. I was not prompted for a password,and was just allowed to set it up and access it.I now want to access it through C,and I am trying to set up a connection to my database but I am

Gaurav Tuli

2001-08-16 Thread gaurav
Hi, I'm using JDBC/MySQL and the MM.MySQL driver to build JSP pages.the application is deployed in tomcat.I am using connection pooling package in my application.i am able to create a pool when the first user logs in.kindly advice how i can close or destroy the connections when the server

Connection Pooling (closing of connections)

2001-08-16 Thread gaurav
Hi, I'm using JDBC/MySQL and the MM.MySQL driver to build JSP pages.the application is deployed in tomcat.I am using connection pooling package in my application.i am able to create a pool when the first user logs in.kindly advice how i can close or destroy the connections when the server

RE: SunUltra-60 compiler problem!!

2001-08-16 Thread Sinisa Milivojevic
Return-Path: [EMAIL PROTECTED] Received: from work.mysql.com (work.mysql.com [192.58.197.161]) by platon.cytanet.com.cy (8.11.1/8.11.1) with ESMTP id f7G5g531486312 for [EMAIL PROTECTED]; Thu, 16 Aug 2001 08:42:11 +0300 (EEST) Received: (from root@localhost) by

synchron of two databases.

2001-08-16 Thread sly
I have a very interesting question. I have a program that works on 2 computers, using some king of p2p protocol. Each side is using mysql for work. How I can synchronise two databases on these computers. - Before posting,

Retrieving Auto-increment index after insertion.

2001-08-16 Thread Charles Williams
Hello, I am trying to figure out how I can retrieve an automatically incremented index after I insert data into the table. The index is the ONLY information that is unique in the entry at times and additions are quite often. Any ideas would be appreciated. Thanks, chuck Chuck's Top 10 Things

synchronisation (replication)

2001-08-16 Thread Neil Tompkins
Hello Below is a message I posted earlier. But what I'm really looking for is does MySQL provide synchrosisation of data. If so, can someone point me in the right direction Thanks Neil From: Jeremy Zawodny [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Neil Tompkins [EMAIL PROTECTED]

Re: Local Sockets vs TCP

2001-08-16 Thread Christian Jaeger
At 0:09 Uhr -0400 15.8.2001, Hans Zaunere wrote: Well I uncovered an interesting thing. If I use the regular old bin/mysql client to connect to the database (both on the same machine) and I run: ./mysql -uroot -p -h localhost    Then run netstat -an , it shows that another /tmp/mysql.sock

Re: Retrieving Auto-increment index after insertion.

2001-08-16 Thread Frank Fisher
Charles Williams wrote: Hello, I am trying to figure out how I can retrieve an automatically incremented index after I insert data into the table. The index is the ONLY information that is unique in the entry at times and additions are quite often. Any ideas would be appreciated. In

Re: How to make this code pretty?

2001-08-16 Thread Philip Mak
Doesn't doing it that way preclude using $dbh-quote? That could mess up if the name had a single quote in it. One idea I had was to do something like this: my ($f, $d); # form data, database data for (qw(friendly parent intentional address port timeout priority)) { $f{$_} = $q-param($_);

aggressive dolphin?

2001-08-16 Thread Theo Richel
I am a very dedicated user of Mysql, but I am somewhat disappointed that you chose the dolphin for your logo because of the good nature of this animal. In the New York Times (1999) I read: ‘But scientists, following a trail of bloody clues, are discovering that dolphins are far from the happy,

Re: synchronisation (replication)

2001-08-16 Thread Werner Stuerenburg
Neil Tompkins schrieb am Donnerstag, 16. August 2001, 14:20:07: Below is a message I posted earlier. But what I'm really looking for is does MySQL provide synchrosisation of data. If so, can someone point me in the right direction Well, I'll give it another try. The answer is Yes and

locking question

2001-08-16 Thread Ken Guest
hi, I'm new to this list, but not so new to using MySQL and have a question about locking. (This is my first foray into datalocking with MySQL.) I'd like to lock a table (a row in that table would be better) for read and write access to prevent mishaps from occurring during data manipulation.

RE: synchronisation (replication)

2001-08-16 Thread Simon Green
Hi Neal All that replication douse is use the master database logs to update an identical database (slave). All you should need to do is make shore both databases are the same. Make changes to both the my.cnf file and restart the mysqld... Hope this helps Simon -Original Message-

Downsides of MySQL?

2001-08-16 Thread Boget, Chris
Good morning. Recently, we presented MySQL as a database option for a website that we might be working on. We've used it as our database in the past and we plan on using it in the future as possible. With that said, I confess I don't have as intimate a knowledge of mySQL to address some of the

Re: I'd like to use MySQL but actually I'm not sure ...

2001-08-16 Thread Michael T. Babcock
Consider sending queries to your middleware and having it respond in XML for a great way to do better-than-SQL responses in some cases (such as making 'group by' return every result, grouped into XML sub-sections by the relevant field). Unless you care about performance. We've

hello

2001-08-16 Thread Brian Johnson Jaber
Dear Sirs Hello, i have questions on mysql i create a table and i create an index key in it i want to know how can i know in mysql if the date that i import it into the table are fully indexd. please reply. best regards. nabil jaber.

RE: synchronisation (replication)

2001-08-16 Thread Robinson, Mike
It seems certainly possible to automate 2 mysql servers in circular replication, each being master/slave to the other, provided your code is written in such a way to circumvent the auto_increment issue. Generating unique ids on a machine basis and using those values instead of an autoincrement

BDB and InnoDB in windows nt versions

2001-08-16 Thread Bruce Scharlau
Hi all, I'm trying to work out which distribution of mysql supports BDB or InnoDB tables. I've downloaded 3.23.40 and checked 'show variables' asnd it says these tables are not supported. I know the docs say they should be available in the distro, but it seems not in this version. So, who can

Re: Downsides of MySQL?

2001-08-16 Thread Sinisa Milivojevic
Boget, Chris writes: Good morning. Recently, we presented MySQL as a database option for a website that we might be working on. We've used it as our database in the past and we plan on using it in the future as possible. With that said, I confess I don't have as intimate a knowledge of

Re:BDB and InnoDB in windows nt versions

2001-08-16 Thread Heikki Tuuri
Hi! You should run mysql-max.exe or mysql-max-nt.exe. Those contain BDB and InnoDB. Regards, Heikki http://www.innodb.com .. Hi all, I'm trying to work out which distribution of mysql supports BDB or InnoDB tables. I've downloaded 3.23.40 and checked 'show variables' asnd it says these

Re: sql query problem

2001-08-16 Thread Ian Barwick
On Thursday 16 August 2001 10:52, Fabian Groene wrote: (snip) My problem is quite simple indeed and only refers to the SQL query: There is a table with quite a lot of columns. But only two of them are really important for my query: One field is a date field and the other one is a group

Re:BDB and InnoDB in windows nt versions

2001-08-16 Thread Heikki Tuuri
Oops, I forgot the 'd': it is mysqld-max.exe or mysqld-max-nt.exe Heikki -Original Message- From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, August 16, 2001 5:35 PM Subject: Re:BDB and InnoDB in windows nt versions Hi! You should run

RE: Downsides of MySQL?

2001-08-16 Thread Sander Pilon
MySQL - as I said at our meeting, we would not be comfortable with this as an enterprise strength solution. MySQL is unsupported freeware and lacks enterprise management functionality. True, if you ask me. It has a small limited feature set compared to ORACLE, DB/2 True. No

Re: Downsides of MySQL?

2001-08-16 Thread Frank Fisher
Boget, Chris wrote: --Begin Quote-- MySQL - as I said at our meeting, we would not be comfortable with this as an enterprise strength solution. MySQL is unsupported freeware and lacks enterprise management functionality. It has a small limited feature set compared to ORACLE, DB/2 and

[50 character or so descriptive subject here (for reference)]Still no var directory under /usr/local/mysql/

2001-08-16 Thread Claudia Castaneda
I have followed the installation instructions in your manual and the var directory is not being created where it says it should. I found it under /var/lib/mysql. How-To-Repeat: This is the history of the steps I have followed: 158 rm -r -f mysql/ 159 rm -r -f mysql-3.23.41/ ;; I

RE: Downsides of MySQL?

2001-08-16 Thread Ravi Raman
lol. how industrial strength does this website need to be? if it's anything less than an online banking/creditcard processing site, you'll probably be okay. i know go2net, xoom, and realnetworks (among other large sites) all use mysql. admittedly, they also use oracle or db2 in the mix as well,

RE: Downsides of MySQL?

2001-08-16 Thread Robinson, Mike
I suppose there will always be that facet out there that think spending $46zillion dollars on Oracle is ok because saying 'we use Oracle' is just plain sexy and the option includes, you know, a free t-shirt and hat. Im sure there are specific valid reasons for not using MySQL. None of them were

Re: MYSQL Connection Problems

2001-08-16 Thread Gerald Clark
Look at the source for the mysql client, and see how they do it. O'SULLIVAN JOHN wrote: Hi all, I am very new to MYSQL and I am running 3.23 on RedHat Linux 7.1. I have just set up a simple database. I was not prompted for a password,and was just allowed to set it up and access it.I now

@HOSTNAME@ ?

2001-08-16 Thread mysql
Hi ! I get: @HOSTNAME@: command not found Does anyone know how to solve that ? I didn't find anything on the net or on the mysql.com homepage. Thanks. Jan-Hendrik - Before posting, please check:

Re: Downsides of MySQL?

2001-08-16 Thread Michael Bacarella
On Thu, Aug 16, 2001 at 08:35:40AM -0500, Boget, Chris wrote: Recently, we presented MySQL as a database option for a website that we might be working on. We've used it as our database in the past and we plan on using it in the future as possible. With that said, I confess I don't have as

Re: BDB and InnoDB in windows nt versions

2001-08-16 Thread Sinisa Milivojevic
Bruce Scharlau writes: Hi all, I'm trying to work out which distribution of mysql supports BDB or InnoDB tables. I've downloaded 3.23.40 and checked 'show variables' asnd it says these tables are not supported. I know the docs say they should be available in the distro, but it seems

Re: Downsides of MySQL?

2001-08-16 Thread Robert Cross
Chris Boget wrote: MySQL - as I said at our meeting, we would not be comfortable with this as an enterprise strength solution. MySQL is unsupported freeware No it isn't, both MySQL AB (and NuSphere?) provide commercial-grade support. Given that the top level of MySQL AB support involves direct

Re: BDB and InnoDB in windows nt versions

2001-08-16 Thread Heikki Tuuri
Sinisa, there is no separate Windows distribution of -Max :). From the -Max page: Note: The MySQL 3.23.38 (and newer) distribution for Windows includes both the normal MySQL and MySQL-Max binaries. Regards, Heikki Sinisa writes: . Bruce Scharlau writes: Hi all, I'm

even weirder case issues

2001-08-16 Thread Alex Pukinskis
My case sensitivity problem seems to have become even stranger. Basically, one case for the table (Employee) works to return data for certain rows, and the other (employee) works for other rows. This is unfortunately now breaking my program. Probably the easiest way to explain this is to show

Re: Downsides of MySQL?

2001-08-16 Thread Steve Edberg
Urgh...I've been fortunate enough to avoid things like this myself until recently, when some of my PHP/MySQL/Apache stuff is getting tossed out in favor of Cold Fusion/MS-SQL Server/MS-IIS. Anyway, my 2c: At 8:35 AM -0500 8/16/01, Boget, Chris wrote: Good morning. Recently, we presented

Table corruption at MySQL 4.0.0 shutdown ?

2001-08-16 Thread Fournier Jocelyn [Presence-PC]
Hi, I noticed an annoying behaviour with MySQL 4.0.0. I have 11 tables with a lot of rows (about 1 Million and more) which are constantly updated by a php script. It seems after a shutdown of mysql (mysqladmin -uroot -p shutdown) and a restart, some tables are corrupted (and not the same, it

Re: Developing addons for MySQL

2001-08-16 Thread Sinisa Milivojevic
Mike Westmacott writes: Hi, I'm a researcher at the University of Southampton, and at some point I will need to develop a multidimensional database. Initially I was just going to write a very simple SQL server, and then I thought that it might be worth trying to write something for MySQL.

RE: aggressive dolphin?

2001-08-16 Thread Jay Fesco
snip ...I am somewhat disappointed that you chose the dolphin for your logo because of the good nature of this animal. ...dolphins seem to have murderous urges unrelated to the need for food’. /snip Theo, are you still irritated that the rest of us got our 'So Long and Thanks For All The Fish'

MySQL.org's position

2001-08-16 Thread Michael Widenius
Hi! Thanks Philippe for forwarding this to us: P == Philippe Paravicini [EMAIL PROTECTED] writes: P mySql.org's position (whomever they are) P *** P Dear Philippe: P mySQL.org is a not for profit organization dedicated to promoting P and further enhancing the mySQL database engine. Like

Downsides of MySQL?

2001-08-16 Thread nigel wood
The mySQL security model is also not sufficiently developed for any system that involves money. FUD. My company stores everything including encripted credit card details authorisation codes in a MyISAM database. while some careful work is required to get table locking right your

Re: @HOSTNAME@ ?

2001-08-16 Thread Philip Mak
On Thu, 16 Aug 2001, mysql wrote: @HOSTNAME@: command not found Does anyone know how to solve that ? I didn't find anything on the net or on the mysql.com homepage. You're getting that from support-files/mysql.server, yes? I've gotten that message too and was puzzled by it. I just replaced

[MySQL Replication failing]

2001-08-16 Thread bryan
Description: When trying to set up database replication servers I get the following errors in the error log : 010816 16:09:12 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 0 010816 16:09:12 Slave: reconnected to master '[EMAIL

Re: auto_increment vs. heap tables

2001-08-16 Thread Leos Bitto
Uh oh... Please NO. I want the standard _FAST_ auto_increment, not this. select max(id) from table x is terribly inefficient. And the table is locked during this operation... That's just not acceptable for me. Anyway, thanks for the response. It was the second one. Leos On Thu, 16 Aug 2001,

RE: Downsides of MySQL?

2001-08-16 Thread Ravi Raman
hi. scroll down a bit. the _comments_, to which i was referring, go all the way up to July 2001, which seems fairly relevant to me. and while the article is definitely dated, transaction support in mysql is still not-quite-stable, it still lacks subqueries, stored procedures, triggers and

Re: auto_increment vs. heap tables

2001-08-16 Thread Andrew Schmidt
good point. the only real way to duplicate auto increment logic is to create a new table with 1 row and 1 field. and lock, select, and update that row. thanks, -- Andrew - Original Message - From: Johnny Withers [EMAIL PROTECTED] To: 'Andrew Schmidt' [EMAIL PROTECTED] Sent: Thursday,

RE: Downsides of MySQL?

2001-08-16 Thread sean . odonnell
whoops, right you are, but if the average reader is like me, they'll read the main article , a comment or two , and bug out. The article itself is quite definately dated -Original Message- From: Ravi Raman [mailto:[EMAIL PROTECTED]] Sent: 16 August 2001 10:08 To: Sean O'Donnell;

Re: Downsides of MySQL?

2001-08-16 Thread David Turner
No offense but I've seen people on the list throwing replication around like MySQL has replication end of story. There's alot more to replication than just a master and a slave. What MySQL has is simple unidirectional replication. If you want advanced or bidirectional replication you'll have to

optimize on winnt

2001-08-16 Thread Heitzso
trying to setup an optimized system to comparison test MS SQL Server and mySQL. Database has a single 350M table with about a dozen columns. Initial comparison between the two engines is being done w/o index help. OS is WinNT, hardware is 1ghz processor and single hd with 512M RAM. We just

ColdFusion, talking to a mySQL database, on Solaris 7

2001-08-16 Thread Alex Cook
Hey all, I'm fighting to get ColdFusion 4.5.1 SP2 to talk to a mySQL DB on Solaris 7 using unixODBC/myODBC. anyone here tried this? I've gotten to the point where I can see the myODBC mySQL Driver in the CFIDE/adminstrator ODBC screen. I've added various entries to the CFHOME/odbc/odbc.ini,

-fno-exceptions and BSDI 4.0.1/gcc 2.7.2.1

2001-08-16 Thread Tuc
Hi, Having an issue trying to get the latest MYSQLs to compile on BSDI 4.0.1, with the default 2.7.2.1 GCC compiler. It appears there is an -fno-exceptions in the Makefile, that the version of GCC that ships with BSDI 4.0.1 doesn't grok. We are only building clients for 8 4.0.1

RE: Downsides of MySQL?

2001-08-16 Thread William R. Mussatto
Don't forget to include the intermediate software to cache connections since it takes so long to make an oracle connection. On Thu, 16 Aug 2001, Robinson, Mike wrote: Date: Thu, 16 Aug 2001 11:03:21 -0400 From: Robinson, Mike [EMAIL PROTECTED] To: 'Boget, Chris' [EMAIL PROTECTED],

lower_case_table_name has no effect on Linux

2001-08-16 Thread Geist Roland
Hi I am using mysql 3.23.30 under SuSE Linux 7.1. I tried to make my table names case insensitive by setting lower_case_table_names=1 but this had no effect. Even if the variable is set and a database as well as all tables are created new in lower case a select with an upper case name for a

RE: Downsides of MySQL?

2001-08-16 Thread Tyrone Mills
In my previous job supporting MSSQL at hospitals all across North America, Europe and Australia, Critical Incident support from M$, ranged from 36 hours to 4 days for a resolution. Often we solved it ourselves long before we had an answer from M$... Sad really... MySQL support is far superior,

Proper Case Conversion

2001-08-16 Thread Keith Spiller
Hello, I'm reading data from a mysql table that is entirely in uppercase letters. I'd very much like to convert them to lowercase. After searching a while, I found that there is are php commands to convert text strings between upper and lower case, but I was unable to find anything that can

ENCRYPT() issues (basic support#732)

2001-08-16 Thread Martin Bassie
Warning Could not process message with given Content-Type: multipart/mixed; boundary=part3b7c1428c5479

Re: auto_increment vs. heap tables

2001-08-16 Thread Eduardo J. Vega Arguedas
At 12:56 PM 8/16/2001, Andrew Schmidt wrote: Actually if you have a unique key on 'id' selecting max(id) is extremely fast. mysql uses the unique key to find the answer. I had a table with 137 million records each record ~ 156 bytes (including size of keys). there was a unique key on sess_id

[MySQL] Inserting images into a MySQL DB

2001-08-16 Thread Tim Thorburn
Hi, I'm attempting to store jpg images into a MySQL DB using PHP. I've found a few sample scripts that should do this for me, however, they don't seem to be working. Could someone take a look at this and see if you notice any problems? Thanks -Tim ?php if ($submit) {

Re: ENCRYPT() issues (basic support#732)

2001-08-16 Thread Sasha Pachev
On Thursday 16 August 2001 12:42, Martin Bassie wrote: This is a multi-part message in MIME format. --part3b7c1428c5479 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, We're working on system where credit card numbers need to be stored in an

html

2001-08-16 Thread Theo Richel
Is it possible to store html in Mysql-fields? Where can I find more info in this? Thanks Theo Richel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: Downsides of MySQL?

2001-08-16 Thread Michael T. Babcock
http://openacs.org/philosophy/why-not-mysql.html; This article is a year and a half old, quite a lot of its points, while valid at the time , simply are not relevant anymore. I'd like to point out that one of the authors of that paper E-mailed me saying that they recognise there have been

Re: Downsides of MySQL?

2001-08-16 Thread Jason McKnight
To the original poster: Is this a loaded question just to see what kind of response you might get? The application that requires a database server was not mentioned as far as I can tell, but that will influence your decision on what backend to choose. If you need every feature set under the sun

Re: [MySQL] Inserting images into a MySQL DB

2001-08-16 Thread Mark Maggelet
On Thu, 16 Aug 2001 14:11:59 -0500, Tim Thorburn ([EMAIL PROTECTED]) wrote: Hi, I'm attempting to store jpg images into a MySQL DB using PHP. I've found a few sample scripts that should do this for me, however, they don't seem to be working. Could someone take a look at this and see if you

Re: html

2001-08-16 Thread Gerald Jensen
Theo: Yes ... MySQL doesn't really care much what the data is you are storing. The best source for info is the MySQL manual (link below) ... you probably want top look at storing data in either TEXT or BLOB fields. Gerald Jensen - Original Message - From: Theo Richel [EMAIL PROTECTED]

Re: html

2001-08-16 Thread Philip Mak
On Thu, 16 Aug 2001, Theo Richel wrote: Is it possible to store html in Mysql-fields? Where can I find more info in this? Did you need MySQL to treat the HTML in some special way? I'm confused as to why you're asking this question. I would think that you can just use the TEXT data type to

Re: NuSphere final speaks out

2001-08-16 Thread Marten Mickos
Our customers have asked us to comment on the writing by Lorne Cooper in NuSphere's latest newsletter. I will respond to the three primary issues raised in the newsletter: (1) The June 2000 agreement between Progress and MySQL AB; (2) the mysql.org website; and (3) Gemini. For those of you

mysqladmin wasn't installed

2001-08-16 Thread Joe Mahma
Hi all, I installed the port of mysql3.23.36 on a FreeBSD machine I have done it before and it worked just fine, however this time everything was installed fine but the mysqladmin executable is no where on the system! Can I just get it out of the tar file and move it into /usr/local/bin? I

Configuring MySQL Korean language

2001-08-16 Thread Kim, Jonathan
Dear Colleagues, I am very new in MySQL and I just started a project of creating our church member database on Sun server with MySQL. Would someone please help me configuring MySQL for Korean language ? I also would like to get some detail information of how to interface client PCs to the

Re: Downsides of MySQL?

2001-08-16 Thread hooker
In my previous job supporting MSSQL at hospitals all across North America, Europe and Australia, Critical Incident support from M$, ranged from 36 hours to 4 days for a resolution. Often we solved it ourselves long before we had an answer from M$... Sad really... MySQL support is far

Fw: Reportwriters for mySQL

2001-08-16 Thread Garrick S. Louie
- Original Message - From: Garrick S. Louie To: MySQL List Sent: Wednesday, August 08, 2001 2:30 PM Subject: Reportwriters for mySQL I was wondering what GUI reportwriters worked with mySQL. I wanted to use a windows-based software for reporting and I know that Reportsmith and

MySQL-MAX 3.23.41 download link is dead... (need a download)

2001-08-16 Thread Jeremy Zawodny
The link here: http://www.mysql.com/downloads/mysql-max-3.23.html points here: http://www.mysql.com/Downloads/MySQL-Max-3.23/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz But that URL 404s. Does anyone have the latest 3.23.41 I could grab a copy of? Thanks, Jeremy -- Jeremy D. Zawodny,

Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))

2001-08-16 Thread Jeremy Zawodny
On Thu, Aug 16, 2001 at 06:00:16PM -0700, Jeremy Zawodny wrote: Does anyone have the latest 3.23.41 I could grab a copy of? I managed to fetch it from ftp.mysql.com. A copy is now available here as well: http://jeremy.zawodny.com/mysql/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz Thanks,

Re: MySQL-MAX 3.23.41 download link is dead... (need a download)

2001-08-16 Thread Fournier Jocelyn [Presence-PC]
Hi, Try : http://ftp.sunet.se/pub/unix/databases/relational/mysql/Downloads/MySQL-Max- 3.23/ http://ftp.sunet.se/pub/unix/databases/relational/mysql/Downloads/MySQL-Max- 3.23/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz Jocelyn Fournier Presence-PC - Original Message - From: Jeremy

Re: Downsides of MySQL?

2001-08-16 Thread jay downs
we at IOWNA Software Company would be happy to supply those outrageous fees if anyone is interested. Jay Downs Owner IOWNA Software Company [EMAIL PROTECTED] wrote: In my previous job supporting MSSQL at hospitals all across North America, Europe and Australia, Critical Incident support

Error in installing mysql

2001-08-16 Thread Denny
Hi, I am new to linux and i currently trying to install mysql on my redhat 7.1. I always got this error message at the end of the make Internal error: Segmentation fault.. I wonder if anyone would tell me what's going on? My machine is running on cyrix P133 with 32MB ram. Thanks, Denny

Re: Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))

2001-08-16 Thread Matt Wagner
Jeremy Zawodny writes: On Thu, Aug 16, 2001 at 06:00:16PM -0700, Jeremy Zawodny wrote: Does anyone have the latest 3.23.41 I could grab a copy of? I managed to fetch it from ftp.mysql.com. A copy is now available here as well:

MySQL Error: 1036 (Table 'tblHSBOYArticle_basic' is read only)

2001-08-16 Thread ÇóÊdz±
Hi. I'm a student from China. I have a problem of MYSQL under Linux. I just installed mysql under RedHat Linux 7.0 and I copyed the files of a database created by mysql under win2000 to /var/lib/mysql/database_name. But when I use the database through PHP, I found the tables are

Re: How does MySQL generate it's web based documentation

2001-08-16 Thread Jeremy Zawodny
On Thu, Aug 16, 2001 at 09:47:30AM +0100, David Herring wrote: Good morning, Does anyone have any details on the how the MySQL searchable documentation is produced. Is the content held in MySQL with PHP to produce the frontend pages - and is this something that can be applied generally

Re: Error in installing mysql

2001-08-16 Thread s. keeling
On Fri, Aug 17, 2001 at 10:51:17AM +0800, Denny wrote: I am new to linux and i currently trying to install mysql on my redhat 7.1. I always got this error message at the end of the make Internal error: Segmentation fault.. I wonder if anyone would tell me what's going on? My machine is

Re: Errcode: 2 when running LOAD DATA LOCAL INFILE on server

2001-08-16 Thread s. keeling
Post a couple of lines from your data file. Does .csv insist on all values single quoted? On Thu, Aug 16, 2001 at 09:03:36PM -0700, Yeong CN wrote: Hi. This is the script I write to upload a .csv file into my online mysql database : $sql_query=LOAD DATA LOCAL INFILE '$textfile' INTO

  1   2   >