Recursion

2003-02-11 Thread Rob
Hi all, I need some help with recursion in mySql. I have the following table: ID | Name | ParentID 1 | Bob | 0 2 | John | 1 3 | Elm | 1 etc. For a given ID, I need to recurse up the tree and get all the parents. I've already read about Joe Celko's nested set approach

Recursion

2003-02-11 Thread Rob
Hi all, I need some help with recursion in mySql. I have the following table: ID | Name | ParentID 1 | Bob | 0 2 | John | 1 3 | Elm | 1 etc. For a given ID, I need to recurse up the tree and get all the parents. I've already read about Joe Celko's nested set approach,

Re: Needed full table scan over 1,2 GB is toooooo slow

2003-02-11 Thread Jeremy Zawodny
On Wed, Feb 12, 2003 at 08:06:03AM +0100, Nico Rehmann wrote: > Hi, > > I have a big problem. > I NEED to do a full table scan every month on a table. > I really need all of the data in this table > This table has about 1,2 GB of data. > It takes mysql about 45 minutes to send the data. > > I con

Needed full table scan over 1,2 GB is toooooo slow

2003-02-11 Thread Nico Rehmann
Hi, I have a big problem. I NEED to do a full table scan every month on a table. I really need all of the data in this table This table has about 1,2 GB of data. It takes mysql about 45 minutes to send the data. I configured mysql with the my-huge.cnf and I also tried "record_buffer=50M" but no

mysqladmin password has no effect in 4.0.10 gamma max-nt.

2003-02-11 Thread Dan Ertman
Hello, The documentation says that in order to change the root user's password, you should run C:\mysql\bin\mysqladmin -u root password your_password I have tried this multiple times, on Windows 2000 and Windows XP, running mysql as a service (mysql-max-nt), and it has had no effect on the root use

Re: Insert & Replication issues...

2003-02-11 Thread Jeremy Zawodny
On Wed, Feb 12, 2003 at 10:59:00AM +0800, Trevor Phillips wrote: > I have a setup of 3 servers, with MySQL replication in a round-robin fashion > between all 3. So far, any writes to a particular table are done only on one > machine at any time. The replication is used as a hot backup, not a > l

Re: [mysql] Counting rows

2003-02-11 Thread Ahmed S K Anis
show table status: check out the columns names you will get as idea as to how info it gives. >>> olinux <[EMAIL PROTECTED]> Wednesday, February 12, 2003 12:21:16 PM >>> SELECT count(*) FROM table WHERE whatever olinux --- Tim Johnson <[EMAIL PROTECTED]> wrote: > Hello All: > Let's sup

Re: [mysql] Counting rows

2003-02-11 Thread olinux
SELECT count(*) FROM table WHERE whatever olinux --- Tim Johnson <[EMAIL PROTECTED]> wrote: > Hello All: > Let's suppose I want to count the rows in set > for a match > to a value in a column. I don't need to read the > selection > set, I just need to know the number of matches. > > What is

RE: RAND is mysql 3.22

2003-02-11 Thread Daniel Rossi
hi guys i just tried this on my works old mysql server and it doesnt seem to work , is it possible ? :| - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Insert & Replication issues...

2003-02-11 Thread Trevor Phillips
I have a setup of 3 servers, with MySQL replication in a round-robin fashion between all 3. So far, any writes to a particular table are done only on one machine at any time. The replication is used as a hot backup, not a load-balancing thing. I now have an instance where I'd like to do inserts

RE: Is there a SQL/diff program out there?

2003-02-11 Thread Lance Lovette
I've been happy with mysqldiff. http://adamspiers.org/computing/mysqldiff/ Lance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-11 Thread Steff
Hi Mark, Thanks for taking the time to reply. I like the idea of changing our counter model to reduce the contention around the one file. I will talk to the other developers about this. I re-read the reference you mentioned "http://www.innodb.com/ibman.html#InnoDB_restrictions";

Mysqld not starting as user "mysql"

2003-02-11 Thread Guild N Crantz
I have just installed mysql-max-3.23.55-pc-linux-i686.tar.gz and now I'm finding it impossible to run mysqld without being root. The permisions for the mysql data tree are all set with user and group "mysql". However when I run mysql.server I get permission denied errors: Starting mysqld daemon

