Re: XML support under mySQL

On Fri, Feb 23, 2001 at 08:26:08AM +0100, Gorjan Todorovski wrote: > > To Ed: Why be so negative about adding new features to the DB > server? Why not make things easier and make the DB more flexible by > supporting more standards for TRANSPORTING data. I'm not Ed, but... The answer is simple: i

Re: XML support under mySQL

Gorjan, Don't you think it would be a better idea to comply with ANSI SQL92 before we start talking about adding features that are really not needed nor critical? Gorjan Todorovski wrote: > To Ed: Why be so negative about adding new features to the DB server? Why > not make things easier and ma

Re: aggregate UDF's

On Thu, Feb 22, 2001 at 12:39:41AM +0100, michi platzer wrote: > > i need to write my own very basic aggregate functions for MySQL and > had a couple of questions regarding this: > > * does anybody know of a site with a collection of UDF's written by other > MySQL user? Nope, sorry. > * i read

Re: XML support under mySQL

To Ed: Why be so negative about adding new features to the DB server? Why not make things easier and make the DB more flexible by supporting more standards for TRANSPORTING data. About the education I think that is not the problem here since the guy that posted the thing about XML support in mySQ

Re: indexing

On Fri, Feb 23, 2001 at 11:18:03AM +1300, Quentin Bennett wrote: > > Question: If you select and order by an indexed field, so that only > the index file is used, does the server still do a sort, or does the > data come out of the file pre-sorted? The index entries are sorted, so MySQL can simply

Re: Removing MySQL

On Thu, Feb 22, 2001 at 01:30:41PM +0200, Evan James Dembskey wrote: > Hi, > > How do you go about removing MySQL from a DEC Alpha box? Depends how/where it was installed. But you need to track down the relvant directories and remove them. I don't believe there is a `make uninstall' option...

Re: help! perl and MySQL Beginner Warning!

