Re: turn of column headings

2001-03-07 Thread Dan Nelson
In the last episode (Mar 05), Praveen Kallakuri said: hello there, i am a novice, so bear with this rather trivial question. how do i turn off the column-headers for select statements in mysql?? couldn't find any help with the online manual. -N, --skip-column-names Don't

Re: trying to install on RedHat 7.0 and need help

2001-03-07 Thread Gerald L. Clark
Go back to redhat.com and get the RPM that works, Or search the mysql list archives. This has been answered a hundred times ( No exageration. ) Charles L Hagen wrote: OK, here is the story. I have a PII Linux RedHat 7.0 server. I installed the Mysql package that comes with it and

can't start mysql

2001-03-07 Thread foxwoo
Dear, I use Red Head 6 with mysql, php3 and apache, past all of them are work well, but one day the our DNS had some problem, after solve the DNS problems, we found we cannot restart our mysql. The error message is "mysqld daemon ended". The host.err is as below: mysqld started on Wed

Tuning thread_cache_size variable

2001-03-07 Thread Basil Hussain
Hi all, I'm doing another bout of MySQL server tuning as the load on my server has nearly doubled due to recent projects, so I'm trying to squeeze some more performance out of it. Again, I'm looking at thread_cache_size, which I currently have set to 16. The manual says that "by examining the

Sending data, but no data sent?

2001-03-07 Thread smurf
Description: Selecting for a number in a char table is REALLY slow. How-To-Repeat: Large table, main index on column 'id' varchar(100). mysql select id from ticketid where id = '15473'; Empty set (0.00 sec) mysql select id from ticketid where id = 15473;

Re: Question regarding query optimising with between

2001-03-07 Thread Dan Nelson
In the last episode (Mar 06), Christian Hammers said: I have a table with a normal multiple key on a datetime field called "end". I want to search for the number of records in some months. I know that there are none. Now "explain" tells me that a querey with a WHERE clause of end

Datatype for comment field

2001-03-07 Thread Nguyen, David M
I try to create a new table and setup a datatype for comment column that has about 7000 characters long. How do I define it in Oracle? **Here's my SQL and the error I got. SQL create table test (comment varchar(7000)); ERROR --- Character field too long Thanks, David

Mailing Lists.

2001-03-07 Thread Mike Richards
Does anyone know any mailing lists like this one that is really good that are just about linux systems administration etc? Thanx! Mike Richards Network Administrator Harmony Integrated www.hi.ca

Re: Memory footprint

2001-03-07 Thread Joseph Bueno
Simon Windsor wrote: Hi On two separate but identical servers I am runing MySql, 3.22, on Debian (2.2.16) kernel. Using top, one mysqld server uses 10MB whilst the other uses just 3MB. Both servers have identical configuaration files, the only difference is that server 1 is much

Bug in 3.23.33? Or design decision?

2001-03-07 Thread eric
Hi! I just upgraded from 3.22.26a to 3.23.33. We've got a database that has a table that has a column with the name: FullText. Unfortunately, now with 3.23.33, any queries that explicitly refer to this column/field return an SQL error. So far this has been tested with SELECT and

Re: adding WHERE statements?

2001-03-07 Thread Gerald L. Clark
Glenn Thimmes wrote: Hello everyone. I am in a real bind. I am trying to get a list of names from a table where for each name there are several specific entries. For example, the table looks like this: ContactID FactName Value for each ContactID, there may be several entries with

Re: XML support under mySQL

2001-03-07 Thread Florian G. Pflug
On Tue, Feb 27, 2001 at 01:21:52AM +, Peter Skipworth wrote: How is this superior to SQL? It includes the letters "XML", which, apparantly, can do everything from butter your toast to giving you an orgasm like no other you've had before. Don't you just *love* buzzwords! Sorry...I

Intermittent hang on UPDATE foo = foo + 1

2001-03-07 Thread m
Description: Sometimes the query below appears to hang on the table below. The problem seems worse on queries which come from a webserver, where persistent DB connections are used. : The online manual page hints at the same problem elsewhere: see Tomi