[Announcement] for PHP and MySQL 4.1 Users/Testers

2003-02-11 Thread Georg Richter
Hi, The new mysql extension (ext/mysqli) is now in the php-cvs-repository. Please note that you need MySQL Version 4.1 (both server and client library) and that this extension has experimental status. Configuration: --with-mysqli=/path-to-mysql-4.1 -without-mysql If you want to use both ext/

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-11 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: Hello, We are experiencing severe problems when running MySql with INNODB in a production environment. Applications which work fine under light load fail when under production load. Our MySql environment is as follows

Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-11 Thread Steff
Hello, We are experiencing severe problems when running MySql with INNODB in a production environment. Applications which work fine under light load fail when under production load. Our MySql environment is as follows: OS Platform: Windows 2000 Service Pack 2 Machine description: C

bug with MERGE tables and MAX

2003-02-11 Thread spencer
>Description: MAX fails to return the correct value in some MERGE table situations. Based on experimentation I am guessing that the query fails to read all of the member tables when the query can be performed entirely by reading the index. I seem to be able to reproduce this every time on MySQL 3

Re: Full text search

2003-02-11 Thread MySQL server
Hi Try this. select * from table where upper(text) like upper('%dog%') Then all words with 'dog' in it, will appears in your query. Hope this helps /Frank > > I'm working on a full text search that will search through subject > lines. The search word is not necessarily a discreet word bu

wrong Polish translation in mysql 3.23.52 (and previous)

2003-02-11 Thread misiek
>Description: Wrong translation of YES/NO for Polish language. They are swapped. Same bug in mysql 4.0.10. >How-To-Repeat: Look into sql/share/polish/errmsg.txt >Fix: Here is patch that fixes problem: diff -urN mysql-3.23.55.org/sql/share/polish/errmsg.txt mysql-3.

Why no console window?

2003-02-11 Thread Don Barton
I am new to mysql, but am learning fast. I have recently downloaded several front-ends to Mysql. I used some, deleted others. In the process of this, I lost the ability to use the default Mysql console window for inputting data. The front ends are fine, but I would like to still learn the syntax n

Full text search

2003-02-11 Thread Gord Muir
I'm working on a full text search that will search through subject lines. The search word is not necessarily a discreet word but could be a fragment like ... dog where dog could appear as hotdog, doggone, dognapper etc. My question is, is there a way of wildcarding the search request to look

Strange sorting in table

2003-02-11 Thread Viktor Vasiliou
Hi! I have a couple of tables in a MySQL database. In one of the tables, PhpMyAdmin sorts very strange. ID 1002 is places between ID 21 and ID 22. Any idea why? Best Regards, Viktor Vasiliou - Before posting, please check:

Re: Slow Fulltext Index Creation

2003-02-11 Thread Sergei Golubchik
Hi! On Feb 12, Peter Bryant wrote: > Hi. I'm adding a fulltext index to two fields in a large (2300MB) table. > > The index created the first 200MB or so of data pretty quickly (in a couple > of hours), but progress from there has been very slow. > > After 48 hours the temporary table is only

Re: Maximum of 16 indexes per table

2003-02-11 Thread Seth Price
I have a table of between 90-100 columns and currently 70k rows. I don't care how long it takes to enter the data, but I would like to select it as fast as possible. Each column should be theoretically queried as much as any other. Right now I am using static MyISAM tables, which seem good enough f

RE: Safe way to allow users to create databases?

2003-02-11 Thread Sherzod Ruzmetov
: Is there a safe way to allow ordinary users, who should : not have MySQL root privileges, to create databases using : any name they choose? It seems to me that I would need to : use "GRANT ALL ON *.* TO user WITH GRANT OPTION". This : would be dangerous because of the othe

Re: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)

2003-02-11 Thread Sergei Golubchik
Hi! On Feb 05, Tue Tønning wrote: > Hey, > > I have discovered a strange error in the mysql versions mentioned in subj. > > Example. > A table with 10 entries ...i want to draw 3 randomly > => "select fieldName from tableName order by RAND() limit 3" > > this have worked for the last year or so

Re: Safe way to allow users to create databases?

2003-02-11 Thread Stefan Hinz
Kevin, > Is there a safe way to allow ordinary users, who should not have MySQL root >privileges, to create databases using any name they choose? It seems to me that I >would need to use "GRANT ALL ON *.* TO > user WITH GRANT OPTION". This would be dangerous because of the other user's >databas

