Compatability with Microsoft Access

2001-02-22 Thread cmcclan
Hello, My objective is to be able to access a "Microsoft Access" database, using ASP scripts on a Linux Apache server. Can I achieve database connectivity with an Access.mdb file localy on a Linux box using mySQL - i.e WITHOUT using some sort of ODBC bridging software. If there is a

help! perl and MySQL Beginner Warning!

2001-02-22 Thread Thomas O'Neill
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/5.00503/i386-linux /usr/lib/perl5/5.00503

Copying a ddatabase from one server to another

2001-02-22 Thread Jeff Gannaway
Here's my situation I've been hosting my sites with one company for over a year and am now moving to a dedicated server operated by the same company. My existing database is large, containing around a dozen tables and over 5,000 entries. I want to copy the database structure and data to

Re: web based admin?

2001-02-22 Thread John Jensen
Do you have a remote server? Do you have a lot of data to enter into your database? Ask yourself: Would you rather preface each and every insert with "INSERT [data] INTO [table.column] ...", than enter data by filling in blanks in a webform. Do you want to correct typos or otherwise

RE: help! perl and MySQL Beginner Warning!

2001-02-22 Thread Barry Radloff
Hi Thomas well it may be that the install put it in another directory other than in the ones listed below I too am a bit of a beginner with perl and mysql but I found my DBI stuff in another dir so I used the following in my perl script use lib "dir/path/here/to/libs"; This tells perl to look

Re: + or - in place of = does what???

2001-02-22 Thread Benjamin Pflugmann
Hi. WHERE expects a boolean expression, but user_num+"AL011-33" is no boolean expression. MySQL therefore assumes that the result of the expression should be considered as boolean value. Analogous to C and similar languages, it assumes the expression to be 'false', if it is zero (numbers) or

RE: case sensitive selects

2001-02-22 Thread Carsten H. Pedersen
A comparison will be case sensitivie, if any sub-part of the expression is case sensitive. There are several ways to solve this: 1) CREATE or ALTER your tables so that the relevant CHAR and VARCHAR fields are of type BINARY; change TEXTs to BLOBs 2) Use a case-sensitive, but neutral function

Re: MySQL and JDBC: Communication link failure

2001-02-22 Thread Guenther Pewny
Try a) downgrading an _older_ mm.mysql driver, or, much better: b) upgrading to a newer (and non-alpha) mySQL database version. I've had exactly this problem every time I upgraded to a new mySQL version. Upgrading the driver, too, solved the problem in each case. For example, currently

Re : Question???

2001-02-22 Thread edith
Dear Sir/Madam, I'm a Visual FoxPro programmer. I want to use MySQL database for my programs. However, I cannot update MySQL database with my Visual FoxPro programs through ODBC (but I can view the record of table). My commands are as follow: CREATE CONNECTION conn1 DATASOURCE

RE: XML support under mySQL

2001-02-22 Thread Opec Kemp \( Ozemail \)
*big snip* I agree with Cal, the XML module should really be sperated from the RDMB. XML is really great but, lets face it not everyone is going to use it so why force it down thier troat?. The really great thing about Open Source is that you do have a choice (unlike MS , Oracle). :) You have to

Re: RE: XML support under mySQL

2001-02-22 Thread Ed Carp
Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes: Some relational databases return results in XML format. And operating systems have been written in Java and Perl. So? Just because you *can* doesn't mean you *should*. Suppose I want to translate the output to something else. Now

Re: Youch!

2001-02-22 Thread John Jensen
Thank you. Re: On 21 Feb 2001, at 16:29, Atle Veka wrote: where's your mysqld located? /usr/local/mysql/bin just change your safe_mysql script to contain the correct location of your mysqld binary. I thought that was what I was doing with "bin/safe_mysqld " from /usr/local/mysql/ I

Problems on creating table