Re: Default values

2001-03-07 Thread Gerald L. Clark
Try giving a number instead of a string as a default for an int. Also, what do you mean by blank? If you pass '' as a value, it will become 0 when converted to an int. What happens if you omit the column completely on the insert? "MikeBlezien" wrote: Hello All, I've created a table(using

file insertion?

2001-03-07 Thread Kevin Connolly
Hi, Is it possible to insert a file into the MySQL database? I want a table with certain entries such as name, address etc. but I also I a photo for each member. Is that possible? Thanks, Kev.

Re: Default values

2001-03-07 Thread MikemickaloBlezien
On Tue, 6 Mar 2001 11:14:36 +0100, Fred van Engen [EMAIL PROTECTED] wrote: Thanks Fred, INSERT INTO referral VALUES (NULL, 'xxx.yyy', 'xxx.yyy', '[EMAIL PROTECTED]'); But an INSERT like this: This is where I was making the mistake! It works fine now. I was inserting an blank empty value

Mysql.sock Error

2001-03-07 Thread Marcus Ouimet
My database was working fine then the server crashed and now I am getting this error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) I have checked and verified that the file exists: srwxrwxrwx 1 root root0 Jan 16 23:00

ODBC Driver documentation

2001-03-07 Thread Fernando Rodríguez Sela
Hi, I'm working in a project to simulate the database servers efficiency. The system consists in some modules, one of that is a protocol analyser (to spy the net). My problem, is that I need to work with Oracle servers, and I don't have the Oracle SQLNet protocol, so I decided to make an ODBC

MySQL Crash on ALTER TABLE

2001-03-07 Thread Meyer, Patrick
Running 3.23.33 on Windows 2000 Server. I have noticed that executing an ALTER TABLE works... but the next query on the alter table crashes MySQL and corrupts the table. If I FLUSH TABLES after an ALTER TABLE, it seems to reduce the occurance, but should this be required? [EMAIL PROTECTED]

Re: troubles with joining list

2001-03-07 Thread René Tegel
Well yes, i had troubles with the list as well - i did not see any message on nor the mysql list nor the win32-mysql list... i figured i could be our is' mail server, so i offered to join the list with another e-mail account. I only got it confirmed after 24 hours... So there are networking

Re: Default values

2001-03-07 Thread Jan Bruvoll
On Tue, 6 Mar 2001, MikemickaloBlezien wrote: Try giving a number instead of a string as a default for an int. Not sure I follow, it is a number?? refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL, Your '100' is a string. Try something like this: refer_id int(10) UNSIGNED NOT NULL DEFAULT

Weird select with php

2001-03-07 Thread Matt \TrollBoy\ Wiseman
I'm attempting to do a select from my table, but the only odd thing is the customer wants the results to be completely random every time... is there anything like this?? $query = "SELECT * FROM members where Name like 'A%' ORDER BY random"; Matt "Trollboy" Wiseman

kill bad query

2001-03-07 Thread Steve Ruby
If I have a connection that executes a bad query shouldn't I ALWAYS be able to kill it with "kill connect num"? I have a query that keeps getting stuck, (who knows what it is doing) but that State is "statistics" I can't ever kill it without taking down the server..

RE: mysql can't start

2001-03-07 Thread Sergey Yegorov
If it seems interesting for somebody, I find what a problem. I mean, I can neutralize problem. Mysql started to works after I boot system with kernel 2.2.3 (before I used 2.2.14). I think, impotant difference between its kernels are in system function sys_rt_sigsuspend. Any time, in kernel 2.2.3

MYsql clIENT

2001-03-07 Thread Keneth
MySQL-client-VERSION.i386.rpm The standard MySQL client programs. You probably always want to install this package. What is the MySQL Client used for?

sql date worries

2001-03-07 Thread Adams, Antoine A SSI-ISES-56
Hi all, Im kind of strugling with a query for some time now and I need extra input: What is the desired answer from mysql: a date. what is the input: a week number What dat do I need: The date of the monday (week starts at sunday) in the weeknumber. something like: select

