Calculate HEAP-size

2002-02-28 Thread Mathias Johansson
Hi, Does anyone got information regarding my question about calculating a HEAP table size in MySQL?: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:98013 Thank you, Mathias ___ Spara filer på nätet. Lagra upp till 500 Mb på Passagen http:/

Inserting records from Access creates Automation Error

2002-02-28 Thread Alexander Shaw
Hi all, I have an application that is running under Access 2000 connected to a MySQL backend (3.23.46) via ODBC 3.51. Currently I'm trying to run a query and then scroll through the results inserting into a table via the ODBC link. All is well with the fields which contain numbers, but the longe

Re: MyODBC or some other C based API for speed?

2002-02-28 Thread Arjen Lentz
Hi Wilbur, On Fri, 2002-03-01 at 13:28, Wilbur Streett wrote: > I'm working on indexing words in web pages, and I'm finding a significant > issue with the performance of MyODBC, even when I resort to using batch > mode inserts.. > > I'm currently using the older version of MyODBC, and basically

How to get books/manuals from Internet.

2002-02-28 Thread jyzhou
Hi, all How to get the e-books of My SQL via download. Thanks , Dominic ZHOU - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

get MySQL db size

2002-02-28 Thread Li, Robert
Hi, all MySQL team How can we get MySQL database size? Robert Li Computer Associates R&D Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] - Before posting, please

Enable iscii in mysql

2002-02-28 Thread Uma Shankari T.
Hello, For enabling the iscii in bash we will give export LC_CTYPE=iso_8859_1 For enabling the iscii in mysql is there any setting is there... Anyone came to know this please tell me... - Before posting, pleas

Select 8 bit

2002-02-28 Thread Uma Shankari T.
Hello, I need one help.To enable 8 bit language in bash we are exporting like this # For 8 bit Language support export LC_CTYPE=iso_8859_1 # For less to support 8 bit chars export LESSCHARSET=latin1 I am using local language for inserting values in mysql.While sorting in mysql is che

Re: Geographical MySQL Usage

2002-02-28 Thread Arjen Lentz
Hi, On Fri, 2002-03-01 at 06:49, Scalper wrote: > I am curious about the geographical usage of MySQL. Judging from the users > on this list it seems like it is used more heavily in Europe than in Asia > and the Americas. To date, has there been any formal studies or polls taken? It's really

MySQL Backup and Recovery

2002-02-28 Thread Chetan Lavti
Hi, I am planning to have MySQL database backup and recovery from the web interface. Is it possible to do this. If yes, then what procedure I should follow. If anybody have any idea about this then please, do help me. It's our requirement. Thanks and regards, Chetan Lavti ---

MyODBC or some other C based API for speed?

2002-02-28 Thread Wilbur Streett
I'm working on indexing words in web pages, and I'm finding a significant issue with the performance of MyODBC, even when I resort to using batch mode inserts.. I'm currently using the older version of MyODBC, and basically I'm looking to determine if anyone is aware of a faster API? Is the new

load data query performance

2002-02-28 Thread Sommai Fongnamthip
Hi, I was read from this group about LOAD DATA query performance. Someone was tell me that when load large data text file into database which has primary key or index may be slow. The way to make load data faster is drop and create table without index, after load data then create inde

RE: Can somebody help me with "round (columna,columnb) "?

2002-02-28 Thread Sommai Fongnamthip
Round function was discuss on this group. They tell me that it used round with the C behavior to adjust value near even value. If you need to adjust with upper value after .5, you need to used programming language (PHP, VB, C) instead of MySQL round function. Sommai At 18:44 28/2/20

[Announce] Blue World Releases Lasso Professional 5

2002-02-28 Thread Cathy Cunningham (Blue World Lasso Evangelist)
Greetings MySQL Friends: For those of you wondering when Blue World would release Lasso Professional 5 with its embedded Lasso MySQL database, well, it was just released. Details follow for those who may be interested. Cheers! CC - FOR IMMEDIATE RELEASE February 26

Re: Can somebody help me with "round (columna,columnb) "?

2002-02-28 Thread Doug Thompson
Hi Don: On Thu, 28 Feb 2002 22:38:04 -, DL Neil wrote: >I know it's getting late, so perhaps I'm not following you sufficiently >closely. What does "inherited" mean? > "Inherited" referred to using the float(10,4) formatting of the "numbers" field in this case. > Also how do you define "w