2001-02-22 Thread Pui Yin LEE [AP]
Dear Sir/ Madam, I'm using mySQL GUI Win32 to create a database. I managed to create a database but not a new table. What I did was that I created a database by using function Commands:Administration:Database:Create, and then I selected the database name from the database button(the one

problems relating DATE and LOAD DATA INFILE

2001-02-22 Thread altay ozaygen
hello everybody, I am a newbie to database. I have two quetions, 1- I am using MySQL which I intalled with the Mandrake 7.2. I have lots of data in txt file format with a date field having a configuration like dd/mm/ and I have to use it in that format. but MySQL have a /mm/dd how can I

Access to Mysql ?

2001-02-22 Thread Christophe Suire
Hi, I would like to transform an Access database to a MySQL database .. I think there is no problem with doing an export of Access in CSV and an import in MySQL... The problem is .. in the Access db there some OLE Object which are images .. how to put them in the MySQL db ? Thanks. --

Re: Copying a ddatabase from one server to another

2001-02-22 Thread Guenther Pewny
Jeff Gannaway wrote: mysqldump -uUSERNAME -pPASSWORD database dbBackup.sql and it created the dump file. I transferred it to the new server then tried to load it into my new database using the following command: mysqldump -uUSERNAME -pMILLER31 database dbBackup.sql Don't take

synopsis of the problem (one line)

2001-02-22 Thread root
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

Linuux with mysql and c++ API

2001-02-22 Thread Jarle Rudihagen
Linux with mysql and c++API I'am trying to connect to an Mysql database trough c++ API (1.7.8) The program compiles just fine but when i try to run it I get the message Segmentation fault core dump When I try to run the program with the strace command I can see that the program connects to

Mysql PID Problem?

2001-02-22 Thread Weber, Jeff
Having problems starting mysql on my linux box. I think I've tried just about everything in the manual within reason. Please help out if anyone has an idea. The other day, mysql died on my system for no apparent reason. When I reboot the machine, based on the script in /etc/rc.d/init.d/mysql,

Re: Future suggestion

2001-02-22 Thread Jason Landry
Also, specifying fields won't break things when people add fields to a table. Yeah, but you already have the same problem with SELECT *. Let me give another example. You have a table with 15 rows. One of those rows is TEXT. You really do want everything except the text. Doesn't anyone

Help me

2001-02-22 Thread Esko Lehtme
Hello I'm working out a programm what generates page visiting statistics, to help me to go http://www.seitse.ee and click some links. With best regards Esko - Before posting, please check: http://www.mysql.com/manual.php

Transactions in 3.23.33 ?

2001-02-22 Thread Bruce Percy
Has transaction management present in the 3.23.33 binary distribution of MySQL? When creating BDB tables and trying to use them inside transactions I fail to get them to work. There's no error messages and the transactions seem to be ignored. I've tried this on Linux and NT. -- Bruce Percy

mySQL Lock Problem

2001-02-22 Thread myfriend4ever.com
hi, I like to write a multi-user program in internet by using mysql, do i need to use lock function to lock the table before i write or update anything to the table ? but some manual say we use it for maintenance purpose, is it right ? then how mysql handle the locking under multi-user

Youch!

2001-02-22 Thread John Jensen
I had shut down the mysql daemon using: bin/mysql -u root -p[password] shutdown Now when I attempt to restart it using: bin/safe_mysql it gives me the message: [1] 2564 The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

maximum number of characters

2001-02-22 Thread Matt Davis
Hi Can anybody tell me what the maximum number of characters I can have in one field. Thanks Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Problems with splitting data across different disks under Windows...

2001-02-22 Thread Patrick FICHE
Hi, I'm working under Windows 98 with MySQL version 3.23.29. I tried to connect to a database that is on a different disk from the data directory (g:\mysql\data). So I created a file g:\mysql\data\pfi.sym containing the path e:\databases\pfi. I compiled with the USE_SYMDIR option and launched

Re: maximum number of characters