re: newbie sql statement help

2003-02-11 Thread The Mindflayer
This might help. http://www.mysql.com/doc/en/example-Maximum-column-group-row.html I had the same problem. Before I found the webpage above, I went with a less efficient but simpler way. I wanted the highest revision ("revision") for each news article ("id"). $SQL = "CREATE TEMPORARY TABLE

Safe way to allow users to create databases?

2003-02-11 Thread KEVIN ZEMBOWER
Is there a safe way to allow ordinary users, who should not have MySQL root privileges, to create databases using any name they choose? It seems to me that I would need to use "GRANT ALL ON *.* TO user WITH GRANT OPTION". This would be dangerous because of the other user's databases and the mysq

Re: client side RAD

2003-02-11 Thread Kim Kohen
G'day Charles > I am desperately searching for a GUI RAD environment to develop database > applications for MySQL. Try www.servoy.com and you might find what you're looking for cheers kim - Before posting, please check:

Re: IP Addresses -- How to Store

2003-02-11 Thread Michael T. Babcock
On Tue, Feb 11, 2003 at 03:34:52PM -0500, Peter Grigor wrote: > Dood, he's not gonna be very happy storing an IP as 16 bits :) Excuse my long day; 32 bits would be much more useful. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, SQL) http://www.fibresp

Re: need 4.1 binaries

2003-02-11 Thread Ian Li
I am waiting for Mysql's UTF8 support as well. NOt sure if the binaries can solve your issue, according what I know, we need to specify the charset information in configuration/compilation time inorder to enable UTF8. I actually tried to build mysql 4.1 out of the source tree(my system is RH 8

Re: Migrating Microsoft Access to MySQL

2003-02-11 Thread Insanely Great
there is a tool called SQLyog at http://www.webyog.com/sqlyog/download.html It has a very good ODBC import tool which will import your Access data to MySQL without any fuss and its FREE!!! Insane - Original Message - From: "Edward Kim" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wed

Re: socket error

2003-02-11 Thread gerald_clark
chown -R mysql.mysql/var/lib/mysql Substitute the actual location where mysql stores its data files. J. A. Tovey wrote: ok :) all killed now, (not quite there yet though :)) I am now getting the error: 030211 16:26:51 mysqld started 030211 16:26:51 /usr/local/mysql/bin/mysqld: Can't

Re: IP Addresses -- How to Store

2003-02-11 Thread Peter Grigor
- Original Message - From: "Michael T. Babcock" <[EMAIL PROTECTED]> To: "Aaron Conaway" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 3:25 PM Subject: Re: IP Addresses -- How to Store > On Tue, Feb 11, 2003 at 01:15:01PM -0500, Aaron Conaway wrote: > > I'm

Slow Fulltext Index Creation

2003-02-11 Thread Peter Bryant
Hi. I'm adding a fulltext index to two fields in a large (2300MB) table. The index created the first 200MB or so of data pretty quickly (in a couple of hours), but progress from there has been very slow. After 48 hours the temporary table is only 640MB / 2300MB original table size. I've chang

Compiling on Solaris 2.6

2003-02-11 Thread Jim Sobeck - comcast
I have tried multiple times to build a version of 3.23.55 with support for innodb under Solaris 2.6. I can not upgrade the version of the OS. Here is the error: source='mysql.cc' object='mysql.o' libtool=no \ depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \ depmode=gcc3 /bin/ksh ../depcom

Re: IP Addresses -- How to Store

2003-02-11 Thread Michael T. Babcock
On Tue, Feb 11, 2003 at 01:15:01PM -0500, Aaron Conaway wrote: > I'm looking to develop a database of IP addresses for the company and > have, of course, chosen mySQL as the backend. I want the app to add > (remove, etc.) a host, giving its hostname and segment. The app will > add the next availa

Re: Robot Replies (WAS: Re: support question (win98_se) (auto))

2003-02-11 Thread Michael T. Babcock
On Sun, Feb 09, 2003 at 03:11:54PM -0700, Doug Thompson wrote: > Am I the only one that equates these robot replies with spam? Most of > them are as meaningful as talking to micro$oft. I don't know why they're sent to the list and not to the Sender address. > > > > * http://www.mysql.com/doc