Bug with 'show databases|tables'

2001-03-07 Thread Eugene Lineitzev
Description: I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14 all 'show' commands doesn't works. They display empty tables. How-To-Repeat: Install RedHat 7.0 on Intel platform, apply all updates from RedHat (up to March, 01 2001), compile kernel

Running a Query Append in Access 97 with a linked MySQL table

2001-03-07 Thread Kewlbloke
Hello I have uploaded a table from Access 97 to the MySQL database and apart from changing the name from "Mailing List" to " Mailing_List" it appears fine. Now that I am putting data into the linked MySQL table in a "live " environment I need the MySQL table to update the Access records and

ODBC - Trouble once again

2001-03-07 Thread Wojciech Spychaa
... i forgot i am not registered list user so please answer on priv thx

ODBC trouble - please help

2001-03-07 Thread Wojciech Spychaa
I 've got problem with ODBC support for Microsoft Access Very ofeten i can't edit records because one error. ODBC driver says "there is another user editing same record in this time" This isn't true - because i work alone :-( Is anyone who can help me? Thanks Wojtek

Re: turn of column headings

2001-03-07 Thread Paul A. Rubin
You wrote: hello there, i am a novice, so bear with this rather trivial question. how do i turn off the column-headers for select statements in mysql?? couldn't find any help with the online manual. waiting. praveen If you're running the mysql client, try adding the command line

Re: Fwd: DBD::mysql

2001-03-07 Thread Michael A. Peters
I haven't done what you are trying to do, but I suspect you will need at least the MySQL-shared libraries on your system. On Tuesday, March 6, 2001, at 06:57 AM, John Tsangaris wrote: Tried sending this once and it didn't go through. - I am trying to

Lost connection while doing query

2001-03-07 Thread peral liu
Hello, I am running MYSQL 3.23.34 on NT. I have two processes running at the same time trying to access same database file. Process A : repeatedly doing - open, write one record, close. Process B : repeatedly doing - open, read, close. Both process stars and the process B will be aborted by

query with OR

2001-03-07 Thread ryc
I am having trouble getting this query to run faster: SELECT * FROM t1 WHERE col1 = 'text' OR col2 = 'text'; Here is the output of the explain for that query +---+--+---+--+-+--+--+- ---+ | table | type | possible_keys | key | key_len |

desperate for help...

2001-03-07 Thread Chris Toth
Ok, I've been battling this SELECT statement for the better part of the day. The SELECT statement is this: SELECT DISTINCT request.id AS requestid, request.date, request.type, request.status, faculty.f_name, faculty.l_name, action.id AS actionid, faculty.id AS facultyid FROM faculty,

winmysqladmin (fwd)