2001-02-22 Thread Peter Skipworth
Matt, Before posting to a mailing list, you should ensure you RTFM! Have a look at www.mysql.com and you'll find tha answers in the documentation. regards, P On Thu, 22 Feb 2001, Matt Davis wrote: Hi Can anybody tell me what the maximum number of characters I can have in one field.

Re: ranking album plays by city, help me beat Oracle

2001-02-22 Thread Benjamin Pflugmann
Hello. On Tue, Feb 20, 2001 at 03:27:08PM -0800, [EMAIL PROTECTED] wrote: Huh? You got it 7 times faster by only extracting that query from the for loop and changing it to a group by? Or did you do anything else? Sorry there were some other unnecessary queries that were mistakenly in the

Re: Connecting via MyODBC always brings up the TDX mysql Driver Connect dialog

2001-02-22 Thread Pat Sherrill
Make sure you also have at least a user (and password as appropriate) filled out in the MyODBC Control Panel. Pat... [EMAIL PROTECTED] - Original Message - From: "Jan R Andersson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 21, 2001 10:22 AM Subject: Connecting via

Problem compiling...

2001-02-22 Thread Cyril ZEKSER
Hi all, I've a little problem at the linking stage. I've always have the following error : g++ -g -o mainTest mainTest.o worldFactory.o -L/usr/local/OpenInventor26/lib -limage -lInventor -lInventorXt -L/usr/lib/mysql -lmysqlclient -lsqlplus -lpthread -L/usr/X11R6/lib -lX11 -lGL -lGLU -lGLw

nesting tables

2001-02-22 Thread revathi venkatraman
Sir, Is there this concept of nesting tables and varrays in mysql?. Iam creating a chemical compounds database. there are 20 field in this . Amongst them, I have a author field where there are multiple authors, amongst which one is common for all the records. suppose I query giving the

Removing MySQL

2001-02-22 Thread Evan James Dembskey
Hi, How do you go about removing MySQL from a DEC Alpha box? Regards, Evan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: nesting tables

2001-02-22 Thread Rolf Hopkins
What do you mean by "nesting tables" and "varrays"? What you have described is known as relational databases and a good idea would be to buy a good book on Relational Database Management Systems. - Original Message - From: "revathi venkatraman" [EMAIL PROTECTED] To: [EMAIL PROTECTED]

Re: XML support under mySQL

2001-02-22 Thread Michael Bacarella
XML will become a common and powerful way to express/exchange data on the web. I hope MySQL decides to go along for the ride. This is all fine and good, but why does MySQL itself have to do this? We don't want Microsoft and Oracle to take over the world, do we? :) Their

Re: Compatability with Microsoft Access

2001-02-22 Thread Rolf Hopkins
Check out www.devshed.com. Right now it has a very good article on what you want. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 16:15 Subject: Compatability with Microsoft Access Hello, My objective is to be able to access a

Exporting data from a MySQL database to an oracle database

2001-02-22 Thread Joe . O'Toole
Hi, I have a MySql database with customer information which is to be exported to an oracle database. I was wondering if someone could tell me the easiest way of doing this. Is there any such applications which look after the exporting of the data from the MySql database and importing to the new

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

2001-02-22 Thread Steve Ruby
"Matthew P. Marino" wrote: So, what do you do with a "tarball" anyways. Since compiling the source is hopless( "sql_yacc.cc"), I'm looking for a binary. then download the binary.. Or at least do a better job of describing your problem...

Re: Error when writing a sql statement into a field.

2001-02-22 Thread Ken Yiem
Hi , notice your last field in the Values section. 'query += "\"" + this.customerId + "\",";' get rid of the comma at the end. end replace it with a close'n bracket. notice the last field, you have one extra field in the values bracket.

mysqldump output file not valid as input file for mysql client

2001-02-22 Thread loschert
Description: As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: --opt --all-databases) creates a file which will not be uploaded correctly using the mysql client (as in: 'mysql -u root -pXX -q -s dumpfile.sql'). Specifically, the