Re: MySQL on MAC OS X 10.1

2002-02-28 Thread David Gadd
Marc Liyanage has a special Mac OS X friendly installer at: http://www.entropy.ch/software/macosx/mysql/ I've installed it on OS X 10.1 and it works great. David Gadd gaddzeit.com >I'd like to install MySQL on MAC OS X 10.1 > >I've notice it's using Darwin 1.4 > >But the binaries for MySQL ap

Re: Print From MySQL

2002-02-28 Thread Benjamin Pflugmann
Hi. On Thu, Feb 28, 2002 at 07:39:04PM -0500, [EMAIL PROTECTED] wrote: > Is there any way to print (to a printer) an ORDERed SElECT directly from No. MySQL is an RDBMS, not an printing tool. > MySQL without the use of scripting or programming? Well depends on how you define this... You didn't

MySQL on MAC OS X 10.1

2002-02-28 Thread James LaFountain
I'd like to install MySQL on MAC OS X 10.1 I've notice it's using Darwin 1.4 But the binaries for MySQL appear to say for Darwin 5.1 What should I do? James __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greet

Re: MyODBC or some other C based API for speed?

2002-02-28 Thread Wilbur Streett
At 02:17 AM 3/1/02 +0100, you wrote: >Your message cannot be posted because it appears to be either spam or >simply off topic to our filter. To bypass the filter you must include >one of the following words in your message: > >sql,query > >If you just reply to this message, and include the entire

Re: column level grants

2002-02-28 Thread Doug Thompson
You are restricted to SELECT, INSERT, and UPDATE privileges on columns. ALL won't work. Regards, Doug On Thu, 28 Feb 2002 11:31:15 -0600, Kenneth Hylton wrote: >Howdy - > >I have looked online and also in MySQL by Paul DuBois, plus the O'Reilly >book and can't find an example of how to do c

Print From MySQL

2002-02-28 Thread Rich
Is there any way to print (to a printer) an ORDERed SElECT directly from MySQL without the use of scripting or programming? Rich -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the ma

replicate-rewrite-db

2002-02-28 Thread David Cumming
Hello (Post 2) Has anyone got replicate-rewrite-db (a my.cnf entry) to work. I have replication running fine, however the rewrite doesn't work. I just want to know whether I should persist or if there is something special people had to do to get it working. I have heard / read a few people say

Innodb tables lose foreign keys after creating an index...

2002-02-28 Thread Rick Flower
Hi all.. Are any of you aware of a way to get indexes to work at all with Innodb tables containing foreign keys? I'm finding that after doing a "create index" on a table which *had* foreign keys, after the create, the foreign keys are gone.. I've included a simple test below which shows off t

FW: creating dream tables

2002-02-28 Thread Forer, Leif
Oops. The reason I wasn't able to get past 12 had nothing to do with 12. I was saying: select sum(if(month(period)=12,hours,0)) as Dec from log group by pj; the Dec was the problem. of course, a simple renaming fixes the prob. -Original Message- From: Forer, Leif Sent: Thursday, Feb

Re: Indexing fails, myisamchk cannot repair, no error msg.

2002-02-28 Thread Steve Rapaport
>The "warning: Found 22079089 partsShould be: 0 parts" is a >known error of myisamchk in MySQL 4.0.1, and is already fixed in MySQL 4.0.2 Thanks, Jocelyn, good to know, but the cardinality of the resulting indexes is STILL NULL: hence perhaps not fixed. So the bug report may

Re: Indexing fails, myisamchk cannot repair, no error msg.

2002-02-28 Thread Fournier Jocelyn [Presence-PC]
Hi, The "warning: Found 22079089 partsShould be: 0 parts" is a known error of myisamchk in MySQL 4.0.1, and is already fixed in MySQL 4.0.2 : Fixed new bug in myisamchk where it didn't correctly update number of ``parts'' in the MyISAM index file. (http://www.mysql.com/doc/N/e

Re: large table cleanup in MySQL

