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 m

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 char

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 ch

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 ASC

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 Hal

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 (t

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' /var/src/mysql-3.23.

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 corru

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 th

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 number

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 m

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: http://www.rs6000.ibm.com/doc_link/en_US/a_doc_lib/cmds

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 MySQ

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? Coul

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=m

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 3

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 stored

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 the

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 - the

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) tha

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: > I

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 can'

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 dat

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 minimizin

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 bd

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 set-variable

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 erro

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 s

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 implement

InnoDB's inner workings + 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 stored in

[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 th

% 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 bd

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, 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 tr

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 includ

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: Keypointers

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) http://lists.my

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) http://lists

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 - Original Message - From: Charitha To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 3:47 PM Subject: Select records from remote machine. Hello all, In mysql how can i select or