Re: Transaction

2001-02-22 Thread Rolf Hopkins
- Original Message - From: "WANG_KING£¨Íõ¸Ö£©" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 13:51 Subject: Transaction Does the newest version of mysql support transaction ? Sure does. How does you solve your data integrity problem in your appliacation?

Re: BDB Problem with MAX() and multipart primary keys

2001-02-22 Thread Sinisa Milivojevic
Guenther Pewny writes: Hi folks, I have a problem with BDB tables. Please look at this short mysql session: mysql create table sample ( id1 int(8) not null, id2 int(8) not null, primary key (id1,id2)) type=BDB; Query OK, 0 rows affected (0.67 sec) mysql

Re: problem with blob

2001-02-22 Thread Jay Brushett
Hi again. Just thought that I'd repost my message cause I think nobody was checking their mail when I first posted it. Not rying to spam or anything I just really need to figure this out. Thanks, Jay (see post below) At 07:45 AM 2/21/2001 +00-03, Jay Brushett wrote: Hi, I'm new to MySQL

Re: Linuux with mysql and c++ API

2001-02-22 Thread Sinisa Milivojevic
Jarle Rudihagen writes: Linux with mysql and c++API I'am trying to connect to an Mysql database trough c++ API (1.7.8) The program compiles just fine but when i try to run it I get the message Segmentation fault core dump When I try to run the program with the strace command I

Re: Auto-Inc question

2001-02-22 Thread Ed Carp
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes: Hi, I have a table which contains a row called ListID which is set to auto increment, I added a load of test data into the table while I built my website so I could test various things out, anyway that is all finished now and I am ready to

Re: nesting tables

2001-02-22 Thread Ed Carp
revathi venkatraman ([EMAIL PROTECTED]) writes: Sir, Is there this concept of nesting tables and varrays in mysql?. Iam creating a chemical compounds database. there are 20 field in this . Amongst them, I have a author field where there are multiple authors, amongst which one is

Myisamchk unable to repair index problem

2001-02-22 Thread filip . sergeys
running myisamchk against basic table gives this error : stopword doesn't have a correct index definition. you need to recreate it before you can do a repair. table details: create table stopword(word char(32) DEFAULT '' NOT NULL, lang char(2) DEFAULT '' NOT NULL, PRIMARY KEY (word, lang));

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

2001-02-22 Thread Ed Carp
Joe.O'[EMAIL PROTECTED] (Joe.O'[EMAIL PROTECTED]) writes: I have a MySql database with customer information which is to be exported to an oracle database. I was wondering if someone could tell me the easiest way of doing this. Is there any such applications which look after the exporting of

Oddity with date subtraction - bug?