On Thu, Feb 22, 2001 at 02:16:56AM -0800, Thomas O'Neill wrote: > I have built a small guestbook using perl and MySQL > when i try to run my perl script i get the following error. > > Software error: > [Thu Feb 22 14:38:01 2001] DBI.pm: Can't locate DBI.pm in @INC (@INC > contains: /usr/lib/perl5

Re: The security concerns about MySQL

On Wed, Feb 21, 2001 at 04:02:50PM -0800, Abby Jiang wrote: > > I am planning to install an application program that use MySQL as > backend on our external server. There are other important database > server running on the server too. > > Does anyone know how secure the MySQL is? I trust it. :-

RE: Is sequencing possible in Mysql?

Basically you'd have a DB set up like this: hits_table main_table +--+ +-+ | id | (long int) <- | id | +--+ +-+ | num

Re: installing on linux

On Thu, Feb 22, 2001 at 06:29:47PM -0600, Mac Martine wrote: > hello- > > i just ran gunzip on the binary distribution i got from mysql.com ( > mysql-3.23.33.tar.gz ). > > The 'mysql_install_db' cannot be run because it has a '.sh' ending > on it. Actually many of the files in that same folder

Re: PROCESSLIST reschedule

On Thu, Feb 22, 2001 at 05:54:42PM -0800, Steven Roussey wrote: > > Hi, I searched all over, but I can not find out what the state > 'reschedule' means in the PROCESSLIST. I could hazard a guess based on the source from sql/sql_insert.cc: ---snip--- /* Let READ clients do something once in

Re: test condition

what conditions? please be specific in your questions, otherwise people wont want to help you :) On Fri, 23 Feb 2001, [gb2312] WANG_KING£¨Íõ¸Ö£© wrote: > How can I test conditions after lock table? > > Yours, > Sincerely > King Wang > Shanghai Huateng

Re: INSERT DELAYED crashes Mysql 3.23.33

I am using 3.23.33. I had posted a question asking for ways to improve my insert performance, and I got a reply asking to use DELAYED. I used it, but it seems like DELAYED takes twice the time a normal INSERT wud take. Anything I am missing? My table has 25 records and I am using DELETE FR

Re: RE: installing on linux

Tyrone Mills ([EMAIL PROTECTED]) writes: > The .sh designates that the file is a shell script. Linux doesn't do file > associations like windows does. You could call it anything, and as long as > it's an executable file, it'll run. CHMOD the files you need to run. That's not a wise idea. Instea

Re: i can not make two queries in C api..

Yopi Gagas Ilmiawan ([EMAIL PROTECTED]) writes: > I am pretty much new in mysql, I usually use PHP to connect to mysql.. > lately, I need C with Mysql, but i am not sucessfull in making two = > queries in mysql.. You might want to try the MyC API layer. It sits on top of the MySQL C API and loo

Re: i can not make two queries in C api..

On Fri, Feb 23, 2001 at 10:00:39AM +0700, Yopi Gagas Ilmiawan wrote: > Hello, > > I am pretty much new in mysql, I usually use PHP to connect to mysql.. > lately, I need C with Mysql, but i am not sucessfull in making two queries in mysql.. > > I hope someone will kindly tell me how to solve thi

Re: XML support under mySQL

Jim Gillaspy @ bellsouth.net ([EMAIL PROTECTED]) writes: > Actually, in a relational database, you do store metadata in the database, > along with the data it describes. Huh? Can you be more explicit? Maybe I'm not understanding what you're saying here... -- Ed Carp, N7EKG [EMAIL PROT

FW: [Fwd: Re: nesting tables]

I'm forwarding this to the list, as someone asked me on list today about this, and I can't find their post to respond to... > >Speaking as someone new with MySQL. I can see your point Ed about this > >being a general database question, but were do you draw the line? If > >the tool you are using

Re: RE: RE: XML support under mySQL

Cal Evans ([EMAIL PROTECTED]) writes: > Top of the morning to ya Aaron, > > 1: Ed did not suggest that everyone has to have a CS degree. Not defending > Ed because based on his posts this morning, someone pissed in his Cheerios > but he simply stated that people should be a little more educated

Binary distribution on FreeBSD4.0

Hi, Just wondering if anyone could help me out here? I have recently downloaded the binary distribution of mysql for FreeBSD (mysql- 3.23.32-unknown-freebsdelf4.2-i386.tar.gz). Now my problem is probably an easy fix but here goes. When I try and run scripts/mysql_install_db I get the err

i can not make two queries in C api..

Hello, I am pretty much new in mysql, I usually use PHP to connect to mysql.. lately, I need C with Mysql, but i am not sucessfull in making two queries in mysql.. I hope someone will kindly tell me how to solve this problem.. TIA Yopi

RE: installing on linux

The .sh designates that the file is a shell script. Linux doesn't do file associations like windows does. You could call it anything, and as long as it's an executable file, it'll run. CHMOD the files you need to run. -Original Message- From: Mac Martine [mailto:[EMAIL PROTECTED]] Sent: T

RE: Is sequencing possible in Mysql?

Hi, Yes that would be a better solution than to keep inserting a new record. However, you'll have to be careful with the concurrent update of the 2nd field ie if 2 process tries to update the same field at the same time etc. So locking table before update would help. > I have a table that has 2

installing on linux

hello- i just ran gunzip on the binary distribution i got from mysql.com ( mysql-3.23.33.tar.gz ). The 'mysql_install_db' cannot be run because it has a '.sh' ending on it. Actually many of the files in that same folder have a '.sh' ending. (mysql_install_db.sh) Why is this, and what do I do

Re: transaction

Yes it does. Read the manual and there is one in Chinese if you haven't already got it. - Original Message - From: "WANG_KING£¨Íõ¸Ö£©" <[EMAIL PROTECTED]> To: "Mysql (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, February 23, 2001 8:51 Subject: transaction > Does the newest version of mysq

Re: Quoting numbers? (was Re:MySQL Tables)

That's very true but these days, some languages/databases allow for strings to be assigned to numbers and vice versa without the need for conversion. PHP is one such language, not that I'm bagging it or anything as I use it myself. I just call it bad type checking. - Original Message - F

BUG: delayed_insert_timeout ignored

I'm using 3.23.30, and when I use delayed_insert_timeout set to 2000 (verified with show variables), I still see many threads that have much higher time values. They aren't dieing off like they used to. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e

PROCESSLIST reschedule

Hi, I searched all over, but I can not find out what the state 'reschedule' means in the PROCESSLIST. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - Before posting, please check: http://www.mysql.com/m

test condition

How can I test conditions after lock table? Yours, Sincerely King Wang Shanghai Huateng Software Systems Co, Ltd. 8/F, Wenxin United Press Tower, 755 Wei Hai Road, Shanghai 200041, P.R.C PH:32014500-5106 Email:[EMAIL PROTECTED]

RE: Web Host

Skip virtual hosting and go for a real dedicated server and you will be happier since you can put the exact MySQL software on it that you want. A dedicated server from Dellhost.com isn't much more expensive than shared and you get all the flexibility you could ever want at a nice price. They have

transaction

Does the newest version of mysql(3.23.32) support transaction? Yours, Sincerely King Wang Shanghai Huateng Software Systems Co, Ltd. 8/F, Wenxin United Press Tower, 755 Wei Hai Road, Shanghai 200041, P.R.C PH:32014500-5106 Email:[EMAIL PROTECTED]

Re: XML support under mySQL

Actually, in a relational database, you do store metadata in the database, along with the data it describes. - Original Message - From: "Ed Carp" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, February 22, 2001 7:18 AM Subject: Re: XML support under mySQL

Re: Mysql Table via php

On Thu, 22 Feb 2001, Joe and Nancy M wrote: > $query = "SELECT ID, PRICE, QTY > > FROM test > > where PRICE=3"; I would first of do this instead, your query otherwise looks good: $query = "select ID, PRICE, QTY " . "from test " . "where PRICE=3"; ... Atle --

RE: Keeping MySQL from listening to ports to connections

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 MySQL only listens on one port (3306). After getting a connection to port 3306, mySQL then opens another for data tranmission (all those ESTABLISHED entries in netstat). If you block 3306, no one can connect to your mySQL server. - --

Re: Query Question

First, you don't say how much memory your system has. If it has less than 500Meg, you should look into adding some. Mysql will slow down if has to run off swap space. Second, yes, that is a lot of rows for an old p2 to sift through. Do you need to search on all columns? if not, consider moving

Re: Installing client and shared RPMs

If my memory serves me correctly this was solved by fixing the rpms in 3.23.32-1. You mightr try the current version. Rus Rasmussen wrote: > Hello, > > I am trying to install the MySQL-client and MySQL-shard RPMs. I am not very > bright with this stuff so go easy on me. > > This is the error I

Re: Keeping MySQL from listening to ports to connections

Sorry, this post is not information, but I need to echo this question. We've got a firewall, but even if we wanted to open it up we can't because MySQL opens a whole slew of listening ports: why??? Why doesn't it just open one, well-defined port to listen on, i.e. 3306 or something? It makes it

Re: Web Host

http://www.communitech.net The QoS is very good and the price very cheap. On the other hand they don't upgrade their services very often. On the server I have my main account they are still using MySQL 3.22.*. BR, Fábio Ottolini - Original Message - From: "Alec Solway" <[EMAIL PROTECTED

RE: Keeping MySQL from listening to ports to connections

Hi, As far as I know you can make MySQL listen for Unix Socket connection (as well as TCP/IP connection). As to how much more secure Unix socket is to TCP/IP I really can't tell you. But again AFAIK, to connect to Unix socket you have to be on the same machine as MySQL server. So your Apps would h

Keeping MySQL from listening to ports to connections

Hello. I'm designing a MySQL server, but I want all connections to MySQL to be made by a server app. In other words, users communicate with the app through a port, and the app communicates with MySQL. The whole point of trying to do this is to keep MySQL from listening for connections on a port

RE: ReisserFS

Right, As far as *MySQL* goes I haven't noticed this in particular. That's because most mysql reads are indexed and use keys/caches. As far as general performance goes, I've definitely noticed it. (Creation/Deletion of large and large number of files is much, MUCH faster than ext2 - and reiserfs

Re: running safe_mysqld errors with "010222 17:25:00 mysqld ended"

Did that, figured out that I had root permissions on files in the data directory. I pushed by that and now I find that the file "/usr/local/mysql/libexec/mysqld cannot be found or executed". There is no libexec directory in /usr/local/mysql so, I'm not suprised. Is creating one and copying "mysqld

More Innobase questions (Was: RE: Innobase)

Good questions - I have a few more :) A) why does it seem to use fixed-size storage units. (The files) B) what happens when they ar full? C) can it auto-create new files as demand grows? D) can you safely add new files when there is data in them already? Regards, Sander > -Original Message

Re: ssh

ssh = Secure Shell http://www.ssh.org/faq.html On Thu, 22 Feb 2001, Karl Chen wrote: > I wonder what is ssh stand for. and what is benifit over telnet - Before posting, please check: http://www.mysql.com/manual.php (the

Re: SELECT * EXCEPT field1, field2

Jack Dempsey wrote: > > Hi all, > > I'm wondering if it's possible to do something like that select line in > the subject...often i want to select * but not one or two fields...i > found something about this in the to do list for mysql4.0, but i'm > guessing that's not exactly what i'm thinking.

Re: running safe_mysqld errors with "010222 17:25:00 mysqld ended"

check your error log in ~mysql/var On Thu, 22 Feb 2001, Matthew P. Marino wrote: > exact command is "./safe_mysqld --user=mysql &". The error "010222 17:25:00 > mysqld ended" happens immediately. > > - > Before posting, please

Web Host

Hi, Could someone please recommend a web host that has support for at the very least MySQL, C++ compiler (gcc), and an updated copy of glibc so I can properly compile and link programs written using the MySQL C API. I have been searching for a proper host.. for a very long time. Is there anyon

running safe_mysqld errors with "010222 17:25:00 mysqld ended"

exact command is "./safe_mysqld --user=mysql &". The error "010222 17:25:00 mysqld ended" happens immediately. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

SELECT * EXCEPT field1, field2

Hi all, I'm wondering if it's possible to do something like that select line in the subject...often i want to select * but not one or two fields...i found something about this in the to do list for mysql4.0, but i'm guessing that's not exactly what i'm thinking...is there an easy way to do this?

RE: indexing

Not sure how MySQL does it. I know in theory the database uses the index to find the records and then (if necessary) performs it's own sort. Clear as mud? Cal http://www.calevans.com -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 4:

Re: Hopefully Easy SQL Join Question

On Thu, 22 Feb 2001, Oson, Chris M. wrote: > Good Day All > > I have two tables... > > Table 1 > --- > MSRSectionID ContractID Heading > 1 > 1 107 Technical Progress: > 7107 Tec

RE: indexing

Question: If you select and order by an indexed field, so that only the index file is used, does the server still do a sort, or does the data come out of the file pre-sorted? Just wondering Quentin -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Friday, 23 February 2

Re: ssh

On Thu, 22 Feb 2001, Karl Chen wrote: > Date: Thu, 22 Feb 2001 12:30:25 -0800 > From: Karl Chen <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: ssh > > Hi everyone : > > I wonder what is ssh stand for . and what is benifit over telnet Secure Shell, the information is sent en

RE: Fields

What about varchar binary? On Thu, 22 Feb 2001, Johnny Withers wrote: > Date: Thu, 22 Feb 2001 13:35:44 -0600 > From: Johnny Withers <[EMAIL PROTECTED]> > To: Chris <[EMAIL PROTECTED]>, mysql <[EMAIL PROTECTED]> > Subject: RE: Fields > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > base

RE: indexing

Nope. ORDER BY determines how the result set is output. It has nothing to do with how MySQL finds the records. Cal http://www.calevans.com -Original Message- From: Adam C Buggia [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 2:53 PM To: Jason Landry Cc: [EMAIL PROTECTED]

New Software Search Engine -- List for FREE

Dear Marketing Manager: BigSoftE is pleased to invite to list its software products for FREE on the world's first Internet Software Search Engine. We encourage you to join nearly 10,000 software companies who are making it simple to attract software prospects on the Internet. Listing on BigS

Re: INSERT/REPLACE lock up in 3.23.33

> My troubles continue with INSERTs (i posted a message about INSERT > DELAYED crushing a server before). Now, I have this: We are running Linux and MySQL 3.23.30 and have similar problems. In particular we have a lot of INSERT DELAYEDs into a fixed table, and REPLACE DELAYED into a variable size

Re: Problem installing MySQL & php

At 19:25 22-2-01 +, Pope, Alan wrote: >Hi all, > >Newbie alert, please be gentle. Great resource: www.devshed.com including how to install MySQL and PHP with Apache. You might want to apply all the patches from Redhat. RH 7.0 is not considered to be a good distro. NOT my opinion, others sa

Re: indexing

I do use ORDER BY by meet_hnd DESC. In trying to optimize queries on this db, can I assume the following: In searching for a result on meet_hnd (which is indexed) using the ORDER BY clause not only affects the was the data is returned but also the method by which the results are searched on:

RE: indexing

Aer you not storing a date associated with each record?? If you're not, I'd highly recommend doing that, rather than just hoping that mysql will return the order of results the way you want it. Ordering by date should be pretty inefficient also. mysql returns the records in the order they were

Re: Turn off MySql Warning Messages

Hi, at a "@" before the command where you want to supress the error message: I.E. @mysql_connect("host",..); Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http:

Re: indexing

> I am the dba for a track and field results web site, when people look for > results they are most likely going to want results from a more recent meet > (rather than older meets). > > there is a table result and a table meet where a column in result is > "meet_hnd." (there maybe hundreds of resu

ssh

Hi everyone : I wonder what is ssh stand for . and what is benifit over telnet karl chen Programmer , Information System Department Valley Presbyterian Hospital Tel (818) 782-6600 ext. 5141

Re: ReisserFS

I have had the nulls in log-files/mail-files problem. This is with the latest kernels that have patches relating to this problem. I have been working with Cris (Rieser Programmer) daily to locate the problem I have had no other problems and enjoy t

Mysql Table via php

I finally got my ISP to resolve the issues with connecting to my db. I have a test table in the database named test. I have 3 fields; ID(20Char), PRICE(int),QTY(int). I am using php (this is what my ISP supports and suggested). I can connect using: I can draw the data out using this sample

Re: Fields

Thanks, But I have to import that field into an access DB, can I de-code base64 in access? I will have to try and find out. > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > base64 encode the encrypted text before storing it.. > > easily done in php > base64_encode(string); > > - --

RE: indexing

reHi Adam, If it is indexed then you are starting at the first match, not at the top. The only way it would start at the top is if you were doing a full table scan. My example was to show that once the field is indexed, you can fetch ASC or DESC at the same speed. Cal http://www.calevans.com -

Re: Exporting data from a MySQL database to an oracle database

Consider the Oracle migration work bench. http://otn.oracle.com/software/tech/migration/workbench/software_index.htm Joe.O'[EMAIL PROTECTED] wrote: > > Hi, > > I have a MySql database with customer information which is to be exported > to an oracle database. I was wondering if someone could tel

Re: problem

BRAD WEST wrote: > > Hello, > > I have just installed mysql and I get an error while trying to run it. > It says > ./bin/my_print_defaults: can't load libary "libz.so > It starts it and then ends mysql. > I am running BDSI 4.0.1. > I went throught the install commands and process and ev

RE: indexing

> Why do you need to build your index in descending order? I am the dba for a track and field results web site, when people look for results they are most likely going to want results from a more recent meet (rather than older meets). there is a table result and a table meet where a column i

Installing client and shared RPMs

Hello, I am trying to install the MySQL-client and MySQL-shard RPMs. I am not very bright with this stuff so go easy on me. This is the error I get when I try to do this: rpm -i MySQL-client-3.22.32-1.i386.rpm error: failed dependencies: /bin/sh is needed by MySQL-client-3.22.32-1

RE: Fields

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 base64 encode the encrypted text before storing it.. easily done in php base64_encode(string); - - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.954.9133 - -Original Message- From: Chris [mailto:[EMAIL PROTECT

INSERT/REPLACE lock up in 3.23.33

Hello! My troubles continue with INSERTs (i posted a message about INSERT DELAYED crushing a server before). Now, I have this: osiris:/root-> mysqladmin processlist ++--+---+---+-+--++---

Problem installing MySQL & php

Hi all, Newbie alert, please be gentle. My system is Redhat 7.0 with glibc-2.2-12, kernel 2.2.16-22. I have started a project which involves learning php & mysql, so I bought myself a couple of big books to sit down and do some learning! Problem is, I cannot get MySQL & php installed together

Re: indexing

what do you mean? if you're talking about ordering your query result in descending order you can do this: select * from table_name order by field1 desc Atle On Thu, 22 Feb 2001, Adam C Buggia wrote: > > > When is there going to be the ability to index in descending order? > > > > -

RE: indexing

Select verse from Bible order by sortOrder DESC; Reads the Bible in reverse order assuming the field sortOrder is book+chapter+verseNo Why do you need to build your index in descending order? Cal http://www.calevans.com -Original Message- From: Adam C Buggia [mailto:[EMAIL PROTECTED]]

Re: Turn off MySql Warning Messages

Well, this is a database interface (in this case, I assume PHP) question rather than a mysql question, but: Prepend the mysql_connect() with an @ sign to suppress error message reporting: @mysql_connect("localhost","root","") or die ("Server Currently Unavailable"); See the PHP

Re: So, what do you do with a "tarball" anyways.

"Matthew P. Marino" wrote: > > If you go to http://www.mysql.com/downloads/mysql-3.23.html, you will see the > binary(tarball) distributions. They don't end in .tar.gz but I supposed that was > a technical oversight. Of course I feel like a (_?_) (i.e dumb a**) not being > able to track down the

Re: So, what do you do with a "tarball" anyways.

If you go to http://www.mysql.com/downloads/mysql-3.23.html, you will see the binary(tarball) distributions. They don't end in .tar.gz but I supposed that was a technical oversight. Of course I feel like a (_?_) (i.e dumb a**) not being able to track down the right files. I blame HTML. I'm much mo

Information About Diferent Idioms Content

Hi all, We just developed a dinamic tourist information Portal, using PHP-My SQL. http://tampu.ucauca.edu.co Actually we are interested in providing the same information as it appears in spanish; in other languages like french, italian, english and german. We are looking for technological solution

Is sequencing possible in Mysql?

I read in the O'reilly book about sequencing but it only mentions msql. Can you do the same thing with Mysql? I have a table that has 2 fields. 1 is an auto-incrementing field the other is a profile id that is joined to some other tables to track how often a record was accessed. The way we are do

problem

Hello, I have just installed mysql and I get an error while trying to run it. It says ./bin/my_print_defaults: can't load libary "libz.so It starts it and then ends mysql. I am running BDSI 4.0.1. I went throught the install commands and process and everything installed fine. Did I mis

Hopefully Easy SQL Join Question

Good Day All I have two tables... Table 1 --- MSRSectionID ContractID Heading 1 1107 Technical Progress: 7107 Technical Problems: 13 107 Administrative Acti

Innobase

Hello mysql, Today I got a chance to compile mysql 3.23.34 with innobase, so althought it's not out yet I'll give some of my comments The version I'm speaking about got from work.mysql.com 1) It does not even configure then trying to configure --with-innobase-db the problem is autocon

RE: ReisserFS

I'd heard that even in general use, some users had a noticeable increase in disk reads/writes under ReiserFS...it sounds like you haven't experienced this (?). I'm thinking about moving over to ReiserFS as well, shortly, and am looking for as much feedback from people using it as possible... rega

Re: Suggestion For List Management

Actually, I have a message filter that looks for mysql.com in the "To or CC" portion of the header and moves any mail to my mySQL folder. Thus I can tell which messages are from mysql list members and which messages are from my supervisors. Still, it might be nice to add the [MYSQL] piece in the

indexing

When is there going to be the ability to index in descending order? Adam C Buggia DirectAthletics Inc. W: 978 927 7188 C: 781 608 5952 - Before posting, please check: http://www.mysql.com/manual.php

Re: double InnerJoin -how?

Hi. On Thu, Feb 22, 2001 at 03:50:22PM +0100, [EMAIL PROTECTED] wrote: > I have three tables: > one with contacts, > one with members, and > one that links the members to a group. > > How do I make a SQL-string, that gets the members from a specifik group, AND > the contacts that belongs to this

Re: Turn off MySql Warning Messages

At 11:28 AM 2/22/2001 -0600, samsom, debra wrote: >I would Like to Turn Off the following MySQL Connect Warning message. Any >Suggestions??? > >Warning: MySQL Connection Failed: Can't connect to MySQL server on >'localhost' (10061) in e:\program files\apache >group\apache\htdocs\dwg\dwg.php on l

abort in "configure"

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:Pascal de Marichalar >Organization: SIRIS >MySQL support: none >Synopsis: abort in "configure" >Severity: critical >Priority: high >Category: mysql >Class: support >Rele

Re: ReisserFS

On Thu, 22 Feb 2001, William R. Mussatto wrote: > What is the hardware (32 bit or 64) and what is the maximum files size > MySql will support on it? Thanks. I'm a mere end user when it comes to ReiserFS... I think you should be able to find all information you need on http://www.reiserfs.com/ A

Fields

Hi, Are there certain chacters that a VARCHAR field can't store? If I xor encrypt a #, I get non-alphanumeric characters: Ex: 123456789123 may end up 1 YdR
 Is this a problem to store properly, should I use a different field type other than varchar? Thanks, Chris

Turn off MySql Warning Messages

I would Like to Turn Off the following MySQL Connect Warning message. Any Suggestions??? Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' (10061) in e:\program files\apache group\apache\htdocs\dwg\dwg.php on line 22 Server Currently Unavailable This is the code t

Re: ReisserFS

RE ReiserFS What is the hardware (32 bit or 64) and what is the maximum files size MySql will support on it? Thanks. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Befor

Re: Suggestion For List Management

Hey - >Since a lot messages have undescriptive subjects ("Help", "Check This", >"What's This?", etc...) I think it would be a good idea to set up the >majordomo to add a tag to each subject line like the PHP list does. "[MYSQL] Help" is hardly more descriptive than "Help". My solution is to fi

Re: Suggestion For List Management

Jeff, This has been discussed before and I find it easier to just sort by the 'from' header in the message. Check the archives for more disscussion. Have a great day... John On Thursday 22 February 2001 06:08, Jeff Gannaway wrote: > Here's an idea for the list memebers and list master > >

RE: Suggestion For List Management

Well, you could filter anything sent or cc'ed to [EMAIL PROTECTED] into a separate folder -Original Message- From: Jeff Gannaway [mailto:[EMAIL PROTECTED]] Sent: 22 February 2001 11:08 To: [EMAIL PROTECTED] Subject: Suggestion For List Management Here's an idea for the list memebers

Re: Suggestion For List Management

¡Hola! [That's a recurrent theme in all mailing lists. Look in the archives the long answers] Yet again, no. Just learn to configure your MUA. HoraPe On Thu, Feb 22, 2001 at 11:08:06AM +, Jeff Gannaway wrote: > Here's an idea for the list memebers an

Re: ReisserFS

Jan-Aage Bruvoll writes: > On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: > > No, that is not just luck. > > > > ReiserFS is a journalling file system. > > Sure thing. The luck part was referring to the fact that even the > consistency in the tables was ok, which is more on the luck side,

Re: ReisserFS

On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: > No, that is not just luck. > > ReiserFS is a journalling file system. Sure thing. The luck part was referring to the fact that even the consistency in the tables was ok, which is more on the luck side, since all buffers were flushed at the time of

  1   2   >