3.23.42 3.23.41 won't compile

2001-09-14 Thread David Wartell
Synopsis: 3.23.42 3.23.41 won't compile Release: mysql-3.23.42 (Source distribution) Environment: Redhat Linux 7.0 w/ Linux version 2.2.16-22 gcc version 3.0.1 (3.0 has same results) glibc: 1.2 Build options: CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti

intalling mysql

2001-09-14 Thread bijoy krishna rai
Dear sir, i am trying to intall mysql on red hat linux 6.0 ,pls advise me from where will i get the installable and how to install it with the help of rpm utility. with regards Vijay NIIT_gry - Before posting,

Can't open table after myisamchk

2001-09-14 Thread Jrkeborn Joacim
Hi, I have a table: CREATE TABLE WI_PICTUREFILES ( SECTIONID VARCHAR(50) BINARY NOT NULL, PICTUREID VARCHAR(50) BINARY, PICTUREFILE VARCHAR(200) BINARY NOT NULL, PICFILEXT VARCHAR(5) BINARY NOT NULL, SHEETNO VARCHAR(2) BINARY,

SV: Mysql on HPUX10.20

2001-09-14 Thread Terje Kristensen
Hi Leandro This is a HPUX problem. This errormessage gives you the real problem : : setrlimit couldn't increase number of open files to more than 60 you have to change the kernel settings to allow the OS to use more than 60 simultaneous open files. if you use the sam program and choose sam

problem running mysql_install_db on dec alpha .

2001-09-14 Thread mati
Description: 010907 23:49:36 mysqld started %DECthreads bugcheck (version V3.18-042), terminating execution. % Reason: stkGet: (4) nxm_stack_create (0,5251072,16384,8192) % Running on OSF1 V4.0(1091) on AlphaServer 4100 5/466 4MB, 1024Mb; 2 CPUs, pid 14577 010907 23:49:37 mysqld ended 010914

MySQLGUI remote connection

2001-09-14 Thread Myhra Jens Erik
Hown do I connect to a MySql database that is outside the firewall with mysqlgui? Jens Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: Stuck!

2001-09-14 Thread Simon Green
Try to load MySQL with out --skip-grant-tables. Then you can see what is in your pass word db.. Simon -Original Message- From: David Tomsett [mailto:[EMAIL PROTECTED]] Sent: 14 September 2001 10:05 To: [EMAIL PROTECTED] Subject: FW: Stuck! Hi, I'm moving my intranet to a new server.

AW: Symlinks

2001-09-14 Thread Stefan Pinkert
IMHO it's possible but not the best way. It would be better, if you change the start-Script and point the data-dir to the new location. Stefan -Ursprungliche Nachricht- Von: Keith Woodworth [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 14. September 2001 06:18 An: [EMAIL PROTECTED]

Japanese text in mysql DB

2001-09-14 Thread Steve McKeogh
How do I get Japanese text to be inputted into a mySQL database and get to pull out correctly on the page. I've tested it already by inserting some dummy Japanese text and it inputs itself into the database as complete jibberish. How can I solve this?

Re: Japanese text in mysql DB

2001-09-14 Thread Ian Barwick
On Friday 14 September 2001 12:43, Steve McKeogh wrote: How do I get Japanese text to be inputted into a mySQL database and get to pull out correctly on the page. I've tested it already by inserting some dummy Japanese text and it inputs itself into the database as complete jibberish. How

Re: innoDB , autocommit = 0, lock

2001-09-14 Thread Heikki Tuuri
Bernard, it is not a bug: in MySQL the LOCK TABLES command commits the current transaction. It is in the manual :). The reason is that in MyISAM a transaction is simulated by LOCK TABLES where you lock all the involved tables at once to avoid deadlocks. With InnoDB use of LOCK TABLES is

Connection through Unix Sockets

2001-09-14 Thread Bobby Chopra
Slight problem that's confusing me a bit. Upon connection to mysql using 'localhost' I get the age old error 'Can't connect ... through /tmp/mysql.sock' Before anyone screams - read the archive etc. I have tackled this problem before but this time I am slightly confused. The socket that mysql

adding new native function