2001-03-07 Thread Noviar JK
dear, I have installed mysql for windows NT. I installed the mysql is for support my PHP-NUKE. In PHP NUKE, there is file "nuke.sql" may be its content of the table of NUKE. So, my question is 1. how to made the table in winmysqladmin and entry the list (like field, type at table

INSERT question...

2001-03-07 Thread Josh Burroughs
Hi-o! I was wondering if it's possible when inserting a value into a table that has an auto_increment field to have MySQL return the value of the auto_increment field right after doing the insert, w/out having to run a seperate query? For example if I had a table with two collums, ID and name.

Multi primary keys

2001-03-07 Thread Eric Frazier
Hi, I just discovered with mysql 3.22.32 that it is possible to make a table with more than one primary key. Shouldn't that be impossible? Thanks, Eric Frazier Consulting http://www.kwinternet.com/eric (250) 655 - 9513

Re: Bug in 3.23.33? Or design decision?

2001-03-07 Thread Peter Skipworth
fulltext is now a reserved word - either change the name of the field, or use quotes when refering to it. regards, P On Tue, 6 Mar 2001 [EMAIL PROTECTED] wrote: Hi! I just upgraded from 3.22.26a to 3.23.33. We've got a database that has a table that has a column with the name:

RE: file insertion?

2001-03-07 Thread Don Read
On 06-Mar-01 Kevin Connolly wrote: Hi, Is it possible to insert a file into the MySQL database? I want a table with certain entries such as name, address etc. but I also I a photo for each member. Is that possible? Thanks, Kev. Yes. Ok. Yes, LOAD_FILE(). Welcome. Regards, -- Don Read

mysqld got signal 11

2001-03-07 Thread Steven Roussey
Hi, I'm using mysql-3.23.30 Linux binary downloaded directly from the mysql site, and after a while the server tanks and many copies of this are all over the error log: Number of processes running now: 0 010306 09:19:24 mysqld restarted /usr/local/mysql/bin/mysqld: ready for connections mysqld

Re: mysqld got signal 11

2001-03-07 Thread Steven Roussey
Hi, OK, I now still have the same problem after upgrading to 3.23.33-pc-linux-gnu-i686 binary. After myisamchking all tables, this time it took just about one minute before crashing: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or

Re: mysqld got signal 11

2001-03-07 Thread Steven Roussey
Hi, Ah, today's problems are from a bug that dates back a year or more. Streaming a large number of insert delayeds into a table that does not exist causes the crash. The table was not created correctly last night. Is there a web version of mysql code like PHP has http://lxr.php.net ? I'd like

Antwort: Bug in 3.23.33? Or design decision?

2001-03-07 Thread alexander . skwar
On 06.03.2001 19:05:34 iso-8859-1 wrote: Is this expected behavior? Or is this an actual bug? I suppose this may be expected behavior, as FullText now is a reserved word in MySQL - Before posting, please check:

Re: Bug with 'show databases|tables'

2001-03-07 Thread Richard Ellerbrock
Description: I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14 all 'show' commands doesn't works. They display empty tables. How-To-Repeat: Install RedHat 7.0 on Intel platform, apply all updates from RedHat (up to March, 01 2001), compile kernel

Re: ODBC trouble - please help

2001-03-07 Thread Pat Sherrill
Ensure each table has a TIMESTAMP(14) and a PRIMARY KEY (recommend an AUTO_INCREMENT field). Pat... - Original Message - From: "Wojciech Spychaa" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 07, 2001 4:14 AM Subject: ODBC trouble - please help I 've got problem with

Re: Bug with 'show databases|tables'

2001-03-07 Thread Greg Cope
Eugene Lineitzev wrote: Description: I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14 all 'show' commands doesn't works. They display empty tables. How-To-Repeat: Install RedHat 7.0 on Intel platform, apply all updates from RedHat (up to

Re: Sending data, but no data sent?

2001-03-07 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: Description: Selecting for a number in a char table is REALLY slow. How-To-Repeat: Large table, main index on column 'id' varchar(100). mysql select id from ticketid where id = '15473'; Empty set (0.00 sec) mysql select id

Beginner Help, can't get it started, but did in the past

2001-03-07 Thread Joseph Greenawalt
Hello all, I hope someone can help. I have a fresh install of Red Hat 7.0, I installed mysql-3.23.22-6.i386.rpm and then mysql-server-3.23.22-6.i386.rpm. Supposedly the daemon is automatically starts, well it doesn't. I tried the mysql_install_db and it runs, but I don't think it makes the

Re: key lengths

2001-03-07 Thread Pat Sherrill
BLOBS and TEXT columns used as indices require the length to be specifically enumerated. (Sec 7.26 of the manual) CREATE TABLE foo( id INT NOT NULL AUTO_INCREMENT, name BLOB NOT NULL, PRIMARY KEY(id), UNIQUE(name(500)) ); Pat... [EMAIL PROTECTED] - Original Message - From: "Mike

Re: Antwort: Datatype for comment field

2001-03-07 Thread Gilles Dumangin
I would recommend the book MySQL by Paul Dubois to anybody that want to do some seriou work on MySQL . It is a really god book with everything explained. I am not earning money by recommending it nor have any financial ties with them. I am just a satisfied customer of that book From: [EMAIL

Re: MySQL Crash on ALTER TABLE

2001-03-07 Thread Sinisa Milivojevic
Meyer, Patrick writes: Running 3.23.33 on Windows 2000 Server. I have noticed that executing an ALTER TABLE works... but the next query on the alter table crashes MySQL and corrupts the table. If I FLUSH TABLES after an ALTER TABLE, it seems to reduce the occurance, but should

Re: mysqld got signal 11

2001-03-07 Thread Pat Sherrill
You may have a corrupt library or mysqld. Signal 11 is a memory error (likely overwrite). I would try deleting and reinstalling mysqld from a fresh download. Pat... [EMAIL PROTECTED] - Original Message - From: "Steven Roussey" [EMAIL PROTECTED] To: "Mysql" [EMAIL PROTECTED] Sent:

Re: Sending data, but no data sent?

2001-03-07 Thread Matthias Urlichs
Hi, Sinisa Milivojevic: First of all, where have you got 3.23.34 when it is not out ?? It's the version in your current BitKeeper archive. Second what type of column is id and what does PRIMARY KEY consist of. explain ticketid; Field Type Null Key Default Extra id

BIG problem with MySQL UDFs

2001-03-07 Thread Vladislav Shulgin
Hi! I have a problem with UDF. For acceleration of spell check I needed in UDF function which be able to replace substrings based on regular expressions. Such PHP functions are ereg_replace and preg_replace. Trying to write UDF for MySQL I has confronted with a strange problem. At

MyODBC - displaying EUC-JP characters

2001-03-07 Thread Thiru
Hi, I have downloaded the latest version of MyODBC2.50.36NT and finished my setup. Now everything works fine if I display ASCII But if my table contains EUC-JP characters they dont get displayed properly. My SQL Server is running on RedHat Linux7.0 with Mysql3.23.33. I am using Access 2000

Re: Bug with 'show databases|tables'

2001-03-07 Thread Jean-Luc Fontaine
On Wednesday 07 March 2001 12:43, Richard Ellerbrock wrote: Description: I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14 all 'show' commands doesn't works. They display empty tables. How-To-Repeat: Install RedHat 7.0 on Intel platform, apply all

Re: Sending data, but no data sent?

2001-03-07 Thread Sinisa Milivojevic
Matthias Urlichs writes: Hi, Sinisa Milivojevic: First of all, where have you got 3.23.34 when it is not out ?? It's the version in your current BitKeeper archive. Second what type of column is id and what does PRIMARY KEY consist of. explain ticketid; Field Type

Re: winmysqladmin

2001-03-07 Thread Pat Sherrill
I seem to get integer size exceeded error windows popping up using winmysqladmin (1.0) against mysqld-opt (3.23.22). This is all on a WIN98 Second Edition box. Any clues? (sorry for the vagueness, it's occurring on a machine not within my immediate reach) Pat...

MYSQL to Oracle

2001-03-07 Thread Mashood Ahmed
Can anybody tell me what datatype exists in Oracle that is similar or could be used instead of BIGINT and TIMESTAMP. Also, what does the LIMIT # expression do in the select query. Can this be converted to be used in Oracle somehow? Thanks Totalise - the Users ISP -- To

Re: mysqld got signal 11

2001-03-07 Thread Sinisa Milivojevic
Steven Roussey writes: Hi, Ah, today's problems are from a bug that dates back a year or more. Streaming a large number of insert delayeds into a table that does not exist causes the crash. The table was not created correctly last night. Is there a web version of mysql code like

MySQL Connections

2001-03-07 Thread Dáire Treanor
Hi, I am currently working on a project in which we are using MySQL to store data. The database server (basic installation) is installed on Windows NT version 4. We are currently doing some load testing on the software and have encountered some problems. The database server is hanging. Our

Version No

2001-03-07 Thread Cal Evans
I just d/loaded and compiled the mysql-3.23.33.tar.gz from www.mysql.com. However, after make and make install, restarting mysql, if I type mysqld --version I get: mysqld Ver 3.23.22-beta for pc-linux-gnu on i686 Did they just not change the version number or is there something else I need to

Re: Bug with 'show databases|tables'

2001-03-07 Thread Canadian Lumberer
Hi, I hope to be helpful for further investigation of the problem. On Wed, Mar 07, 2001 at 08:20:16AM +0700, Eugene Lineitzev wrote: Description: I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14 all 'show' commands doesn't works. They display empty tables. In

Re: key lengths

2001-03-07 Thread Mike Thompson
Yes, I've tries that here is the error I get. Your MySQL connection id is 247 to server version: 3.23.33 mysql CREATE TABLE foo( - id INT NOT NULL AUTO_INCREMENT, - name BLOB NOT NULL, - PRIMARY KEY(id), - UNIQUE(name(500)) - ); ERROR 1089: Incorrect sub part key. The

RE: INSERT question...

2001-03-07 Thread Johnny Withers
After doing an INSERT, you may do SELECT last_insert_id(); and it will return the last id the last INSERT command used. it doesn't matter if your MySQL server is very busy doing inserts, if you call 'SELECT last_insert_id()' right after the INSERT, you will get the correct value.

Re: Join syntax

2001-03-07 Thread Jack Rhinesmith
I don't know what you are trying to accomplish but here is the way I would build a table using ALL the data field from two tables. first is a straight join which will only build the records that have an equal in both tables. insert into tbla select distinct tblb.*, tblc.* from tblb, tblc where

Re: Off Topic Perl Mysql modules install problem

2001-03-07 Thread Gerald L. Clark
Curtis Maurand wrote: Hello, I'm now lost. I cannot figure out what the make file is looking for. Anyone have any ideas? LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.9 6" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o

Re: can't start mysql

2001-03-07 Thread Gerald L. Clark
foxwoo wrote: Dear, I use Red Head 6 with mysql, php3 and apache, past all of them are work well, but one day the our DNS had some problem, after solve the DNS problems, we found we cannot restart our mysql. The error message is "mysqld daemon ended". The host.err is as below:

Re: Intermittent hang on UPDATE foo = foo + 1

2001-03-07 Thread Gerald L. Clark
[EMAIL PROTECTED] wrote: Description: Sometimes the query below appears to hang on the table below. The problem seems worse on queries which come from a webserver, where persistent DB connections are used. : The online manual page hints at the same problem

Re: Beginner Help, can't get it started, but did in the past

2001-03-07 Thread Gerald L. Clark
Joseph Greenawalt wrote: Hello all, I hope someone can help. I have a fresh install of Red Hat 7.0, I installed mysql-3.23.22-6.i386.rpm and then mysql-server-3.23.22-6.i386.rpm. Supposedly the daemon is automatically starts, well it doesn't. I tried the mysql_install_db and it runs,

RE: Off Topic Perl Mysql modules install problem

2001-03-07 Thread Robin Keech
its looking for the z compression library. To fix do this 1) perl Makefile.PL 2) cd mysql 3) vi Makefile 4) search for line LDLOADLIBS and add -lz to end 5) cd .. 6) make 7) make test 8) make install Robin -Original Message- From: Curtis Maurand [mailto:[EMAIL PROTECTED]] Sent: 06