2001-02-22 Thread Basil Hussain
Hi all, I recently did a query to subtract one DATETIME column from another, but I got odd results for one row and correct results for others. These queries expand upon what I was doing: mysql SELECT impression, click, click - impression AS diff, DATE_SUB(click, INTERVAL click - impression

Re: mysqldump output file not valid as input file for mysql client

2001-02-22 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: Description: As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: --opt --all-databases) creates a file which will not be uploaded correctly using the mysql client (as in: 'mysql -u root -pXX -q -s

Re: Specification of the MySQL Server/Client protocol

2001-02-22 Thread Sinisa Milivojevic
Wittens writes: Hello, Perhaps you can call me stupid or just blind, but I can't find a specification of the MySQL Server/Client protocol anywhere... I need it to implement a simple, lightweight MySQL client for mIRC (so using MySQL++/libmysql is out of the question). Is there

Re: Compile Problem

2001-02-22 Thread Sinisa Milivojevic
Alec Solway writes: Hi, I am getting the following errore when trying to link the MySQL client library with a C++ program I have written. /usr/local/mysql/lib/libmysqlclient.a(my_open.o): In function `my_open': my_open.o(.text+0x14): undefined reference to `open64'

Re: Mysql++ problems

2001-02-22 Thread Sinisa Milivojevic
sas writes: HI. When I was trying to include the "custon.hh" header file, I got some error messages like this. gcc -lsqlplus -I/usr/include -I/usr/include/mysql -L/usr/lib -o test3 test3.cc In file included from /usr/include/custom.hh:71, from test3.cc:5:

Re: Problems on creating table

2001-02-22 Thread Sinisa Milivojevic
Pui Yin LEE [AP] writes: Dear Sir/ Madam, I'm using mySQL GUI Win32 to create a database. I managed to create a database but not a new table. What I did was that I created a database by using function Commands:Administration:Database:Create, and then I selected the database

RE: XML support under mySQL

2001-02-22 Thread Mehalick, Richard RE SSI-GRAX
Yes, Ed is correct. You store data, but it is the trasport of that data that makes XML look good. To me, using XML to transport the data is like using recordsets in Microsoft/ADO. - / Rick Mehalick Senior Consultant / Shell Services

RE: RE: XML support under mySQL

2001-02-22 Thread Aaron Weiker
For some reason I don't think this was understood of what I said earlier. THE "DATABASE" ISN'T RESPONSIBLE FOR XML But, just because the database isn't responsible doesn't mean that the application is responsible for generating XML. Due to the fact I don't have my computer science degree like

Re: HELP!!

2001-02-22 Thread Jack Rhinesmith
elaine; Put the escape character in front of it (/') jack :-)= - Original Message - From: "Elaine Silva" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 21, 2001 6:17 PM Subject: HELP!! Please, How can i insert the "'" character (like

Re: Linuux with mysql and c++ API

2001-02-22 Thread Jarle Rudihagen
Thank you for the quick answer, Sinisa Milivojevic. I had som trouble getting the mysql++ API working. I tried both binary and source distribution and finally today: It works I got another source distibution and after a clean compilation it worked. Thanks! Hilsen Jarle - Original

Re: mysqldump output file not valid as input file for mysql client

2001-02-22 Thread Matt Loschert
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: [EMAIL PROTECTED] writes: Description: As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: --opt --all-databases) creates a file which will not be uploaded correctly using the mysql client

RE: RE: XML support under mySQL

2001-02-22 Thread Cal Evans
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 about the subject before posting. 2: The

Re: mysqldump output file not valid as input file for mysql client

2001-02-22 Thread Sinisa Milivojevic
Matt Loschert writes: On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: [EMAIL PROTECTED] writes: Description: As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: --opt --all-databases) creates a file which will not be uploaded

Suport of cirilic-???

2001-02-22 Thread Anatolii_s
Dear support group of MySQL, I want thank you for this good (best) SQL server. But when I use MySQL for Windows with languages like Ukrainian, Rassian I can't use case insensitive select, or operator like Upper. Can you help me? Sincerely, Anatolii.

Re: mysqldump output file not valid as input file for mysql client

2001-02-22 Thread Matt Loschert
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: Matt Loschert writes: On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: [EMAIL PROTECTED] writes: Description: As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: --opt

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

2001-02-22 Thread Julian Strickland
It's all to do with data types, traditionally and across most languages quotes are used to delimit STRINGS and a string is NOT a number although may represent one when displayed. -Original Message- From: Pete Harlan [SMTP:[EMAIL PROTECTED]] Sent: 21 February 2001 20:51 To: [EMAIL

RE: Printed MySQL manual

2001-02-22 Thread Julian Strickland
The distributions come with a text version of the manual so you can download one and print it yourself but beware it is rather large. -Original Message- From: Thalis A. Kalfigopoulos [SMTP:[EMAIL PROTECTED]] Sent: 21 February 2001 21:05 To: [EMAIL PROTECTED] Subject: Re:

Re: Cannot connect to local mySQL server through socket error (111)