2001-09-14 Thread Jaroslav Jkl
Hello, I want to add a new function to mysql. Because i use mysql for windows and there is not implemented adding function through the UDF interface, i must add native function. I did it according to manual, but when i use a new function in select command, it generate error. I think that

bug (+ fix) in mysql_config ! breaks DBD::Mysql

2001-09-14 Thread Greg Cope
Dear Mysqlers mysql_config in the linux binary distro appears to have two similar bugs ... When run it returns: Usage: /usr/local/mysql/bin/mysql_config [OPTIONS] Options: --cflags[-I'/usr/local/mysql/include/mysql'] --libs [-static

bug in join table functions

2001-09-14 Thread Philippe Parmentier
as per the manual, when joining 2 tables, if one entry is not found in the second table , a null records is displayed, but in that small example, it's not working like this: CREATE TABLE test1 ( number tinyint(3) unsigned NOT NULL DEFAULT '0' , PRIMARY KEY (number)); INSERT INTO

Re: Connection through Unix Sockets

2001-09-14 Thread Thomas Spahni
On Fri, 14 Sep 2001, Bobby Chopra wrote: Slight problem that's confusing me a bit. Upon connection to mysql using 'localhost' I get the age old error 'Can't connect ... through /tmp/mysql.sock' Before anyone screams - read the archive etc. I have tackled this problem before but this

Re: bug in join table functions

2001-09-14 Thread Thomas Spahni
On Fri, 14 Sep 2001, Philippe Parmentier wrote: as per the manual, when joining 2 tables, if one entry is not found in the second table , a null records is displayed, but in that small example, it's not working like this: Philippe, the very fine manual says: * If there is no

surely an easy quick one

2001-09-14 Thread Jamie Burns
Hello again :o) This is surely an easy quick one but my brain wont work! I have a table (ref, name, team, seminar_ref) like: 1billsupport100 2billsupport101 3billsupport102 4ben development 201 5ben development 103 6

Re: select from a join (a better/Quicker way??)

2001-09-14 Thread Gerald Clark
add buyer_name index for each table. Simon Buchanan wrote: Huston we have a problem: table1: purchase_order (primary key) client_number buyer_name table2: client_number buyer_number buyer_name (all three combine for the primary key for table2) Query: select

Re: Connection through Unix Sockets

