Example UDF for anyone interested

If anyone's looking for another nice user-defined function example, I've just set one up at work and am happy to share the wealth :). They're really quite cool, and this one is a good deal simpler than udf_example.cc. The function is at:

RE: Problem with User Account - access denied

Isnt it GRANT ALL ON college.* TO someuser identified BY somepassword; -Original Message- From: J [mailto:[EMAIL PROTECTED]] Sent: Sunday, 28 April 2002 2:22 AM To: [EMAIL PROTECTED] Subject: Problem with User Account - access denied I created and user, like below, using mysql on my

Re:  character

Hi, Almost all machines who work with CPU know about ASCII character set (http://www.asciitable.com/). This character is ENTER(in ASCII - carriage return) or NEW LINE (in ASCII - linefeed) and is NON-PRINTABLE. Don't have graphical representation. Using LOAD DATA ..., MySQL accept all the

Using multi-byte character set

Hi, I am using double byte character set (big5) under mandrake linux with MySQL everything seemed ok after building the DB and tables after some time of testing I found some characters cannot be inserted, like those characters include the back slash '\'. it was simply disappeared as MySQL treat

RE: Keeping track of db structure changes

It's really not all that different that source code. For each application I build, I tend to put the source code in our CVS repository long with the $foo.sql file(s) to reconstruct the tables. Just as there's nothing preventing me from deploying a new release of an application before

Re:  character

This character is a trademark character it looks like (TM) but as one superscript character. Ack, at 4/28/02, Gelu said: Almost all machines who work with CPU know about ASCII character set (http://www.asciitable.com/). This character is ENTER(in ASCII - carriage return) or NEW LINE (in ASCII

Fw: WHERE ignored

Corrupt index, hmm? I'll check that in a moment - thanks. Probably a sensible idea to limit the query too - I think I'll order by date desc too just to make sure that recent mail gets sent. Cheers --Mike - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Mike Hall

Changing field size

I've a VARCHAR(4) field that I want to change to a VARCHAR(6) field. What would happen to the existing data in MySQL db? Thanks! Tony ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php

parse errors when compiling clients using gcc 2.96

I receive the following parse errors when attempting to compile a client program on a Linux box using gcc 2.96: gcc -c -DMYSQL -I/var/src/mysql-3.23.49/include checkhttpd.c In file included from checkhttpd.c:9: /var/src/mysql-3.23.49/include/mysql.h:175: parse error before `1'

SV: WHERE ignored

-Oprindelig meddelelse- Fra: Mike Hall [mailto:[EMAIL PROTECTED]] Sendt: 28. april 2002 12:28 Til: [EMAIL PROTECTED] Emne: Fw: WHERE ignored Corrupt index, hmm? I'll check that in a moment - thanks. After looking at your fault-free script, my best bet would also be a corrupted

mysql /bin directory

Greetings, I am new to mysql. I have performed a fresh Red Hat install (7.2) with all packages available. In an attempt to become more familiar with mysql (performing numerous tutorials) there are many mentions of a /usr/local/mysql/bin directory. Since everything was installed via RPM

Can't start mysql-service on Win XP

Hello, for the first time I installed Mysql 3.23.49 on win XP professional. I installed it with admin privileges, installed the service -so far everything seemed to be ok. But when I tried to start the service, it didn't start (failure number 1067). I don't have any idea, what that failure

Re: mysql /bin directory

J. Flechnter, Here are some paths from an rpm install that I did with RedHat. /usr/share/mysql/ /etc/my.cnf /var/lib/mysql/ Mike J. Flechtner wrote: Greetings, I am new to mysql. I have performed a fresh Red Hat install (7.2) with all packages available. In an attempt to become more

Re: Can't start mysql-service on Win XP

Hi Sabine (again ;-) ) I suppose you already tried this: http://www.mysql.com/doc/N/T/NT_start.html This could be problems w/ your path or your my.ini (overwritten my mysqladmin). If it won't start anyway, put mysqladmin.exe to your autostart. regards, (Grüße) Jan - Original Message

IBM docs server and mysql manual

Hi, just a short note for the documentation: IBM moved their AIX documentation, and did not find it necessary to redirect this properly. The link in: http://www.mysql.com/doc/I/B/IBM-AIX.html refering to the uname command, should go from:

Re: Changing field size

To my knowledge, nothing would happen to the existing data, since you would be performing a widening conversion. Michael On Sun, 28 Apr 2002, Anthony Rodriguez wrote: I've a VARCHAR(4) field that I want to change to a VARCHAR(6) field. What would happen to the existing data in MySQL

mysql server question

Hi, all, Two questions . . . 1. Windows is giving me the 1067 error, which states that the MySQL server is terminating unexpectedly. I guess I'm going to have to reinstall it, unless there's some way to troubleshoot what's wrong and then fix the problem. Has anyone ever encountered this?

Re: Can't start mysql-service on Win XP

Hi Jan, I suppose you already tried this: http://www.mysql.com/doc/N/T/NT_start.html I did! This could be problems w/ your path or your my.ini (overwritten my mysqladmin). mysqld-nt --help has the correct basedir (.\mysql\) Oh, what's that? In my.ini I just wrote basedir=mysql

How get the columns that are between an interval?

Hi, How can I get the columns between a given time interval? Something like: The patients admitted between january 25, 2000 and january 30, 2001 ?? I'm new to MySql and would like a suggestion from you... Best Regards Silvia

Re: How get the columns that are between an interval?

Should we assume that your tables have an existing column of type timestamp or date? On Sunday 28 April 2002 11:47 am, Dra. Silvia Andreasi wrote: Hi, How can I get the columns between a given time interval? Something like: The patients admitted between january 25, 2000 and january 30,

Re: How get the columns that are between an interval?

Dra. Silvia Andreasi, SELECT * FROM table WHERE begin_date_column =2000-01-25 and 2001-01-30= end_date_column; begin_date_column and end_date_column have to be date type columns. Mike sql,mysql Dra. Silvia Andreasi wrote: Hi, How can I get the columns between a given time interval?

InnoDB's inner workings and checkpoints

Hello (Heikki), I have read up on checkpoint activity and innodb and there are still a few points I don't understand: -what is the chronological sequence of events for a write into the innodb tablespace? -Is it: 1. An insert sql statement is issued from a mysql client. 2. The record is

Update a table with data from another table?

I'm wondering if there's a way to use the results of a SELECT in an UPDATE operation, the way that it's possible to do so with INSERT and REPLACE. This seems like it should be possible, but as far as I can tell, it's not. This comes up for me repeatedly, but the problem at hand is identifying

How to make the Win target from source?

I downloaded mysql-3.23.49-win-src.zip. There are various files missing (e.g. Makefile) that would enable compiling with gcc. Has anyone out there made mysql from source on Win platform with gcc? I had been trying to compile my own client but was getting a lot of undefines at link time -

RE: How to make the Win target from source?

Hi !! -Original Message- From: Dennis George [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 28, 2002 11:10 AM To: MySQL List Subject: How to make the Win target from source? I downloaded mysql-3.23.49-win-src.zip. There are various files missing (e.g. Makefile) that would

Re: Update a table with data from another table?

Hi. You have analyzied the situation correctly. AFAIK, there is no way to do this with one query until sub-selects are going to be supported, and you have to use one of the work-arounds you described. Bye, Benjamin. On Sun, Apr 28, 2002 at 10:13:49AM -0700, [EMAIL PROTECTED] wrote:

docs for mysql rpms

Dear Mysql folks, If you install mysql-3.23.49 using a source tarball and compile it with gcc, the package contains documentation directories and manual directories. If you install mysql-3.23.49a using an rpm then there don't seem to be doc directories that come with the installation. I

Php query from sql

Hello everybody, I'm quite new with all this php mysql cooperation thing but somehow I already managed to set up mysql database and I'm able to also make query's based on any keyword... Now I wonder how to add to this basic query also option to select some concrete data. For example in the

ANNOUNCE: moodss-15.13

### CHANGES ### --- version 15.13 --- - added tool bar with nice icons (borrowed from KDE) - added View/Tool Bar menu to show or hide the tool bar - saved tool bar visibility state in moodss preferences save file - in HTML documentation, updated screen shots, documented module tables

help / MySQL 3.23.49 vs. BerkeleyDB 4.0.14? (fwd)

hi all, i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's BerkeleyDB 4.0.14. i note the --with-berkeley-db options in configure, but am stumped as to if/how to allow support for the bdb 4.0.14 version. mysql (in configure, acinclude.m4 aclocal.m4) seems to limit to

Re: Can't start mysql-service on Win XP

If a trailing slash were required, mine would not work: [mysqld] basedir=d:/mysql datadir=d:/mysql/data language=d:/mysql/share/english skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K

Re: mysql server question

What Operating System (WinNT / 2K / 98 / etc.) are you using? - Original Message - From: Timothy Keefe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 28, 2002 10:18 AM Subject: mysql server question Hi, all, Two questions . . . 1. Windows is giving me the 1067 error,

Re: mysql server question

What Operating System (WinNT / 2K / 98 / etc.) are you using? - Original Message - From: Timothy Keefe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 28, 2002 10:18 AM Subject: mysql server question Hi, all, Two questions . . . 1. Windows is giving me the 1067 error,

Mysql time zone problem

I am trying to get my time zone setup correctly with mySQL on a RedHat 7.2 box, so the select now(); query returns the correct time. The show variable command show that the time zone is being updated with the different values I enter, but the time is still coming up 4 hours off. I am trying to

View warning messages?

I'm getting several warnings when populating a table with data from a file. Some records are skipped as well, and I haven't been able to figure out why. Is it possible to view these warnings? I searched the list archive and saw that as of April 2000 this feature of MySQL hadn't been

[Fwd: How get the columns that are between an interval?]

oops, i've just sent it to mike. Sabine Richter wrote: Hello Mike, hello Silvia, I think, the statement you suggest, Mike, isn't right. It gives you only patients who are over 1 year in hospital. That means, who came before (or at) 2000-01-25 and left after (or at) 2001-01-30. I think,

% of relevance in results

Hi. I am working on a project using Perl and the DBI (which is irrelevant to the question) and I would like to get a percenteage of how relevant the results are to the query I've made. I have tried the Fulltext and match() methods, but they only give back a number from 1.6 to 3.8 (so far). So,

help / MySQL 3.23.49 vs. BerkeleyDB 4.0.14?

hi all, i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's BerkeleyDB 4.0.14. i note the --with-berkeley-db options in configure, but am stumped as to if/how to allow support for the bdb 4.0.14 version. mysql (in configure, acinclude.m4 aclocal.m4) seems to limit to

Finding relevance in results

Hi. I am working on a project using Perl and the DBI (which is irrelevant to the question) and I would like to get a percenteage of how relevant the results are to the query I've made. I have tried the Fulltext and match() methods, but they only give back a number from 1.6 to 3.8 (so far). So,

Using multi-byte character set

Hi, I am using double byte character set (big5) under mandrake linux with MySQL everything seemed ok after building the DB and tables after some time of testing I found some characters cannot be inserted, like those characters include the back slash '\'. it was simply disappeared as MySQL

FW: keymappings - PHP or MySQL?

Hi, At the moment im getting a difference in keymappings between what is typed into a field and what is stored in the database. I have an html form that gets a text string called $email and this is inserted into a VARCHAR database feild via php, the problem is when special characters are

myisamchk: error: Found key at page 2472960 that points to record outside datafile ...

Hi all, Can someone tell me what this error mean ? myisamchk: MyISAM file /var/lib/mysql/radius/radacct.MYI myisamchk: warning: 1 clients is using or hasn't closed the table properly myisamchk: error: Found key at page 2472960 that points to record outside datafile myisamchk: error:

Select records from remote machine.

Hello all, In mysql how can i select or execute any command in the remote machine Thanx i advance. -- Regards, Charitha. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Select records from remote machine.

Hello all, In mysql how can i select or execute any command in the remote machine Thanx i advance. -- Regards, Charitha. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Select records from remote machine.

You can do this by normal execution but with the -h parameter specfying the host mysql -u mysql -p -h ip address of remote mysql server - Original Message - From: Charitha To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 3:47 PM Subject: Select records from remote machine. Hello