Re: MySQL book TOC

2003-02-11 Thread Michael T. Babcock
On Sat, Feb 08, 2003 at 10:47:55PM -0800, Nasser Ossareh wrote: > > SQL in the "What is SQL?" phrase threw me... I thought > you were talking about MS SQL.. SQL is and should be known as a query language, not a product. It should be perhaps clarified the first time it is used as not refering to t

RE: Strange Updates

2003-02-11 Thread Sherzod Ruzmetov
: > select count(*) from Yellow WHERE MATCH(street_add) : AGAINST('+GUIDO : > +MIGLIOLI' IN BOOLEAN MODE) AND street_short = ''; : > : > and the result was 50 rows in set. : > : > But when I ran the update: : > UPDATE yellowtest.Yellow SET street_short = 'MIGLIOLI'

Migrating Microsoft Access to MySQL

2003-02-11 Thread Edward Kim
I am with a small business in Southern California that would like to migrate our MS Access databases to MySQL server. Are their any computer service companies who can help me? - Before posting, please check: http://www.mysql.

re: problem with the load data

2003-02-11 Thread Egor Egorov
On Tuesday 11 February 2003 18:13, Edgard Dapás wrote: > I'm trying to load a text file, I've extract from access, and Ihave the > following error > > > mysql> LOAD DATA INFILE '/home/dapasedg/provedores.txt' INTO TABLE > proveedores -> FIELDS TERMINATED BY '|' ENCLOSED BY '"'; > ERROR 13: Can't ge

re: Caching queries

2003-02-11 Thread Victoria Reznichenko
On Monday 10 February 2003 17:54, Octavian Rasnita wrote: > Please tell me what should I do to make MySQL cache all the queries that > can be cached. > > Can I do this if I am not the administrator of MySQL server? (on a session > basis...). Take a look at query cache: http://www.mysql.co

re: How to modify ft_min_word_len?

2003-02-11 Thread Egor Egorov
On Monday 10 February 2003 17:55, Octavian Rasnita wrote: > Please tell me how to modify the variable ft_min_word_len. > > I've tried: > > set ft_min_word_len=2; > set @ft_min_word_len=2; > > The second creates a new variable I think and the first one tells me that > there is no such variable. Yo

re: Strange Updates

2003-02-11 Thread Victoria Reznichenko
On Tuesday 11 February 2003 16:21, Daniele Lo Re wrote: > I got weird behaviour from Mysql while doing some updates. > > Before doing the update I did a count, like this: > > > > select count(*) from Yellow WHERE MATCH(street_add) AGAINST('+GUIDO > +MIGLIOLI' IN BOOLEAN MODE) AND street_short = ''

RE: IP Addresses -- How to Store

2003-02-11 Thread Aaron Conaway
Thanks to Peter, Ravi, and Dan. That's exactly what I needed to know. -- Aaron Conaway Network Engineer III Verisign, Inc. -- Telecom Services Division http://www.verisign.com Office: 912.527.4343 Fax: 912.527.4014 -Original Message- From: Peter Hicks [mailto:[EMAIL PROTECTED]

Re: encrypted password

2003-02-11 Thread Sergei Golubchik
Hi! On Feb 04, Jianping Zhu wrote: > > I have mysql in a redhat machine. I need to use mysql do user > authentication to a website. > I have a table like following. > > +--+--+ > | username | passwd | > +--+--+ > | jianping | jian1830 | > | chichi | jian1830 |

newbie sql statement help

2003-02-11 Thread Bob Ramsey
The people who run our mysql server are using version 3.23.51, so I don't have access to some of version 4's features like sub selectes. I have a table with data like this: firm firm_rank time time_rank student A 1 10 1 jones A 1 10 1 smith A 1 10 1 alvin A 2 10 1 bob A 2 10 2 charlie

**RE: client side RAD**

2003-02-11 Thread Kevin Gale
Charles. Have you tried Omnis Studio (www.omnis.net). It's a 4GL RAD which supports Mac Classic, OSX, Windows, Linux and Solaris. I use the Mac and Windows version nearly everyday and find it an excellent tool for creating database front-ends (mySQL access is via ODBC). The Omnis-Underground host

Re: Maximum of 16 indexes per table