2001-02-22 Thread Gerald L. Clark
Chuang Keng Chee wrote: Hi! Socket file specified is : /var/lib/mysql/mysql.sock which on my system has a filesize of zero. I'm running a Red Hat 7.0, Kernel 2.2.16-22smp which I installed with MySQL (ie, MySQL wasn't installed separately from source files.) I've got three

double InnerJoin -how?

2001-02-22 Thread Henrik Lebtien Mohr
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 group as well? Won't I have to make a double InnerJoin? Kind regards, /Henrik Mohr

Re: Oddity with date subtraction - bug?

2001-02-22 Thread Gerald L. Clark
Basil Hussain wrote: Hi all, I recently did a query to subtract one DATETIME column from another, but I got odd results for one row and correct results for others. These queries expand upon what I was doing: mysql SELECT impression, click, click - impression AS diff, DATE_SUB(click,

synopsis of the problem (one line)

2001-02-22 Thread root
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

Sorry, delay in MySQL/Innobase distribution

2001-02-22 Thread Heikki Tuuri
Hi, readers of the mailing list! Sorry, we were not yet able to roll a distribution of MySQL-3.23.3x/Innobase yesterday. Monty is now traveling in South America for a week, and the distribution will take still some time. Currently, MySQL/Innobase runs on Win NT, Linux Intel, Linux Compaq Alpha

ReisserFS

2001-02-22 Thread Simon Windsor
Hi Has anyone user MySql on a ReisserFS file system ? Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? Thanks Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700720 Fax: +44 (0) 1249 700725 Email:

Re: Oddity with date subtraction - bug?

2001-02-22 Thread Basil Hussain
Hi, mysql SELECT impression, click, click - impression AS diff, DATE_SUB(click, INTERVAL click - impression SECOND) AS calc FROM eventlog; +-+-+--+-+ | impression | click | diff | calc|

OLE DB Provider?

2001-02-22 Thread Lee Jenkins
Hello everyone, I was wondering if the folks at MySQL were considering developing an OLE DB provider. I ask because, including myself, there seems to be quite a large number of developers who traditionally used MS DB products, moving over MySQL for many applications. Don't get me wrong, using

Re: BDB Problem with MAX() and multipart primary keys

2001-02-22 Thread Guenther Pewny
It's a miracle. Which version of the BDB patch do you use? I'm using 3.2.9a. (Previously, there has been a version 3.2.3g...) Thanks... Gnther Pewny Sinisa Milivojevic wrote: Guenther Pewny writes: Hi folks, I have a problem with BDB tables. Please look at this short mysql session:

INSERT DELAYED crashes Mysql 3.23.33

2001-02-22 Thread Artem Koutchine
Hi! I am trying to insert 1 000 000 records into a very simple table: create table test ( a1 tinyint unsigned not null, a2 tinyint unsigned not null, a3 tinyint unsigned not null, a4 tinyint unsigned not null, primary key (a1,a2,a3,a4) ); So, to make it

Re: ReisserFS

2001-02-22 Thread Jan-Aage Bruvoll
On Thu, 22 Feb 2001, Simon Windsor wrote: Has anyone user MySql on a ReisserFS file system ? Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? No problems at all. Even power outages and severe crashes did not touch the MySQL stuff on the

Re: Auto-Inc question

2001-02-22 Thread Website4S
In a message dated 22/02/2001 12:22:26 GMT Standard Time, [EMAIL PROTECTED] writes: 30 seconds work(less time than it took you to type your email) would've revealed the answer: 1. Click on "the manual" link at the bottom of this message. 2. See the search box? Type in "auto increment".

Re: Oddity with date subtraction - bug?

2001-02-22 Thread Gerald L. Clark
Basil Hussain wrote: Hi, mysql SELECT impression, click, click - impression AS diff, DATE_SUB(click, INTERVAL click - impression SECOND) AS calc FROM eventlog; +-+-+--+-+ | impression | click |

Suggestion For List Management

2001-02-22 Thread Jeff Gannaway
Here's an idea for the list memebers and list master 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. For instance Subj: Help

Re: ReisserFS

2001-02-22 Thread Jeremy D. Zawodny
On Thu, Feb 22, 2001 at 03:22:13PM +, Simon Windsor wrote: Hi Has anyone user MySql on a ReisserFS file system ? Yes. Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? It "just works". :-) -- Jeremy D. Zawodny, [EMAIL PROTECTED]