Dying Server

2001-03-07 Thread Chris Cameron
Whenever my MySQL server (3.23.33) is under heavy load it restarts itself. Stopping whatever was connected to it at the time. In my .err log I've just got; 010307 00:12:32 mysqld started /usr/local/libexec/mysqld: ready for connections Killed 010307 00:16:56 mysqld restarted

Plans for implementing user-/passwordauthentification against LDAP

2001-03-07 Thread Helmut Wirth
Are there any plans for authentification of users in mysql against an LDAP directory insteed of the mysql user table? Or is there a patch known? -- Helmut Wirth [EMAIL PROTECTED] - bison GmbH phone +49 89 / 50

Re: Running a Query Append in Access 97 with a linked MySQL table

2001-03-07 Thread Miguel Angel Solórzano
At 16:56 06/03/2001 -0500, [EMAIL PROTECTED] wrote: Hi, If you are using Access as front end, when you build the update or append query you can use an expression like: My Name: [TableName]![ColumnName] You can do this manually or using the builder query of Access. Regards, Miguel Hello I have

myisamchk errors

2001-03-07 Thread Don Bowyer
I recently upgraded our database from 3.22.32 to 3.23.32 We run a ISAM check every night, to check for db problems. Ever since I did the change, I get a email from the cron daemon like this: /usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI /usr/bin/myisamchk: warning: 1