2002-02-28 Thread Christopher Thompson
On Thursday 28 February 2002 3:47 pm, Eric Colley wrote: > I have a MySQL table of basic user information including email address as > one of the fields. The table is about at the 10,000 record mark. I have a > list of bad email addresses that another program found for me (around 2,000 > records

Indexing fails, myisamchk cannot repair, no error msg.

2002-02-28 Thread Steve Rapaport
>Description: Copy existing file to text using mysqldump Read mysqldump onto new machine using 'source' Resulting database has incomplete indexes (cardinality NULL) (why?) Try to fix resulting indexes using myisamchk -r Everything appears to work, takes abou

Re: flexible foreign keys?

2002-02-28 Thread Jeff Kilbride
Well, honestly, by deleting the record in the parent, you're already defeating the purpose of the foreign key by corrupting the referential integrity of the parent to child relationship. The basic reasoning behind foreign keys is to maintain this integrity and prevent this type of corruption. So,

Re: large table cleanup in MySQL

2002-02-28 Thread Christopher Thompson
On Thursday 28 February 2002 3:47 pm, Eric Colley wrote: > I have a MySQL table of basic user information including email address as > one of the fields. The table is about at the 10,000 record mark. I have a > list of bad email addresses that another program found for me (around 2,000 > records

Re: After php udate, php pages no longer update MySQL database

2002-02-28 Thread Dieter Lunn
If you compiled it did you use --with-mysql? On February 28, 2002 01:30 pm, you wrote: > I just reinstalled the latest version of php on my system and after doing > so the pages that existed within the site no longer allow records to be > updated in MySQL, records that updated fine before. Any i

large table cleanup in MySQL

2002-02-28 Thread Eric Colley
I have a MySQL table of basic user information including email address as one of the fields. The table is about at the 10,000 record mark. I have a list of bad email addresses that another program found for me (around 2,000 records). Now how do I take this list of bad email addresses and run

Re: Can somebody help me with "round (columna,columnb) "?

2002-02-28 Thread DL Neil
Hi Doug, > I spent the last couple of hours replacing the mainboard in another box I have here and doing some testing. It now has the > same board/cpu as this Win98SE machine. It is running Linux-Mandrake 8.0 with MySQL 3.23.38 which came with the LM distro. > > I then created a table and popul

fulltext search in boolean mode that i can t understand

2002-02-28 Thread David yahoo
Hi, I try to use boolean search into my database but I sometimes estonished of the results. I make such query : SELECT * FROM T_Stories WHERE match (Summary,Content,Heading,livecountry,livecity,Author) against ('fiat' IN BOOLEAN MODE) AND Verified = 'Y' LIMIT 12 I can retrieve rows that hav

Re: Lookup tables and indexing

2002-02-28 Thread Jeff Kilbride
Hi Egor, Thanks for the reply. Does it actually hurt to index them on lower volumes of traffic? Or is it neglible? --jeff - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 28, 2002 8:40 AM Subject: Lookup tables and indexing

RE: INSERT blob data in C

2002-02-28 Thread Kenneth Hylton
Thanks for your quick response! That's just what I needed. The secret is using mysql_escape_string to change the data such that it will not cause problems with delimiters! Thank You! > "Have A Great Scouting Day" > Ken Hylton > 7826 Falcon Ridge Drive > San A

load_file problem mysql-4.0.0-alpha-pc-linux-gnu-i686 on linux 2.4.16

2002-02-28 Thread Alfred Wallner
Hello, function load_file always return NULL for me. I tried using INSERT and UPDATE. The file and directory is world readable. Is there a known problem with load_file on mysql 4.0.0 ? INSERT INTO tests (Name,Data) VALUES ('123.456',LOAD_FILE("/home/mysql/testfile")); UPDATE tests SET Data = "/h

Re: creating dream tables

2002-02-28 Thread DL Neil
Leif, > What a thorough and thoughtful response! It works like a charm. > > I'd like to generate a report based on all 12 months of the year but for > some strange reason (and I'm guessing you already knew this) the method you > suggested only works up to 11. Why is this? What should I do? > >

Re: Where is 3.22.35? I need it due to the coredump bugfix.

2002-02-28 Thread Benjamin Pflugmann
Hello. Hm. I just followed this way... http://www.mysql.com -> Downloads -> "Older releases" (under "MySQL Database") and found only 3.22.32. As I guess you already did the same and therefore ask at all, so it would have been nice if you mentioned it. Since the most current version in the change

Here is a Servlet for Testing Servlet-JDBC Connections & JDBCDrivers

2002-02-28 Thread Amandeep Jawa
Hi folks - Here is my thank you for everyone's help getting PostgreSQL/mySQL and various JDBC drivers running on Linux/ NT/ & MacOSX. --- Servlet Container / JDBC / HTTPD Validation Application http://www.worker-bee.com/pro

Re: INSERT blob data in C

2002-02-28 Thread paradoxix
just some code I did some time ago: /* */ #include #include #include #include #include #include MYSQL dbcon; int main(int argc, char *argv[]) { int i; char *tmpQ=malloc(2*1024*1024); char *end; int file; int size; char *mem; char tmpstr[1024]; mysql_init(&dbcon); mys

Re: Can somebody help me with "round (columna,columnb) "?

2002-02-28 Thread Doug Thompson
On Thu, 28 Feb 2002 16:53:59 -, DL Neil wrote: >BTW: this apparent accreditation (below) is incorrect/an accident of editing? I >didn't say this. It was Doug (he >says pointing an accusative finger). Doug whilst I'm (appearing to) round on you, >contrary to your comment about >lack of evide

Re: Mysql Date Functions - input

2002-02-28 Thread Keith C. Ivey
On 28 Feb 2002, at 21:24, Marjolein Katsma wrote: > The easiest way to work around all the date formats of the world > for data input on a web page is to simply split the input into > three parts: year, month and day. Month and day can then be > dropdown lists (built-in -partial- validation!) and

Geographical MySQL Usage

2002-02-28 Thread Scalper
I am curious about the geographical usage of MySQL. Judging from the users on this list it seems like it is used more heavily in Europe than in Asia and the Americas. To date, has there been any formal studies or polls taken? Craig ---

Re: Java and MySQL?

2002-02-28 Thread Mark Stringham
Done it with JSP and works very nicely. PHP works fast but I like some of the JSP functionality better - Mark -Original Message- From: shruti selvaraj <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Thursday, February 28, 2002 1:43 PM Subject: Java and MySQL? >Hello

Java and MySQL?

2002-02-28 Thread shruti selvaraj
Hello , I am thinking of using Java Servles , JSP with MySql..just wondering if thats possible and if anyone's done this before. Thanks! Shwetha. __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greeti

INSERT blob data in C

2002-02-28 Thread Kenneth Hylton
Howdy - I looked in the doc @ mysql.com and the New Riders and O'Reilly MySQL books. Plus, I consulted the archives as best I could and did not see an answer for this: How do you insert binary data using the C API? I know you need to use mysql_real_query method and pass length, but how do you

myisamchk -e reports: clients haven't closed table after INSERT

2002-02-28 Thread Keith Smith
Hi: I am finding that my perl code generates warnings by myisamchk whenever it executes an INSERT command, but *NOT* a SELECT command. I just upgraded this perl application (which had no problems before), to: MySQL-3.23.48-1 perl-DBD-MySQL-1.2216-4 perl-DBI-1.18-1 If I connect to the database a

Where is 3.22.35? I need it due to the coredump bugfix.

2002-02-28 Thread Christian Hammers
Hello I was notified about a coredump bug in MySQL 3.22.xx. As this can be used as DoS I like to update the MySQL packages I maintain for the Debian GNU/Linux distribution. I would like to have specifically the 3.22.35 as the bug seems to be fixed there according to the changelog and I don't li

Re: Mysql Date Functions - input

2002-02-28 Thread Marjolein Katsma
At 15:02 2002-02-28, you wrote: >Hi all, > >I asked this question on the PHP-DB list but everyone was asleep (no >response). > >= = = = = = = >I have a site where dates are being displayed and also entered by users. I >don't want to offend them by asking them to use

Re: After php udate, php pages no longer update MySQL database

2002-02-28 Thread Benjamin Pflugmann
Hi. That's too few information to say anything concrete. Do you get any error message? If not, please look how to enable error messages in PHP (or change your script to log them). Then post the error message you get. Bye, Benjamin. On Thu, Feb 28, 2002 at 02:30:20PM -0500, [EMAIL PROT

Re: Help needed with C program + Mysql

2002-02-28 Thread Benjamin Pflugmann
Hi. The char* to the field value will be NULL (in the C meaning), if the value is NULL (in the SQL meaning). The reason for your core dump is probably a missing check before you treat the NULL pointer as string. Bye, Benjamin. On Thu, Feb 28, 2002 at 03:23:01PM -0300, [EMAIL PROTECTED

Select_full_join counter

2002-02-28 Thread Viraj Alankar
Hello, The MySQL manual states that the Select_full_join status counter should be 0. Can someone explain to me what this actually counts and why it is bad to not have this 0? I have some queries that I'm not sure how else to optimize. Thanks, Viraj.

database= in my.cnf causes mysqldump to fail

2002-02-28 Thread Viraj Alankar
Hello, I'm not sure if this is a bug or not, but I've noticed that if I have a 'database=' in my ~/.my.cnf, calling mysqldump with any possible options always returns: mysqldump: option `--databases' doesn't allow an argument The only way I can get it working is to remove the 'database=' line f

RE: After php udate, php pages no longer update MySQL database

2002-02-28 Thread Todd Williamsen
Which PHP version did you update to? I have noticed in PHP 4.1.1 is more anal about syntax -Original Message- From: Vernon [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 1:30 PM To: php-list; MySQL-list Subject: After php udate, php pages no longer update MySQL database

RE: After php udate, php pages no longer update MySQL database

2002-02-28 Thread Simon Green
Sorry but questons What is the update.log say (is it connecting)? Is it just UPDATE, do SELECT's work? Have you got if (mysql_create_db ($DBname, $Link)){ print ("worked"); }else{ print ("fail"); } etc...? Simon -Original Message- From: Vernon [mailto:[EMAIL PROTECTED]]

timeout problems

2002-02-28 Thread Dirk Bulinckx
I new to mySQL so don't shoot my if my question is easy to answer. I'm using VB to connect to a mySQL server and I can't get the connection to timeout. Why do I want to do exactly? Connect to server (max timeout of 5 seconds) if within 5 seconds I don't get a valid response from t

After php udate, php pages no longer update MySQL database

2002-02-28 Thread Vernon
I just reinstalled the latest version of php on my system and after doing so the pages that existed within the site no longer allow records to be updated in MySQL, records that updated fine before. Any ideas why or how to fix? Thanks -

RE: creating dream tables

2002-02-28 Thread Forer, Leif
DN- What a thorough and thoughtful response! It works like a charm. I'd like to generate a report based on all 12 months of the year but for some strange reason (and I'm guessing you already knew this) the method you suggested only works up to 11. Why is this? What should I do? And, it shoul

odbc...

2002-02-28 Thread Edward Peloke
Is it possible to have global access to all databases using the new odbc driver? For example I have an app that uses more than one table owner. In Mysql, I had to set up a db for each owner but when I try to connect through the odbc, I don't have access to all the databases, just one. How can I

Re: delete syntax - forms processing problem

2002-02-28 Thread DL Neil
Hi Andrea, > I have a phone directory that allows a user to search > the database by name & the results.php page has two > forms in it. one form allows the user to modify the > entry & submit changes to the database - this works > fine. the other form allows the user to delete the > entry (row)

Re: creating dream tables

2002-02-28 Thread DL Neil
Leif, This is a bit of a mind-bender, but quite easy to do:- > i'm trying to select data from a table and format it in an html table (using > php) but i want mysql to do as much of the hard work as possible. I'll agree with/encourage that philosophy. > i'm selecting data from a table with colu

Help needed with C program + Mysql

2002-02-28 Thread Villarroel Nuñez Alejandro Arturo
I have defined a Mysql table with some integer variable, I can put NULL values in these elementes, but when I user mysql_fetch_row, if there's some integer field with NULL value, the program fails with core dump. Where's the problem? Thanks in advance.

RE: How to store an Image on MySQL

2002-02-28 Thread Matthew Smith
Check the archives, it has been covered reacently, but assuming something like perl: $sql=qq{ insert into some_table (some_blob) values ( ?) }; $sth=$dbh->prepare($sql); $sth->execute( $my_blob); Regards M -Original Message- From: Hector Rosas [mailto:[EMAIL PROTECTED]]

Re: How to store an Image on MySQL

2002-02-28 Thread James Carrier
PHP builder have a good article on this subject, most of which is language-neutral: http://www.phpbuilder.com/columns/florian19991014.php3 At 10:51 28/02/2002 -0700, Hector Rosas wrote: >Hi Everybody, I have a problem with MySQL when I try to store image > file on it. I use a Blob field b

How to store an Image on MySQL

2002-02-28 Thread Hector Rosas
Hi Everybody, I have a problem with MySQL when I try to store image file on it. I use a Blob field but the info that must be stored there should be between quotations marks right? Like a string , i mean "GIF89kjflH.. more binary symbols..." but if the image file information have a quotat

RE: Can somebody help me with "round (columna,columnb) "?

2002-02-28 Thread Roger Baklund
* Doug Thompson > When you repeated the query, the number of significant places was > reduced by one each time. > Thus: > 100.4235 > 100.4230 > 100.4200 > 100.4000 ah. No, this was a misunderstanding... this is what I did: mysql> set @a:=8; Query OK, 0 rows affected (0.00 sec) mysql> select @a

MySQL AB vs NuSphere Court Case Decision (ongoing)

2002-02-28 Thread BD
In case anyone is interested, here is the link for the on going saga of MySQL AB vs NuSphere court case, soon to be made in a TV mini-series (just joking). http://newsforge.com/ Brent _ Do You Yahoo!? Get your free @yahoo.com address

delete syntax - forms processing problem

2002-02-28 Thread A. Caldwell
Hi there, I've been struggling with this & the mysql documentation doesn't seem to be helping much. I'll try to make this as short as possible... I have a phone directory that allows a user to search the database by name & the results.php page has two forms in it. one form allows the user to m

column level grants

2002-02-28 Thread Kenneth Hylton
Howdy - I have looked online and also in MySQL by Paul DuBois, plus the O'Reilly book and can't find an example of how to do column level security. We are running 3.23.46-Max on Red Hat 7.2 Here is what I am trying: mysql> GRANT ALL (BatchControlUri, IndustryId, UpdateId) ON dbEngine.BatchCo

select distinct this and sum that

2002-02-28 Thread Forer, Leif
this is working: mysql> select distinct pj from tmp; +---+ | pj| +---+ | 41857 | | 41992 | | 42620 | | HOLID | | OTHER | | PERS | | SICK | | VACAT | +---+ 8 rows in set (0.00 sec) now, i want to do something like this: mysql> select sum(hours) from tmp where pj=distinct group b

Re: ignore words in full text indexes

2002-02-28 Thread David yahoo
Hi, > Or maybe there are too many. It appears that any word that appears > in more than half the rows is treated as a stop word: > > http://www.mysql.com/doc/F/u/Fulltext_Search.html > I read this page but this condition doesnt hurt my mind. I don t know what happen I modify fait to fiato I reg

MySQLGUI help file

2002-02-28 Thread Thi Cao
Hi everyone, I recently unpacked the Mysqlgui static binary distribution for windows and placed the MySQL.help file along with the my.cnf.win file in the c:/ root directory. I have the line help_file=c:/MySQL.help (also tried c:\\MySQL.help) in the my.cnf.win file. However, when I start up

Re: bug in mysqlimport with many rows

2002-02-28 Thread Benjamin Pflugmann
Hi. That's how the manual describe how MySQL usually handles "disk full" conditions (http://www.mysql.com/doc/F/u/Full_disk.html). Bye, Benjamin. On Thu, Feb 28, 2002 at 11:45:35AM +0100, [EMAIL PROTECTED] wrote: > Hi: > I had solve MY problem, it was a disk full. But mysql hangs, don'

Re: Can somebody help me with "round (columna,columnb) "?

2002-02-28 Thread DL Neil
Richard, Oops, I seem to have stirred up a hornet's nest! (must be a talent of mine). Sorry about the "riga.riga" thing, I couldn't remember your name... BTW: this apparent accreditation (below) is incorrect/an accident of editing? I didn't say this. It was Doug (he says pointing an accusative

RE: Mysql Date Functions - input

2002-02-28 Thread John Lodge
I use a JavaScript date picker for all date fields that need to be entered. This can display in on format and present the required -mm-dd format to MySQL. I can send the relevant JavaScript and examples if required. I found it on the web. It is not my own work. John Lodge -Original Mess

RE: Can somebody help me with "round (columna,columnb) "?

2002-02-28 Thread Doug Thompson
On Thu, 28 Feb 2002 15:49:10 +0100, Roger Baklund wrote: >> 1. If anyone else can produce the declining decimal resolution >> that Roger encountered, then there may be something to >> be found in the mysql code or the gcc libraries. Until then, it >> is a vagary of Roger's installation. I resi

Lookup tables and indexing

2002-02-28 Thread Egor Egorov
Jeff, Thursday, February 28, 2002, 7:14:51 AM, you wrote: JK> Is there a rule of thumb for small tables and whether they should be JK> indexed? I have several small, two column lookup tables with few rows JK> (100-300) and some very small tables (< 10 rows). I don't plan on indexing JK> the very

Database path

2002-02-28 Thread Victoria Reznichenko
Ernesto, Thursday, February 28, 2002, 6:06:53 PM, you wrote: EAZI> Friends: EAZI> How I can change the place where they are create the database? EAZI> Different place than \mysql\data\mybase You should change default directories by editing my.cnf: [mysqld] datadir=path_to_your_dir or yo

Re: Chinese support at MySQL

2002-02-28 Thread Joey Fong
Hi Egor Egorov, If I set to big5, any influence to English data? By the way, will MySQL support UTF-8? Thanks for your help. At 20:18 02-27-2002, "Egor Egorov" wrote the following: >You should set big5 character set, look at: > http://www.mysql.com/doc/C/h/Character_sets.html -

Re: Replication of rename

2002-02-28 Thread Sasha Pachev
On Thursday 28 February 2002 02:57 am, Christian Rabe wrote: > Hi, > > I just run into a "problem". > > RENAME TABLE put_tablename_here TO another_tablename here > > is not replicated. But a > > ALTER TABLE RENAME put_tablename_here TO another_tablename here > > is replicated. > > Is this a

Database path

2002-02-28 Thread Ernesto A. Zapata Icart
Friends: How I can change the place where they are create the database? Different place than \mysql\data\mybase thanks Ernesto - Before posting, please che

Re: Mysql Date Functions - input

2002-02-28 Thread Paul DuBois
At 14:02 + 2/28/02, George Pitcher wrote: >Hi all, > >I asked this question on the PHP-DB list but everyone was asleep (no >response). > >= = = = = = = >I have a site where dates are being displayed and also entered by users. I >don't want to offend them by asking

Starting mysqld fails

2002-02-28 Thread Egor Egorov
Dieter, Wednesday, February 27, 2002, 11:58:04 PM, you wrote: DL> Hi, DL> I downloaded the tarball for the latest RH binaries of Mysql 3.23.49a. I DL> "installed" it according to the INSTALL-BINARY file included with the DL> package. When I tried to run mysql according to the same file it cra

mysqld crashes immediately during mysql_install_db or alone : signal 4

2002-02-28 Thread Sam
I had install today THE RPM version 2.23.49 of MySQL, files I took from MYSQL.com (and mirrors). I have a linux computer, RedHat version 7.2. I had no problem with rpm -i, except with the bench rpm file. When I do the command 'mysql_install_db' I have a message who begins by 'Installation of gran

Re: Beware: 2GB was the problem!

2002-02-28 Thread Sinisa Milivojevic
Trond Eivind Glomsrød writes: > > Note that unrecommended usage of old compat compilers w/old compat > glibc (egcs+glibc 2.1) may lead to this not working properly. MySQL > needs to use current libraries with specified flags in order to use > the *64 functions. > > -- > Trond Eivind Glomsrød >

Re: I heard that MySQL 4.01 supports Views?

2002-02-28 Thread BD
At 03:31 PM 2/27/2002 , you wrote: >Does MySQL 4.01 support Views? And if so, how? > >Stephen Cox >Web Development, Webmaster >[EMAIL PROTECTED] > Stephen, Views were on the list for the 4.1 release so your friend may have accidentally transposed the .01 and the .1. However this feature

Re: Beware: 2GB was the problem!

2002-02-28 Thread Trond Eivind Glomsrød
Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > Steve Rapaport writes: > > Thanks to the guy who pointed this out. > > > > For the information of others, yes, it's quite possible > > to have a machine with mysql table files > 2GB lying about on the > > disk, that still doesn't properly support

RE: Can somebody help me with "round (columna,columnb) "?

2002-02-28 Thread Doug Thompson
On Thu, 28 Feb 2002 15:32:24 +0100, Roger Baklund wrote: >As far as I can tell, there are at least two bugs. > >One bug is already known, it is the rounding error that applies to some >platforms, depending on the underlaying C library being used: > >win2k, 3.23.30-gamma: > >mysql> select round(1.

RE: Can somebody help me with "round (columna,columnb) "?

2002-02-28 Thread Gary . Every
I've tried the select round(1.5) on: Linux RH7 w/3.23.47 Answer: 2 Solaris 7 w/3.23.38 Answer: 2 Linux Debian w/3.23.38 Answer: 2 sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

Re: ignore words in full text indexes

2002-02-28 Thread Keith C. Ivey
Sergei Golubchik wrote: > On Feb 28, David yahoo wrote: > > SELECT * FROM T_Stories WHERE match against ('+fiat -bagnole' IN > > BOOLEAN MODE) > > doesnt give any row > > but when changing fiat to fiato it gives me row ? > > may be there're no rows with "fiat" ? :) Or maybe there are t

mysqld crashes immediately during mysql_install_db or alone

2002-02-28 Thread Sam
I had install today THE RPM version 2.23.49 of MySQL, files I took from MYSQL.com (and mirrors). I have a linux computer, RedHat version 7.2 I had no problem with rpm -i, except with the bench rpm file. When I do the command 'mysql_install_db' I have a message who begins by 'Installation of grant

RE: Can somebody help me with "round (columna,columnb) "?

2002-02-28 Thread Roger Baklund
* Doug Thompson > On Thu, 28 Feb 2002 12:42:04 -, DL Neil wrote: > > >After a number of rounds of this conversation/developing a > work-around, have we decided that there is a > >fault/bug? > >I don't recall any 'official' involvement to date. > >Has 'riga.riga' submitted a Bug Report to MySQL

RE: Can somebody help me with "round (columna,columnb) "?

2002-02-28 Thread Roger Baklund
* DL Neil > After a number of rounds of this conversation/developing a > work-around, have we decided that there is a fault/bug? As far as I can tell, there are at least two bugs. One bug is already known, it is the rounding error that applies to some platforms, depending on the underlaying C li

Re: Problems with GRANT and REVOKE

2002-02-28 Thread Victoria Reznichenko
Joerg, Thursday, February 28, 2002, 2:28:27 PM, you wrote: JH> Hello Victoria Reznichenko, JH> thanks for your answer, but i think this is not absolutly true [skip] JH> But now there is the next question : JH> This entry ""@localhost was made my mysql_install_db . JH> Do i need it ? What was is

Re: Problems with GRANT and REVOKE

2002-02-28 Thread Victoria Reznichenko
John, Thursday, February 28, 2002, 1:56:29 PM, you wrote: >>JH> i like to have a DB per user so i do >> >>JH> GRANT ALL ON username.* TO username@"%" IDENTIFIED BY 'password'; >> >>JH> This is fine, until the user tries to connect from localhost :( >>JH> As i read the manual i think the %-wildcar

Re: Can somebody help me with "round (columna,columnb) "?

2002-02-28 Thread Doug Thompson
On Thu, 28 Feb 2002 12:42:04 -, DL Neil wrote: >After a number of rounds of this conversation/developing a work-around, have we >decided that there is a >fault/bug? >I don't recall any 'official' involvement to date. >Has 'riga.riga' submitted a Bug Report to MySQL? 1. If anyone else can p

mysql@lists.mysql.com

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

Mysql Date Functions - input

2002-02-28 Thread George Pitcher
Hi all, I asked this question on the PHP-DB list but everyone was asleep (no response). = = = = = = = I have a site where dates are being displayed and also entered by users. I don't want to offend them by asking them to use the -mm-dd format or to split the dat

Re: Join with absent values in right table

2002-02-28 Thread DL Neil
Hi Tim, > Assume I have two tables, A and B, and both share a key field (for the > sake of argument, lets call it key_id). Is there a way to determine for > which values of key_id in A there is no corresponding row in B? > e.g I might have Table A: > key_id , value > 1,1 > 2,1 > 3,3 > 4,4 > > an

Re: core dump in clients in MYSQL 3.23.49 using groups

2002-02-28 Thread Sinisa Milivojevic
Laurent Wacrenier writes: > Sinisa Milivojevic wrote: > > Do you mean that you have defined a group as [bug] ??? > > Yes. > > I've discovered the problem upgrading a server and reproduced it with > minimal C program and minimal my.cnf on another host. > > > Does it change anything if spaces ar

  1   2   >