2003-02-11 Thread Seth Price
Has the maximum number of keys in a MyISAM table been tested more since this post? Is it possible to get above 64 keys? (I'm going for 90, btw) ~Seth to get past spam filter: MySQL sql query Subject: Re: Maximum of 16 indexes per table From: Michael Widenius Date: Fri, 30 Jul 1999 23:57:19 +0300

Re: Query Help

2003-02-11 Thread Mirko
You have one column detail - What do you mean by detail1, detail2 and so? = On Tue, 11 Feb 2003 13:13:31 +, Jeff Snoxell <[EMAIL PROTECTED]> wrote: Hi, How can I write a MySQL query to grab single lines of the form

Re: IP Addresses -- How to Store

2003-02-11 Thread Peter Hicks
On Tue, 11 Feb 2003, Dan Nelson wrote: > Store your addresses as INTs, so you would have three fields: > "address", "netmask", and "gateway". You can either encode the values > yourself, or use mysql's INET_NTOA()/INET_ATON() functions. ...and beware, INET_NTOA/ATON calls aren't compatible (as f

Re: IP Addresses -- How to Store

2003-02-11 Thread Dan Nelson
In the last episode (Feb 11), Aaron Conaway said: > I'm looking to develop a database of IP addresses for the company and > have, of course, chosen mySQL as the backend. I want the app to add > (remove, etc.) a host, giving its hostname and segment. The app will > add the next available address t

IP Addresses -- How to Store

2003-02-11 Thread Aaron Conaway
I'm looking to develop a database of IP addresses for the company and have, of course, chosen mySQL as the backend. I want the app to add (remove, etc.) a host, giving its hostname and segment. The app will add the next available address to the database and, looking at the segment, provide the su

client side RAD

2003-02-11 Thread Charles Lewis
I am desperately searching for a GUI RAD environment to develop database applications for MySQL. I'm not talking about database administration such as provided by ControlCenter or SQLyog. I'm talking about the ability to build formatted forms/screens, queries and reports along the lines of Access.

3.23.41: auto_increment bug with TRIPLE primary key? (really strange)

2003-02-11 Thread The Mindflayer
mysql -V: mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) (Upgrading may not be an option.) Not subscribed to the list, so please CC me on any responses. I'd submit this to bugs@, but my MySQL version is way out of date and I'm not sure if the current version has been fixed. A q

mysql privs table level security

2003-02-11 Thread Andrew Braithwaite
Hi all, Can anyone help me please? I have a database with hundreds of tables and I want to lock down certain tables for select only. The order of presidence for mysql privs as far as I can tell is that if there are database level privileges, these override the table level privs. I don't want to

Re: mysql overhead

2003-02-11 Thread Stefan Hinz
Ciprian, > I am using PhpMyAdmin and today I got a red message saying that one > table has overhead and I need to optimize the table. > This is the first time I got this message, I looked online and I > understood why it shows. But my question is: can I do something to avoid > it? What effects da

Re: problem with the load data

2003-02-11 Thread Stefan Hinz
Edgard, > I'm trying to load a text file, I've extract from access, and Ihave the > following error mysql>> LOAD DATA INFILE '/home/dapasedg/provedores.txt' INTO TABLE proveedores > -> FIELDS TERMINATED BY '|' ENCLOSED BY '"'; > ERROR 13: Can't get stat of '/home/dapasedg/provedores.txt' (Errc

Re[2]: socket error

2003-02-11 Thread Stefan Hinz
J.A., >> > Can't find file: './mysql/host.frm' (errno: 13) >> > 030211 16:26:51 mysqld ended >> Did you run the mysql_install_db script?? > yes, i ran everything again I bet my b* you didn't, or maybe something went wrong when running it. If mysqld cannot find host.frm, this means the grant t

Re: RedHat 8.0 and MySQL 3.23.55 install problem

2003-02-11 Thread Csongor Fagyal
I get this message back: Failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.55-1 I know I have this dependency installed, but I think I know where the problem is just not sure how to fix it. Here is what I get when I do a 'rpm -qa | grep DBI-perl': Mysql-DBI-perl-bin-1.182

RedHat 8.0 and MySQL 3.23.55 install problem

2003-02-11 Thread Wes Hegge
I am having problems installing MySQL 3.23.55 on RedHat 8.0. The version that came with RedHat will not let me remotely login. I found a thread at RedHat that said that this is a known problem. One of the suggestions was to upgrade MySQL. That is what I am attempting to do. This is what happens

Re: optimizing left join query

2003-02-11 Thread Saqib . N . Ali
Diana, Thanks for the suggestion. I completely forgot to add the index/primary key. Now it works just fine :) Thanks again. In Peace, Saqib Ali "I fear, if I rebel against my Lord, the retribution of an Awful Day (The Day of Resurrection)" Al-Quran 6:15 http://docbook.sc-icc.org |+