Re: sql date worries

2001-03-07 Thread Bob Hall
Hi all, Im kind of strugling with a query for some time now and I need extra input: What is the desired answer from mysql: a date. what is the input: a week number What dat do I need: The date of the monday (week starts at sunday) in the weeknumber. something like: select

Re: Version No

2001-03-07 Thread Peter Skipworth
Sounds like it installed to a different directory than the previous version - try /usr/local/bin/mysqld --version or /usr/local/mysql/bin/mysqld --version It would be a good idea to remove any previous binaries to avoid confusion, as well. Cheers, P On Wed, 7 Mar 2001, Cal Evans wrote: I

Re: Sending data, but no data sent?

2001-03-07 Thread Sinisa Milivojevic
Matthias Urlichs writes: Hi, select * from ticketid where id like "123%" correctly uses the above index, but a more restrictive query, i.e. select * from ticketid where id like "123%" and id = 123 doesn't. This is _not_ the expected result. -- Matthias

Re: Sending data, but no data sent?

2001-03-07 Thread Matthias Urlichs
Hi, Sinisa Milivojevic: And what happens if you put quotes ??? ... id = '123'... Then it works, of course. But the nice thing about the numeric select is that it also accepts values like 123x45 or 123-45-67 (but not 1234), which is why I wanted to use it. -- Matthias Urlichs |