Re: Transactions in 3.23.33 ?

2001-02-22 Thread Guenther Pewny
AFAIK, the 3.23.33 binaries don't include the BDB table handler - you have to build mysql from source after unpacking the BDB module into your mysql source tree. On the other hand, I've read that the 3.23.34 version (it should be online these days) has BDB _and_ INNOBASE integrated. As posted

MySQL

2001-02-22 Thread Gupta, Sanjeev
Hi Is there any way when i just copy the service file and other related file to run mysql instead of installing fully on my system. Thanks sanjeev -Original Message- From: Simon Windsor [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 10:22 AM To: [EMAIL PROTECTED] Subject:

Re: BDB Problem with MAX() and multipart primary keys

2001-02-22 Thread Sinisa Milivojevic
Guenther Pewny writes: It's a miracle. Which version of the BDB patch do you use? I'm using 3.2.9a. (Previously, there has been a version 3.2.3g...) Thanks... Gnther Pewny Hi! I used latest source tarball from our 3.23 page. Regards, Sinisa __ _

RE: ReisserFS

2001-02-22 Thread Sander Pilon
-Original Message- From: Simon Windsor [mailto:[EMAIL PROTECTED]] Sent: 22 February 2001 16:22 To: [EMAIL PROTECTED] Subject: ReisserFS Hi Has anyone user MySql on a ReisserFS file system ? Where any problems encountered ? and do you have any pearls of wisdom that you are

RE: ReisserFS

2001-02-22 Thread Gupta, Sanjeev
Hi, Is any body knows that is there nay way to use mySQL with out installing it fully. I mean to say just install service manager and other required drivers. Or can somebody let me know that what are the minium service require from mysql setup to run the mySQL server to win NT. Sanjeev

Re: ReisserFS

2001-02-22 Thread Sinisa Milivojevic
Jan-Aage Bruvoll writes: On Thu, 22 Feb 2001, Simon Windsor wrote: No problems at all. Even power outages and severe crashes did not touch the MySQL stuff on the ReiserFS file system, but that's probably all luck. :-) Regards, Jan No, that is not just luck. ReiserFS is

Re: ReisserFS

2001-02-22 Thread Jan-Aage Bruvoll
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

Re: ReisserFS

2001-02-22 Thread Sinisa Milivojevic
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, since

Re: Suggestion For List Management

2001-02-22 Thread horape
¡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

RE: Suggestion For List Management

2001-02-22 Thread Jon Haworth
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

Re: Suggestion For List Management

2001-02-22 Thread John Cichy
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

2001-02-22 Thread Quickling
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

Re: ReisserFS

2001-02-22 Thread William R. Mussatto
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 -

Fields

2001-02-22 Thread Chris
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

Re: ReisserFS

2001-02-22 Thread Jan-Aage Bruvoll
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/ As

abort in configure

2001-02-22 Thread pdemarichalar
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Pascal de Marichalar Organization: SIRIS MySQL support: none Synopsis: abort in "configure" Severity: critical Priority: high Category: mysql Class: support

Re: Turn off MySql Warning Messages

2001-02-22 Thread Scott Baker
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 line

Re: double InnerJoin -how?

2001-02-22 Thread Benjamin Pflugmann
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 group

indexing

2001-02-22 Thread Adam C Buggia
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:

Re: Suggestion For List Management

2001-02-22 Thread Ron Beck
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

RE: ReisserFS

2001-02-22 Thread Peter Skipworth
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...

  1   2   >