Fw: Very slow request with many ORs in where parts

2003-02-11 Thread Artem Koutchine
Yes of course. Here you go: mysql> EXPLAIN SELECT DISTINCT w0.l_id FROM law_words as w0 -> inner join law_words as w1 on w0.l_id=w1.l_id -> WHERE -> w0.w_id IN (258,282,287, 615, 1101, 1949, 1968, 3417, 3574, 3578, 3643, -> 4345,4768, 5297, 5976,6133, 7243,7245, 9271, 9348, 11

Re: socket error

2003-02-11 Thread Peter Grigor
- Original Message - From: "J. A. Tovey" <[EMAIL PROTECTED]> To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 11:52 AM Subject: Re: socket error > > yes, i ran everything again > Well, the host.frm file is a mysql database table def...your perm

Re: socket error

2003-02-11 Thread J. A. Tovey
yes, i ran everything again --- Peter Grigor <[EMAIL PROTECTED]> wrote: > - Original Message - > From: "J. A. Tovey" <[EMAIL PROTECTED]> > To: "Peter Grigor" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Tuesday, February 11, 2003 11:33 AM > Subject: Re: socket error > > > > ok :)

Re: optimizing left join query

2003-02-11 Thread Diana Soares
Your user_info table is not indexed... (user_info.uid should have an index) Check the manual: http://www.mysql.com/doc/en/MySQL_indexes.html On Tue, 2003-02-11 at 16:16, [EMAIL PROTECTED] wrote: > Hello All, > > I have the following 2 tables and "LEFT join" query as follows: > > > mysql> desc

Re: Last record

2003-02-11 Thread Keith C. Ivey
On 11 Feb 2003, at 10:30, Deependra b. Tandukar wrote: > How do I select the very last record in a column in MySQL database? That depends on what you mean by "last record". What are you sorting by? Once you've figured that out, do a query like this: SELECT * FROM table_name ORDER BY sor

Re: socket error

2003-02-11 Thread Peter Grigor
- Original Message - From: "J. A. Tovey" <[EMAIL PROTECTED]> To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 11:33 AM Subject: Re: socket error > ok :) > > all killed now, > > (not quite there yet though :)) > > I am now getting the error:

Re: socket error

2003-02-11 Thread J. A. Tovey
ok :) all killed now, (not quite there yet though :)) I am now getting the error: 030211 16:26:51 mysqld started 030211 16:26:51 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 030211 16:26:51 mysqld ended ? --- Peter Grigor <[EMAIL PROTECTED]> wrote: > > i'm

optimizing left join query

2003-02-11 Thread Saqib . N . Ali
Hello All, I have the following 2 tables and "LEFT join" query as follows: mysql> describe user_lic; +++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +++--+-+-+---+ | license_id | big

problem with the load data

2003-02-11 Thread Edgard Dapás
I'm trying to load a text file, I've extract from access, and Ihave the following error mysql> LOAD DATA INFILE '/home/dapasedg/provedores.txt' INTO TABLE proveedores -> FIELDS TERMINATED BY '|' ENCLOSED BY '"'; ERROR 13: Can't get stat of '/home/dapasedg/provedores.txt' (Errcode: 13) Anybo

Re: socket error

2003-02-11 Thread Peter Grigor
> i'm sorry - could you explain that for a > simpleton :-) > i have no idea what you mean :-/ > > --- Peter Grigor <[EMAIL PROTECTED]> wrote: > > - Original Message - > > From: "J. A. Tovey" <[EMAIL PROTECTED]> > > To: "Peter Grigor" <[EMAIL PROTECTED]>; > > <[EMAIL PROTECTED]> > > Sent: Tu

Re: socket error