Configure issue

2001-03-07 Thread Phillip Bruce
Hi, I have some problem running the ./configure command for version mysql-3.23.33 see below: checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have

C API problem

2001-03-07 Thread john1
dear Sir : MySQL 3.22 on my linux 486 PC seems work so good. when I compile a simple C API program which catched from the MySQL tutorial, it chokes at the end of compile process . the program is as follows: #include stdio.h #include mysql.h #define def_host_name NULL #define def_user_name

Re: Long deletes

2001-03-07 Thread Vivek Khera
"MV" == Michael Villalba [EMAIL PROTECTED] writes: MV Thanks, Fred. The delete job has been running for 21 hours MV at this point, and now rather simple queries on other tables hang MV (e.g. SELECT COUNT(*) FROM other_table WHERE index=some_value). MV I'll let it run overnight to see what

DBI for Windows

2001-03-07 Thread mysql
Dear Sirs: Please can you tell me where I can get the Perl DBI interface for Windows ??? Ernesto - Este mensaje fue enviado a través de Qnet http://www.qnet.com.pe - Before

show databases|tables problem

2001-03-07 Thread Paul DuBois
I've been reading the thread about SHOW DATABASES and SHOW TABLES returning lists of blank entries or no results. Just out of curiosity, I upgraded my RedHat 6.2 machine from MySQL 3.23.32 to MySQL 3.23.33 and found that suddenly I had the problem too! However, then I remembered that I'd

Re: Having a hard time installing MySQL

2001-03-07 Thread Vivek Khera
"DN" == Dan Nelson [EMAIL PROTECTED] writes: DN This looks like you used the binary package, right? That was built for DN FreeBSD 4.2, which has a different set of c++ libraries from 4.0. DN You'll have to either upgrade to 4.2, or build mysql from ports. I'd highly recommend upgrading to

Re: Bug with 'show databases|tables'

2001-03-07 Thread Greg Cope
Canadian Lumberer wrote: Hi, I hope to be helpful for further investigation of the problem. On Wed, Mar 07, 2001 at 08:20:16AM +0700, Eugene Lineitzev wrote: Description: I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14 all 'show' commands doesn't

Re: kill bad query