2001-09-14 Thread Bobby Chopra
'which mysql' just kicks back the expected '/usr/bin/mysql' The MySQL install was clean. Bobby - Original Message - From: Thomas Spahni [EMAIL PROTECTED] To: Bobby Chopra [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 14, 2001 12:45 PM Subject: Re: Connection through

Re: using LEFT JOINS

2001-09-14 Thread Gerald Clark
Then add a language column and initialize it to the table name. Deryck Henson wrote: Sure... SQL Query: SELECT * FROM asp, c, cpp, java, javascript, coldfusion, xml, pascal, vb, perl, cgi, php, assembly, python where user = 'user' (gets an ambiguous error and I know why) Database

Re: Connection through Unix Sockets

2001-09-14 Thread Gerald Clark
Create an /etc/my.cnf file and add entries for the socket location. Bobby Chopra wrote: 'which mysql' just kicks back the expected '/usr/bin/mysql' The MySQL install was clean. Bobby - Original Message - From: Thomas Spahni [EMAIL PROTECTED] To: Bobby Chopra [EMAIL

Re: surely an easy quick one

2001-09-14 Thread Stefan Pinkert
select count(*) from table where team='support' group by team -Ursprüngliche Nachricht- Von: Jamie Burns [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 14. September 2001 15:09 An: [EMAIL PROTECTED] Betreff: surely an easy quick one Hello again :o) This is surely an easy quick one but

Re: surely an easy quick one

2001-09-14 Thread Lezz Giles
I haven't tested this; I'm not an SQL guru. I just like a challenge :-) SELECT COUNT(*) FROM table WHERE team = support GROUP BY name; Lezz Giles - Original Message - From: Jamie Burns [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 14, 2001 9:08 AM Subject: surely an

problems with a fairly basic join..

2001-09-14 Thread Chad Day
been banging at this for a while, can't get my head around it. 3 tables, one called news that stores news items, one called comments that stores user comments, one called authors that holds the author of the news items name. I am trying to display the news item with the authors name, and count

Add user and set password

2001-09-14 Thread j . stary
Hello, My idea is to have several (about 3) databases. Each DB will have one admin, who is responsible for this DB and doesn't have access to other DBs. The problem is, how to set privileges? I did: GRANT ALL PRIVILEGES on DB1.* to admin1@localhost WITH GRANT OPTION; Then if admin1 is

RE: surely an easy quick one

2001-09-14 Thread Colin Partridge
select count(*) from table where team='support' group by team I think that should be a group by name not by team. -- Colin - Before posting, please check: http://www.mysql.com/manual.php (the manual)

MySQL home page redirects to obsolete link (sunsite.dk)

2001-09-14 Thread Andreas
Hi One of your redirections has ceased working. I wanted to download the MySQLGUI 1.7.5 source code, but I couldn't. The erroneous link was: http://mirrors.sunsite.dk/mysql/Downloads/mysqlgui/mysqlgui-1.7.5.tar.gz mirrors.sunsite.dk is for sale now and only displays nasty commercials when

RE: errors 2006 and 2000

2001-09-14 Thread toby coffey
hi just to say thanks for your help. it appears my problems were caused by different versions of myql. apparently UNIQUE command was introduced in MYSQL3.23 and my server is running MYSQL3.22.25 the code that worked in the end was: mysql create table saveMovie ( - id int not null

Re: surely an easy quick one

2001-09-14 Thread Jamie Burns
this doesnt work as i need :o( it returns a count of 9, not 3 in my example. i want to know how many *individual* people are in the database for a given 'team'. in my example there are three in 'support' (this is what i want to know), and they are each in the table three times (this is where

Re: surely an easy quick one

2001-09-14 Thread Aleksandar Bradaric
Hi, idname group_name -- 1bill support 100 2bill support 101 3bill support 102 4bendevelopment 201 5bendevelopment 103 6bendevelopment 204 7bobsupport

Re: surely an easy quick one

2001-09-14 Thread Jamie Burns
this doesnt work as i need either :o( it returns 3 rows, each with a count of 3 inside. i just want to get a *single row* with the number 3 in it (for my example). :o( thanks for trying though... - Original Message - From: Lezz Giles [EMAIL PROTECTED] To: Jamie Burns [EMAIL

New database

2001-09-14 Thread jean.schuller
Hi all, I installed a new linux Red Had version onto a PC. In this Linux, mysql(version 3.23.39) is already installed and mysqld is running. So I want to build a database with mysql but whatever I try to type, I have systematically errors

Re: surely an easy quick one

2001-09-14 Thread Jamie Burns
Ok, i have figured it out... SELECT COUNT(DISTINCT name) from tester WHERE team = 'support' But this doesnt work on my development box which runs an older version of mysql! Does anybody know how to get this type of functionality without the DISTINCT keyword inside count? :o) Jamie. -

RE: Trouble with SELECT * FROM...

2001-09-14 Thread Solsberry, Glendon
Ok, here is my first suggestion, having worked with both now for a while. Don't use the rs.open property. Not only is it slower, but it is more prone to errors... So try it this way: strSQL = SELECT username, codeid FROM user_votes WHERE username = ' user ' Set rs = dbconn.Execute(strSQL) If

RE: surely an easy quick one

2001-09-14 Thread Colin Partridge
this doesnt work as i need either :o( it returns 3 rows, each with a count of 3 inside. i just want to get a *single row* with the number 3 in it (for my example). You just need to add another clause to the where statement SELECT COUNT(*) FROM table WHERE team = support AND user=bob

Re: surely an easy quick one

2001-09-14 Thread Lezz Giles
Yup, you're right. I told you I wasn't an SQL guru :-) How are you running the query, and what do you want to do with the number? If you're calling it from Perl then you could run a variant of the query I gave and just look at how many rows there are in the result. On the other hand, I think

Re: high speed insertion required

2001-09-14 Thread Mark Rissmann
Hello, Is there a way to force the queue to flush? That would be very nice. In delphi and interbase I would use transactions. I would start a transaction and process it every 1000 records. This was pretty efficient and the number of records depended on the amount of ram. Mark p.s. your english

Simple SELECT query (or so I thought)

2001-09-14 Thread Solsberry, Glendon
I am running a stats page for our Genome@Home team, and I'm trying to get a simple SELECT that will get the data that I need... Ok, I have a table setup like this: Genomestats --- usernamevarchar(255) curDate datetime wucount

Re: New database

2001-09-14 Thread Steve Suehring
At 03:58 PM 9/14/01 +0200, jean.schuller wrote: I'm under root and say :mysql -u root -p password and mysql says ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) What can this password be ?? where can I get it ?? Did you set a password with

Simple SELECT query (or so I thought)

2001-09-14 Thread Solsberry, Glendon
I am running a stats page for our Genome@Home team, and I'm trying to get a simple SELECT that will get the data that I need... Ok, I have a table setup like this: Genomestats --- usernamevarchar(255) curDate datetime wucount

Re: New database

2001-09-14 Thread Gerald Clark
there is no password yet. so leave the -p option out. jean.schuller wrote: Hi all, I installed a new linux Red Had version onto a PC. In this Linux, mysql(version 3.23.39) is already installed and mysqld is running. So I want to build a database with mysql

RE: New database

2001-09-14 Thread massey
Go to http://www.mysql.com/doc/ and read through it. Pay very close attention to http://www.mysql.com/doc/U/s/User_Account_Management.html the answere to your question is in there. Cheers M;) -Original Message- FROM: jean.schuller TO: Liste mysql DATE: Fri 9/14/01 8:12 SUBJECT: New

RE: surely an easy quick one

2001-09-14 Thread Colin Partridge
Please ignore my last post. I had lost track of what you were trying to achieve with your query. -- Colin - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re[2]: surely an easy quick one

2001-09-14 Thread Aleksandar Bradaric
Hi, SELECT COUNT(DISTINCT name) from tester WHERE team = 'support' Could 2 queries do the trick? insert into temptable select count(name) from tester where team = 'support' group by team; select count(*) from temptable; Best Regards, Sasa P.S. create table temptable(tempfield

RE: surely an easy quick one

2001-09-14 Thread Colin Partridge
O.k, how about this query. SELECT DISTINCT name,count(1) AS numPeople FROM tester Where team ='support' GROUP BY team Its a bit dirty and it returns an extra column, but this could be ignored -- Colin - Before posting,

NUMERIC field contents

2001-09-14 Thread Jim Dickenson
From http://www.mysql.com/doc/N/u/Numeric_types.html The NUMERIC and DECIMAL types are implemented as the same type by MySQL, as permitted by the SQL92 standard. They are used for values for which it is important to preserve exact precision, for example with monetary data. When declaring a

DBI-1.18.tar.gz Can't gzip -cd

2001-09-14 Thread rjtalbo
I have been trying to uncompress DBI-1.18.tar.gz which I downloaded together with Msql-Mysql-modules-1.2216.tar.gz Data-ShowTable-3.3.tar.gz from the MySQL down load page... I followed the direction in the DBE-1.18 README but if I use the pipe as instructed... gzip -cd DBI-1.18.tar.gz

NUMERIC field contents

2001-09-14 Thread Jim Dickenson
From http://www.mysql.com/doc/N/u/Numeric_types.html The NUMERIC and DECIMAL types are implemented as the same type by MySQL, as permitted by the SQL92 standard. They are used for values for which it is important to preserve exact precision, for example with monetary data. When declaring a

replication and read-only db

2001-09-14 Thread Juraj Bednar
Hello, I'm using a simple master-server replication setup for all the databases. It is great, but sometimes someone tries to insert something into the slave database by mistake. I would like to prevent this, but I also mirror the mysql database (so if something happens with the master,

Re: DBI-1.18.tar.gz Can't gzip -cd

2001-09-14 Thread Ian Barwick
On Friday 14 September 2001 18:31, rjtalbo wrote: I have been trying to uncompress DBI-1.18.tar.gz which I downloaded together with Msql-Mysql-modules-1.2216.tar.gz Data-ShowTable-3.3.tar.gz from the MySQL down load page... I followed the direction in the DBE-1.18 README but if I

Password not working.

2001-09-14 Thread Dave McNicholl
Hi, I have had a mysql database for a few years now. It is used for auth against apache using mod_auth_mysql. My apache conf has the username and password in it. These have not changed for some time. Now when I use mysqldump -u username -p mysql and supply the correct password

Re: DBI-1.18.tar.gz Can't gzip -cd

2001-09-14 Thread Adams, Bill TQO
rjtalbo wrote: I have been trying to uncompress DBI-1.18.tar.gz which I downloaded together with Msql-Mysql-modules-1.2216.tar.gz Data-ShowTable-3.3.tar.gz from the MySQL down load page... I followed the direction in the DBE-1.18 README but if I use the pipe as instructed...

configure with mysql

2001-09-14 Thread Jason Radley
I have installed redhat linux 7.1 with apache, php and mysql but when installed redhat it didn't add the configure --with-mysql it added --without-mysql is there any way to change this to configure --with-mysql. Thanks - Before

Re: Password not working.

2001-09-14 Thread Adams, Bill TQO
Dave McNicholl wrote: Hi, I have had a mysql database for a few years now. It is used for auth against apache using mod_auth_mysql. My apache conf has the username and password in it. These have not changed for some time. Now when I use mysqldump -u username -p mysql and

Re: Fulltext indexing libraries (perl/C/C++)

2001-09-14 Thread ryc
Your original message got through the first time, but your email bounced. I think what you are looking for is called mifluz and is the indexing library that htdig uses. The link is http://www.gnu.org/software/mifluz/ . If you develop any kind of bindings to use mifluz to index a mysql database

Compile error, 3.23.42 error with macro uint8korr

2001-09-14 Thread shane
Description: I am attempting to compile 3.23.42 for testing the innodb and gemini tables. I'm also going to test the RAID tables. The configure works fine. However, when the compiler enters the sql directory there is an error in field.cc, this is shown below

Re: configure with mysql

2001-09-14 Thread Trond Eivind Glomsrød
Jason Radley [EMAIL PROTECTED] writes: I have installed redhat linux 7.1 with apache, php and mysql but when installed redhat it didn't add the configure --with-mysql it added --without-mysql is there any way to change this to configure --with-mysql. Just install the php-mysql package -

Re: configure with mysql

2001-09-14 Thread Dr. Randy Frid
I have the exact problem. If anyone has a step by step for a newbie I'd appreciate it as well. Cheers, Randy - Original Message - From: Jason Radley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 14, 2001 9:06 AM Subject: configure with mysql I have installed redhat

Re: configure with mysql

2001-09-14 Thread Dr. Randy Frid
I've tried that to no avail. Everything on my system works perfectly except for this. The MySQL website indicates the following: --- Error: Fatal error: Call to unsupported or undefined function mysql_connect() in .. This means that your PHP version isn't compiled with MySQL support.

RE: configure with mysql

2001-09-14 Thread Jason Radley
I have tried also and nothing. I have added the phpinfo(); and it tells me the configure command says --without-mysql No ideas here. -Original Message- From: Dr. Randy Frid [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 10:53 AM To: Jason Radley; Trond Eivind Glomsrød Cc:

Re: configure with mysql

2001-09-14 Thread massey
My Steps Everything is built in /usr/local and untar'd using -xvf MySQL First of course I left this out since it's straight forward. ./configure make make install Apache 1.3.20 Next ./configure -enable-module=most --enable-shared=max ***(This enables the DSO support) *** make then make

Re: Compile error, 3.23.42 error with macro uint8korr

2001-09-14 Thread Trond Eivind Glomsrød
*mysql-list has an annoying filter* [EMAIL PROTECTED] writes: Environment: machine, os, target, libraries (multiple lines) System: Linux homer 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 It would be useful if you made sure that all errata are applied to

creating tables using a number

2001-09-14 Thread powlow
Hi, first posting to the list so hello. My name is Paulo. I live and work in lisbon, portugal. question : i want to create a table each month. want to call it somehting like 012001 for January 2001. mysql does not seem to allow this. Jan2001 is fine. d122001 is also fine. is it not possible to

Re: configure with mysql

2001-09-14 Thread Trond Eivind Glomsrød
Dr. Randy Frid [EMAIL PROTECTED] writes: I've tried that to no avail. Everything on my system works perfectly except for this. The MySQL website indicates the following: Tried what? There is a specific php-mysql module. When you install that (restart of apache may also be necesarry), it

Error 10061

2001-09-14 Thread dboothe
I have an error situation that I cannot resolve. I have a number of MySQL DBs on a FreeBSD server and use MyODBC to hook into them via an MS-Access front end. All goes well in that setup. Recently I had a few site migrate to a RedHat server. I set up MySQL on the new server and all went

Install PHP

2001-09-14 Thread massey
After untaring each with tar -xvf this create's each new directory. /usr/local/mysql-3.22.32 /usr/local/apache_1.3.20 /usr/local/PHP 4.04i Next cd to mysql and ./configure then make and last make install Next cd to Apache Apache 1.3.20 Next ./configure

Re: creating tables using a number

2001-09-14 Thread Adams, Bill TQO
powlow wrote: first posting to the list so hello. My name is Paulo. I live and work in lisbon, portugal. question : i want to create a table each month. want to call it somehting like 012001 for January 2001. mysql does not seem to allow this. Jan2001 is fine. d122001 is also fine. is it

Re: MySQL home page redirects to obsolete link (sunsite.dk)

2001-09-14 Thread indrek siitan
Hi, I wanted to download the MySQLGUI 1.7.5 source code, but I couldn't. The erroneous link was: http://mirrors.sunsite.dk/mysql/Downloads/mysqlgui/mysqlgui-1.7.5.tar.gz mirrors.sunsite.dk is for sale now and only displays nasty commercials when accessed. hm, from where I'm at, the

Re: Full text search algorithm

2001-09-14 Thread Sergei Golubchik
Hi! On Sep 10, [EMAIL PROTECTED] wrote: Where can I find a description of the algorithm that mysql uses for weighting results from a full text search? in the source myisam/ftdefs.h Is there a way to provide some user specified criteria to alter the weighting? (i.e. a callback mechanism)

Re: configure with mysql

2001-09-14 Thread Dr. Randy Frid
You're a good man Charlie Brown!!!. You were right on the money. I found the module on CD2, loaded it, rebooted the server and I was off to the races. Works perfectly. Life is good when you get good advice. Thanks. - Original Message - From: Trond Eivind Glomsrød [EMAIL PROTECTED]

Re: creating tables using a number

2001-09-14 Thread Paul DuBois
At 6:39 PM +0100 9/14/01, powlow wrote: Hi, first posting to the list so hello. My name is Paulo. I live and work in lisbon, portugal. question : i want to create a table each month. want to call it somehting like 012001 for January 2001. mysql does not seem to allow this. Jan2001 is fine.

Re: creating tables using a number THIS IS A BUG

2001-09-14 Thread Igbar Foosenhopper
FYI .. I just tried this my self with CREATE TABLE 010823 (tstamp TIMESTAMP (14) , name VARCHAR (10) not null , PRIMARY KEY (tstamp), INDEX (name)) and got ... MySQL said: You have an error in your SQL syntax near '010823 (tstamp TIMESTAMP (14) , name VARCHAR (10) not null ,

Re: Password not working.

2001-09-14 Thread Dave McNicholl
Yup. amazingly enough the password entry in the user table was empty. I have no idea how this was empty. I am the only admin on the machine and I didn't do it. mysqladmin Ver 7.11 Distrib 3.22.22, for pc-linux-gnu on i686 TCX Datakonsult AB, by Monty Server version 3.22.22 Protocol

problems with a fairly basic SELECT/JOIN...

2001-09-14 Thread Chad Day
Sending this out again, haven't gotten any help yet.. anyone? -Original Message- From: Chad Day [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 9:38 AM To: mysql Subject: problems with a fairly basic join.. been banging at this for a while, can't get my head around it. 3

Re: creating tables using a number THIS IS A BUG

2001-09-14 Thread indrek siitan
Hi, SO this does seem like a bug .. hope MySql guys see this. I have looked but can't find anything about how to contact in case of bugs .. mail to [EMAIL PROTECTED] :-) Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/

Re: creating tables using a number

2001-09-14 Thread Andreas Karl Wittwer
Hello, On Fri, 14 Sep 2001, powlow wrote: fine. d122001 is also fine. is it not possible to create tables with only a number as the name? is there a way round this? mysql CREATE TABLE `123` (id INT); Query OK, 0 rows affected (0.00 sec) mysql show tables; ++ |

download_file is not available?!

2001-09-14 Thread Manfred Aigner
hi ! seems like - if Win32 static binary of MySQLGUI 1.7.5-2 ( found at http://www.mysql.com/downloads/gui-mysqlgui.html ) seems to be down/missing... please fix - it - thanx lg fred - Before posting, please

Re: DBI-1.18.tar.gz Can't gzip -cd

2001-09-14 Thread Colin Faber
I would even suggest not using zcat given the solaris version only examins .Z files. try: cat DBI-1.18.tar.gz | gunzip - | tar xvf - this should work on all versions of solaris any just about any other unix (assuming gzip is installed with a working tar) Adams, Bill TQO wrote: rjtalbo

mysql 3.23.42 hangs on solaris 7

2001-09-14 Thread Jon Drukman
i have been running 3.22.25 on solaris 7 for quite a while. i ran into a problem with it a few days ago where it basically took forever to delete rows (these are huge tables - several million rows, with lots of indexes, and i needed to delete some millions of rows... i started it, and let it

Re: problems with a fairly basic SELECT/JOIN...

2001-09-14 Thread Dana Powers
Try this: SELECT news.NEWSID, news.DATETIME, authors.AUTHOR, count(comments.CID) as NUMCOMS from news LEFT JOIN authors ON news.AUTHORID=authors.AUTHORID LEFT JOIN comments ON news.NEWSID=comments.NEWSID GROUP BY news.NEWSID ORDER BY news.DATETIME; I havent tested this, and you may have to add

Re: creating tables using a number THIS IS A BUG

2001-09-14 Thread Paul DuBois
At 11:17 AM -0700 9/14/01, Igbar Foosenhopper wrote: FYI .. I just tried this my self with CREATE TABLE 010823 (tstamp TIMESTAMP (14) , name VARCHAR (10) not null , PRIMARY KEY (tstamp), INDEX (name)) and got ... MySQL said: You have an error in your SQL syntax near '010823

Re: Compile error, 3.23.42 error with macro uint8korr

2001-09-14 Thread Shane Corgatelli
It compiles here, on a Roswellish system (and slightly different opions - no Gemini, only BDB and innodb) I removed the --with-gemini option and everything compiles beautifully. I tried it with the mysql+gemini-3.23.41 source and I still get errors. I wanted to compare Innobase and Gemini,

Re: Compile error, 3.23.42 error with macro uint8korr

2001-09-14 Thread Trond Eivind Glomsrød
Shane Corgatelli [EMAIL PROTECTED] writes: It compiles here, on a Roswellish system (and slightly different opions - no Gemini, only BDB and innodb) I removed the --with-gemini option and everything compiles beautifully. I tried it with the mysql+gemini-3.23.41 source and I still get

Performance Benchmarks

2001-09-14 Thread Jeff Hinds
Has anyone used MySQL with perl to create a web interface with a database that contains 100 or more tables that have 200,000 to 500,000 rows of data each? I am interested to know if any performance issues have been encountered and if any solutions were found. We are looking to create a new

intro mysql book

2001-09-14 Thread another oracle dba
Can someone recommend an intro MySQL book. I'm looking for a book with info on MySQL internals from the dba standpoint as well as usage from a developer standpoint. I'm going to take a look at MySQL by Paul Dubois. It seems to have good reviews, but would be interested in other recommendations.

mySQL: ORDER

2001-09-14 Thread Russ
how do i sort my results by reverse order ?? say the collume containts 1 2 3 4 , if i use ORDER BY VOTES it returnes 1234 but i wont it in revers 4321 etc is there any way i can do this with a sql function? Russ - Before

Re: mySQL: ORDER

2001-09-14 Thread Dan Nelson
In the last episode (Sep 14), Russ said: how do i sort my results by reverse order ?? say the collume containts 1 2 3 4 , if i use ORDER BY VOTES it returnes 1234 but i wont it in revers 4321 etc is there any way i can do this with a sql function? ORDER BY VOTES DESC -- Dan Nelson

Re: mySQL: ORDER

2001-09-14 Thread Paul DuBois
At 11:27 PM +0100 9/14/01, Russ wrote: how do i sort my results by reverse order ?? say the collume containts 1 2 3 4 , if i use ORDER BY VOTES it returnes 1234 but i wont it in revers 4321 etc is there any way i can do this with a sql function? ORDER BY VOTES DESC DESC = descending (reverse)

Re: mySQL: ORDER

2001-09-14 Thread Dana Powers
d00d. manual. search it. http://www.mysql.com/doc/S/o/Sorting_rows.html ORDER BY VOTES DESC dpk - Original Message - From: Russ [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 14, 2001 3:27 PM Subject: mySQL: ORDER how do i sort my results by reverse order ?? say the

RE: mysql install failed on FreeBSD!!

2001-09-14 Thread Siva Namburi
I have FreeBSD 4.3-stable release. Yes the ports collection was also upgraded. How do i know the version of ports collection. thanks, siva -Original Message- From: Chris Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 7:15 PM To: [EMAIL PROTECTED]; [EMAIL

Re: creating tables using a number THIS IS A BUG

2001-09-14 Thread Matt Wagner
indrek siitan writes: Hi, SO this does seem like a bug .. hope MySql guys see this. I have looked but can't find anything about how to contact in case of bugs .. mail to [EMAIL PROTECTED] :-) er, [EMAIL PROTECTED] -- For technical support contracts, visit https://order.mysql.com/

Re: mysql install failed on FreeBSD!

2001-09-14 Thread Siva Namburi
I have FreeBSD 4.3-stable release. Yes the ports collection was also upgraded. How do i know the version of ports collection. thanks, siva What version of FreeBSD do you have installed? Was it upgraded from an earlier version? If so, was the ports collection upgraded as well? This sounds

What datatype for an IP Address Field

2001-09-14 Thread Deryck Henson
I need to know the type of data to use for me to put in an IP Address. I tried INT and BIGINT. Neither worked HELP! I need this for my database bad! - Deryck H - http://www.comp-u-exchange.com - Before posting, please

Re: What datatype for an IP Address Field

2001-09-14 Thread Paul DuBois
At 8:36 PM -0500 9/14/01, Deryck Henson wrote: I need to know the type of data to use for me to put in an IP Address. I tried INT and BIGINT. Neither worked HELP! I need this for my database bad! If you expect to represent them in dotted-quad notation, use CHAR(15). If you want to represent

VB ADO Picture Data Type

2001-09-14 Thread Jason Kwok
What data type should be used to store jpeg with MySQL connecting with VB ADO. I think the answer would probably be Blob or Long Blob, but how? VB complains MySQL's Long Blob data type is not compatible! -Jason - Before

Re: surely an easy quick one

2001-09-14 Thread Chris Johnson
If you want a count for a specific team: Select count(*) From table Where team = 'support'; If you want the counts for all the teams: Select team, count(*) From table Group By team; - Original Message - From: Jamie Burns [EMAIL PROTECTED] I have a table (ref, name, team, seminar_ref)

Re: surely an easy quick one

2001-09-14 Thread Chris Johnson
Woops! Nevermind. I didn't notice your data was denormalized. - Original Message - From: Chris Johnson [EMAIL PROTECTED] To: Jamie Burns [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 14, 2001 10:33 PM Subject: Re: surely an easy quick one If you want a count for a

quick question about set

2001-09-14 Thread Lance Rochelle
OK quick question, Is there a limit to the amount of data the can be defined when I create a field as a set. I am looking to have about 39 words in there at the moment I have them in another table and have an index pointing to them, but would like to move them to a set. if it is possible thanks

Opportunity of a Lifetime!! - adv

2001-09-14 Thread Lisa
Dear Friends Future Millionaire: AS SEEN ON NATIONAL TV: Make over half million dollars every 4 to 5 months from your home for an investment of only $25 U.S. Dollars expense one time THANKS TO THE COMPUTER AGE AND THE INTERNET ! == BE A

  1   2   >