2003-02-11 Thread J. A. Tovey
i'm sorry - could you explain that for a simpleton :-) i have no idea what you mean :-/ --- Peter Grigor <[EMAIL PROTECTED]> wrote: > - Original Message - > From: "J. A. Tovey" <[EMAIL PROTECTED]> > To: "Peter Grigor" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Tuesday, February 11

RE: Very slow request with many ORs in where parts

2003-02-11 Thread Andy Eastham
Artem, Have you considered using a full text index? I don't really understand exactly what you are trying to do, but consider it if you haven't already. Andy > -Original Message- > From: Artem Koutchine [mailto:[EMAIL PROTECTED]] > Sent: 11 February 2003 14:23 > To: [EMAIL PROTECTED] > S

Re: create temp table

2003-02-11 Thread gerald_clark
create newtable select from oldtable where 1=0; Admin wrote: In MySQL is it possible to create a temporary table without having to specify all the properties? On SQL Server (at least via query analyzer) you can create temp tables fairly easily and the properties of each field are inherited from

Re: SERIOUS PROBLEM

2003-02-11 Thread Peter Grigor
- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 9:52 AM Subject: SERIOUS PROBLEM > Hi, > I am encountering a serious problem with MYSQL 3.23.48. Mine is a java > application with the following flow. > >Make a connectionobject to

create temp table

2003-02-11 Thread Admin
In MySQL is it possible to create a temporary table without having to specify all the properties? On SQL Server (at least via query analyzer) you can create temp tables fairly easily and the properties of each field are inherited from the regular table. Doesn't look like thats the case with MySQL

SERIOUS PROBLEM

2003-02-11 Thread rajup
Hi, I am encountering a serious problem with MYSQL 3.23.48. Mine is a java application with the following flow. Make a connectionobject to Mysql Get a record from table1 Update table2 with the table1 info. It works in 99% of the cases i am able to fetch the record from table1. But in 1

Re: socket error

2003-02-11 Thread Peter Grigor
- Original Message - From: "J. A. Tovey" <[EMAIL PROTECTED]> To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 9:34 AM Subject: Re: socket error > ah ok, yes, > > the error log says > " > 030211 12:10:27 mysqld started > 030211 12:10:27 Can't s

Re: socket error

2003-02-11 Thread J. A. Tovey
ah ok, yes, the error log says " 030211 12:10:27 mysqld started 030211 12:10:27 Can't start server: Bind on TCP/IP port: Address already in use 030211 12:10:27 Do you already have another mysqld server running on port: 3306 ? 030211 12:10:27 Aborting " how do i get rid of this other mysql !

RE: Very slow request with many ORs in where parts