2001-03-07 Thread Steve Ruby
Steve Ruby wrote: If I have a connection that executes a bad query shouldn't I ALWAYS be able to kill it with "kill connect num"? I have a query that keeps getting stuck, (who knows what it is doing) but that State is "statistics" I can't ever kill it without taking down the server..

How to connect applets to MySQL server by using mm.mysql driver?

2001-03-07 Thread Nancy Zheng
Hi, When I read the documents for MM.MySQL driver, I noticed that it is mentioned that MM.MySQL driver can be used to make connections to APPLETS. However, I could not find any further information and examples for this issue. Could you please send me some examples on how to use MM.MySQL driver to

ERROR 1030 at line 1: Got error 127 from table handler

2001-03-07 Thread rmroczk
I am using version 3.32.23 and I receive these errors frequently when using the mysql client using select statements. These messages are showing in the mysqld error log as a result: 010307 0:46:03 read_next: Got error 127 when reading table ./perf/webstats_apollo 010307 9:17:12 read_next:

Re: myisamchk errors

2001-03-07 Thread Joseph Bueno
Don Bowyer wrote: I recently upgraded our database from 3.22.32 to 3.23.32 We run a ISAM check every night, to check for db problems. Ever since I did the change, I get a email from the cron daemon like this: /usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI

Re: desperate for help...

2001-03-07 Thread kentj
It looks like the addition of the distinct verb should do the job if in fact your query only showed the fields on the display. From your Sql however you are selecting more fields than are displayed and some of those are different which distinct will still display. Chris Toth wrote: Ok, I've

Is a commercial license still required?

2001-03-07 Thread Jeff Platzer
I am considering developing an application that relies on MySQL as for database functionality. The application would include MySQL client API calls and be linked with MySQL libraries. It would be distributed with the MySQL database. According to the license terms in MySQL 3.23.30 Reference

Re: file insertion?

2001-03-07 Thread William R. Mussatto
On Tue, 6 Mar 2001, Kevin Connolly wrote: Date: Tue, 6 Mar 2001 18:15:17 - From: Kevin Connolly [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: file insertion? Hi, Is it possible to insert a file into the MySQL database? I want a table = with certain entries such as name, address

Re: Configure issue

2001-03-07 Thread Luis
Phillip Bruce wrote: Hi, I have some problem running the ./configure command for version mysql-3.23.33 see below: checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify

Re: myisamchk errors

2001-03-07 Thread Dan Nelson
In the last episode (Mar 07), Don Bowyer said: I recently upgraded our database from 3.22.32 to 3.23.32 We run a ISAM check every night, to check for db problems. Ever since I did the change, I get a email from the cron daemon like this: /usr/bin/myisamchk: MyISAM file

Re: DBI for Windows

2001-03-07 Thread William R. Mussatto
If you are using a current "activestate" release it should be included, if not use their package manager. On Wed, 7 Mar 2001 [EMAIL PROTECTED] wrote: Date: Wed, 7 Mar 2001 15:59:36 GMT From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: DBI for Windows Dear Sirs: Please can you

Re: Weird select with php

2001-03-07 Thread John Barton
SELECT * FROM members where name like 'A%' ORDER BY RAND(); John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 6 Mar 2001, Matt "TrollBoy" Wiseman wrote: I'm attempting to do a select from my table, but the only odd thing is the customer wants the

Seeing errors/warnings (?) while running wwsympa.fcgi

2001-03-07 Thread Tom Cruickshank
Hello, After having gotten sympa to run (with a few warnings), tried running wwsympa.fcgi for configuration purposes. Unfortunately, kept getting a internal server error. While trying to see what was wrong, I typed "perl wwsympa.fcgi". I received these error/warnings before it outputed the

Re: myisamchk errors

2001-03-07 Thread Don Bowyer
The reason we run the check scripts is because in the past we had all sorts of trouble not with the daemon crashing, but with clients (who have no technical skills) using Access ODBC to update tables, and somehow corrupting them. This way we catch the problems before the client does. Thanks

  1   2   >