2003-02-11 Thread Victor Pendleton
Can you post your explain plan? -Original Message- From: Artem Koutchine [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 8:23 AM To: [EMAIL PROTECTED] Subject: Very slow request with many ORs in where parts Hi! I have the following table: create table law_words ( l_id i

Very slow request with many ORs in where parts

2003-02-11 Thread Artem Koutchine
Hi! I have the following table: create table law_words ( l_id int unsigned not null, w_id int unsigned not null, primary key (w_id, l_id) ); The request is: SELECT DISTINCT w0.l_id FROM law_words as w0 inner join law_words as w1 on w0.l_id=w1.l_id where w0.w_id in (258,282,... ab

mysql overhead

2003-02-11 Thread Ciprian I. Acatrinei
Hi, I am using PhpMyAdmin and today I got a red message saying that one table has overhead and I need to optimize the table. This is the first time I got this message, I looked online and I understood why it shows. But my question is: can I do something to avoid it? What effects daoe the overhea

Re: socket error

2003-02-11 Thread Peter Grigor
- Original Message - From: "J. A. Tovey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 9:09 AM Subject: socket error > hi - > > i have got to the beginning stages of > installation - on trying to create a root > password with: > > bin/mysqladmin -u root pass

Strange Updates

2003-02-11 Thread Daniele Lo Re
Hi everybody I got weird behaviour from Mysql while doing some updates. Before doing the update I did a count, like this: select count(*) from Yellow WHERE MATCH(street_add) AGAINST('+GUIDO +MIGLIOLI' IN BOOLEAN MODE) AND street_short = ''; and the result was 50 rows in set. But when I ran t

socket error

2003-02-11 Thread J. A. Tovey
hi - i have got to the beginning stages of installation - on trying to create a root password with: bin/mysqladmin -u root password 'password' i get bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check

Top MYSQL Sites

2003-02-11 Thread Insanely Great
Hello Can somebody tell me what are the top sites ( except ofcourse mysql.com ) for general MySQL News, Tutorials etc. Insane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

Re: exist

2003-02-11 Thread Peter Grigor
Heya: > HI > Does mysql support function EXIST No. It doesn't support subselects before 4.1 either. > mysql> select * from arcdata d > -> WHERE year='2003' AND semester='1' > -> AND EXIST (SELECT * FROM arcdata_unitCodes u > -> WHERE u.idnum = d.idnum AND u.semester=d.semester AN

Re: MySQL IMAP Server

2003-02-11 Thread Curtis Maurand
Courier IMAP can. www.courier-mta.com Curtis On Wed, 5 Feb 2003, Paul DuBois wrote: > At 17:26 + 2/4/03, Ben Clewett wrote: > >MySQL, > > > >My first post, please go easy if this is the wrong pleace! > > > >I'm trying to find an IMAP server which used MySQL so that my > >Mozilla Email cli

Re: encrypted password

2003-02-11 Thread Curtis Maurand
The manual suggests that the password function is really for intenal mysql functions. Ideally you should use the encode or md5_encode functions. update user set password=encode('password', 'salt') where user = 'your_user'; Curtis On Wed, 5 Feb 2003, Natale Babbo wrote: > try to use the pas

Re[2]: Robot Replies (Off topic)

2003-02-11 Thread sherzodr
Unfortunately, good intentions don't always produce alike results. How about if the bot replies to messages matching "newbie", "novice" and "beginner" in the subject? They most likely tend to be from beginners, and online manual and/or list archives are pretty much perfect solutions for their iss

SET field manipulation

2003-02-11 Thread Jeff Snoxell
Hi, how can I update a set field such that all table rows get what they had in the set ORed with some other set value. I.E. If I have a field called SetField and rows: SetField A A,B A,B,C B etc How can I do what I'm trying to do with this mysql query? UPDATE MyTable SET SetField = (SetField

Query Help

2003-02-11 Thread Jeff Snoxell
Hi, How can I write a MySQL query to grab single lines of the form: ColumnNames: EnquiryID, Name, Address, Detail1, Detail2, Detail3, Detail4 From two joined tables: Tbl1: Enquiries -- ID Name Address Etc Tb12: Details ID EnquiryID Detail Etc -

Re: Merge table limit

2003-02-11 Thread Jerry
Cheers. The only limit I've hit so far on 365 tables, was the max number of open files, so I've ramped that up and its working fine at the moment. Jerry - Jeremy Hutchings Apps R&D Cable and Wireless - - Original Message - From: "Diana Soares" <[E

Re: tricky regrex and case case query

2003-02-11 Thread Diana Soares
Hi, you could try: SELECT name, SUBSTRING_INDEX(name,' ', 1) as first, SUBSTRING_INDEX(v2, ' ', -1) as last FROM table For the uppercase of the first letter, as i don't know a specific functions to do that in MySQL (it has ucase and lcase but for all the word), you must "play" wit

Re: question on "select group by a 'set' field"

2003-02-11 Thread Anya
Thanks, Fred. It works perfectly. At 01:00 PM 2/11/2003 +0100, Fred van Engen wrote: >Hello Anya, > >On Tue, Feb 11, 2003 at 07:51:00PM +0800, Anya wrote: >> >> >> Dear all, >> I have a table Kids which has the following fields: >> >> kid char(20), >> favorite_fruits set('apple','pear','orange

AW: stuck , mysql on SUSE

2003-02-11 Thread Franz, Fa. PostDirekt MA
Hi , if you used SUSE , why didn't you just install the mysql-packages distibuted there with yast. It's very easy and I never had a problem with it. It is also possible to install foreign packages with yast later , if you want to udate your mysql-server later. The problem is , that SUSE is not ver

error if I post a record

2003-02-11 Thread Thomas Berg
Hello everybody, I have a problem with MySQL and an application made with Delphi. If I try to save a modified record in a table, I get the following error: "Record can not be locked because the record is already in use." I don't know if that is the exact translation. The original errormessage is G

  1   2   >