10 minutes seems excessive...

2004-04-21 Thread Mailing Lists
Hello all... Source table has approximately 23,000,000 rows. The explain below shows we'll be working with 2,707,366 of those rows just inserting them into a table. Why does this take 10 minues to run? System specifications below all that. * Precompiled binary from mysql.com * Completely idle

Server Perf Increase

2004-04-21 Thread Kumar
hello list, i have high performance dell server. i want to increase Read_Buffer_Size server variable to 5 MB. i have found docs on this in mysql site. like this mysqld_safe --key_buffer_size=64M --table_cache=256 \ --sort_buffer_size=4M --read_buffer_size=1M where i type that

Server Variable Parameters

2004-04-21 Thread Kumar
hello list, i have high performance dell server. i want to increase Read_Buffer_Size server variable to 5 MB. i have found docs on this in mysql site. like this mysqld_safe --key_buffer_size=64M --table_cache=256 \ --sort_buffer_size=4M --read_buffer_size=1M where i type that

SELECT duplicate rows

2004-04-21 Thread John Mistler
Is there a way to use a SELECT statement (or any other, for that matter) that will look at every table in a database and return every row whose first 3 columns are duplicated in at least one other row in any of the tables? Essentially, a command to find duplicate entries in the database . . .

Re: ERROR ON INSERT DATA FROM FILE

2004-04-21 Thread Victoria Reznichenko
adrian Greeman [EMAIL PROTECTED] wrote: I just tried to load edited data from a text file separated by | characters into a table in a simple data base I was using PhpMyAdmin version 2.5.6 and MySQL 4.0.18 running on Windows XP - I thought it was all set up right and configured properly -

Re: long string

2004-04-21 Thread Egor Egorov
[EMAIL PROTECTED] wrote: hi, I am trying to enter a genome sequence into mysql database. I have created a database in mysql as: create table sequence(seq blob); the length of my sequence is approx. 170. this is the error i get whe i run my python script: OperationalError:

Fw: spatial woes - again

2004-04-21 Thread James S reid
hi - Ive posted this before but not had any answers... Im trying to load spatial data as OGC WKT into a geometry field but a number of rows consistently fail. I can se no reaspn for this other than their length - does anyone know what the size limit for insertion into a geometry field is (Im

Re: how to speed up a simple query? can anyone help with an ideea?

2004-04-21 Thread Arthur Radulescu
Creating a combined index can help MySQL in using this index for both the where condition and the order by clause. Try the query with an index on cat,date and with date,cat; maybe one will be faster than the other. This partially solved my problem. Thanks a lot. However I am facing a new

Re: Server Perf Increase

2004-04-21 Thread Victoria Reznichenko
Kumar [EMAIL PROTECTED] wrote: i have high performance dell server. i want to increase Read_Buffer_Size server variable to 5 MB. i have found docs on this in mysql site. like this mysqld_safe --key_buffer_size=64M --table_cache=256 \ --sort_buffer_size=4M

Re: SELECT duplicate rows

2004-04-21 Thread Joshua J. Kugler
Yes, there is a way. It's called joins. :) I don't remember the exact syntax off the top of my head, but the approach is thus: Do a self join on the table and select records that match in their first three columns, but do not have the same primary key (you *do* have primary keys on your

Re: ERROR ON INSERT DATA FROM FILE

2004-04-21 Thread adrian Greeman
Thanks for the answer - but I am already the root user and have phpMyAdmin using the root also (because this is just a single computer for testing work and there are not any bit security issues). - Original Message - From: Remi Mikalsen [EMAIL PROTECTED] To: adrian Greeman [EMAIL

Re: SELECT duplicate rows

2004-04-21 Thread John Mistler
Thanks for the response, Joshua. I am so very new to MySQL, that I am afraid I require more guidance. Is there a way to join ALL tables in a database rather than just one table to itself, or one particular table to another? SELECT * FROM allTables WHERE column1=column1 AND column2=column2 AND

Re: SELECT duplicate rows

2004-04-21 Thread Joshua J. Kugler
Well, doing on all tables at once woule probably bring the server to its knees due to the cartesian product producing a VERY large temporary table. You can do it on two tables at once like this (if my memory serves): SELECT * from mytable as t1, mytable as t2 WHERE t1.column1 = t2.column1 AND

mySQL: Table locking problems when non-index keys used

2004-04-21 Thread ravi.ramachandra
Hi Friends, We are using mysql 4.0.17 with innodb option. In a query, when a WHERE clause contains a non-indexed columns, it locks the entire table instead of row lock. Is there any solution apart from building index on each query key ? Is there a solution in any of the later versions ?

Re: Randomly selecting from table

2004-04-21 Thread Bill Easton
If you want to guarantee that the selections are different, rand() doesn't quite do it, as you will get a repeated value with the appropriate probability. You will need to keep a record of what values have already been seen. Then, use something like select ... from my_table left join

Re: INNODB SHOW STATUS

2004-04-21 Thread Arunachalam
hi try this URL: http://www.innodb.com/ibman.php -arun. --- Emmett Bishop [EMAIL PROTECTED] wrote: Howdy all, Quick question about what I'm seeing in the BUFFER POOL AND MEMORY section... I've configured the innodb_buffer_pool_size to be 128M and when I do a show variables like

Re: Multi-user / transactions question..

2004-04-21 Thread Jochem van Dieten
Jeremy Smith said: A typical auction lasts around 90 minutes, and consists of a whole lot of furious refreshing of the auction board by the participants since each player only has a 2 minute clock. You might wish to look into using a different mechanism for this so you can push the latest

Fw: Slow user authentication cross server...

2004-04-21 Thread David Scott
Sorry for the re-post but there was no response and this is starting to become a big problem... The basics are that connecting to mysql from another machine the initial connection is taking 20 seconds and showing up in the process list as unauthenticated user for this period. Any help

Re: genome sequence

2004-04-21 Thread Thomas Spahni
Hi Liz, a column of type BLOB takes a maximum of 65535 bytes; try MEDIUMBLOB or even LONGBLOB. Regards, Thomas Spahni On Tue, 20 Apr 2004 [EMAIL PROTECTED] wrote: hi, I am trying to enter genome sequences of length 170 and more into mysql database. I have created a table

Re: replication in 5.0.0-alpha

2004-04-21 Thread Oleg P. Philon
Hi, collegues On Sat, Apr 17, 2004 at 05:19:16PM +0300, Oleg P. Philon wrote: Have I use precompiled binaries from ftp.mysql.com? Ya, I have to Is there working setups with 5.0.0 and replication? Again yes, in mein setup at last Auf Wiederlesenophil aka - -- Oleg P.

Re: MySQL 5.0.0-alpha-max-debug running on localhost as ODBC@localhost

2004-04-21 Thread Egor Egorov
Marvin Cummings [EMAIL PROTECTED] wrote: I'm not actually getting an error. I'm simply unable to access any of my databases while logged in as [EMAIL PROTECTED] I'd like to change this and specify what account is used to establish a connection. How and where do I make this change in MySQL?

query help [resend]

2004-04-21 Thread Yonah Russ
Hi, I have two tables- books and copies every book has an id in the books table every copy of a book has the books id and a copy id in the copies table (1 row per copy) I want a list of all the books that don't have any copies meaning all the book id's in books that don't match any book id's in

RE: MySQL Website

2004-04-21 Thread Lehman, Jason (Registrar's Office)
I should have been clearer. I can't reach the website. I can get to lists.mysql.com with no problem except for the fact that images won't pull form www.mysql.com but I definitely come to a grinding halt when I try to reach www.mysql.com. I can't do a tracert because the university has shut that

Re: MySQL Website

2004-04-21 Thread Joseph A. Nagy, Jr.
On Wed, Apr 21, 2004 at 08:08:29AM -0400, Lehman, Jason (Registrar's Office) wrote the following: I should have been clearer. I can't reach the website. I can get to lists.mysql.com with no problem except for the fact that images won't pull form www.mysql.com but I definitely come to a

Re: MySQL Website

2004-04-21 Thread Peter Burden
Lehman, Jason (Registrar's Office) wrote: I should have been clearer. I can't reach the website. I can get to lists.mysql.com with no problem except for the fact that images won't pull form www.mysql.com but I definitely come to a grinding halt when I try to reach www.mysql.com. I can't do a

RE: MySQL Website

2004-04-21 Thread Brad Teale
It appears to be the web server. I can reach mysql.com just fine in a traceroute, but can't get a HEAD or webpage to come up! traceroute to mysql.com (66.35.250.190), 30 hops max, 38 byte packets 1 cdm-208-180-236-1.cnro.cox-internet.com (208.180.236.1) 18.963 ms 10.260 ms 12.200 ms 2

Re: query help

2004-04-21 Thread Yonah Russ
I got a response off the list suggesting writing a function to go over the query results- it's not hard but I'd rather do this in sql if possible. I came up with this: select books.bookid,books.title,copies.copyid from books left join copies on books.bookid=copies.bookid where

Re: query help [resend]

2004-04-21 Thread Victoria Reznichenko
Yonah Russ [EMAIL PROTECTED] wrote: Hi, I have two tables- books and copies every book has an id in the books table every copy of a book has the books id and a copy id in the copies table (1 row per copy) I want a list of all the books that don't have any copies meaning all the book

RE: Multi-user / transactions question..

2004-04-21 Thread Jeremy Smith
I appreciate the reply, I do plan on expanding this to make the use of flash and a flash server at some point, but I want to offer the option of HTML auctions as well. I will look into summary tables as it is not something I am familiar with. Btw, I'm not sure why you sent me a link on How To

RE: query help

2004-04-21 Thread Matt Chatterley
I suspect you want 'IS NULL' rather than '= NULL'. :) I always find it best to think of NULL as undefined value rather than no value - which is why you need to check for it especially (using IS rather than = or other operators). Cheers, Matt -Original Message- From: Yonah Russ

Re: Error when dumping DBs.

2004-04-21 Thread Egor Egorov
JR [EMAIL PROTECTED] wrote: I am getting the following error when trying to dump my DBs. /usr/bin/mysqldump: Got error: 1103: Incorrect table name '/home/jr/backups/20040420/wcp.sql' when doing LOCK TABLES Version is: 4.0.18-standard These DBs where on another box running the same

Re: MySQL Website

2004-04-21 Thread Lou Olsten
I have not been able to access the mysql.com server for about a day and a half now from my office. From home, it's fine. There have been rare occasions in the past when our provider had dropped (or very slow) connectivity with certain nodes on the Internet. My understanding there is limited,

Re: MySQL Website - TRACERT

2004-04-21 Thread Lou Olsten
Here's my tracert: 325 ms25 ms29 ms 65-86-11-209.client.dsl.net [65.86.11.209] 423 ms29 ms24 ms unknown.Level3.net [209.247.230.161] 528 ms25 ms26 ms so-5-0-0.bbr2.Chicago1.Level3.net [4.68.112.209] 623 ms25 ms25 ms

RE: BETWEEN

2004-04-21 Thread Boyd E. Hemphill
I too cannot get the site correctly. I am using IE. If I wait long enough (about 2 min) text will appear but the images never seem to make it. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -Original Message- From:

Re: MySql Client Program Questions

2004-04-21 Thread Dirk Bremer \(NISC\)
At 16:03 -0500 4/20/04, Dirk Bremer (NISC) wrote: I have a couple of questions concerning the MySql client program. 1. Are the option for the client program, i.e. --auto-rehash, etc. documented anywhere? I searched the included HTML file and could not find a reference to the client options.

RE: Innodb Hot Backup Tool

2004-04-21 Thread McConnell, Ann M.
The good, bad, and the ugly of it? We're debating if we should use it on our INNODB tables or use a script to do a hotbackup. On Tue, Apr 20, 2004 at 01:54:37PM -0400, McConnell, Ann M. wrote: Does anyone have any experience with Innodb Hot Backup Tool? Yes. -- Jeremy D. Zawodny |

Re: MySQL Website

2004-04-21 Thread Ian Gibbons
On 21 Apr 2004 at 9:14, Lou Olsten wrote: I have not been able to access the mysql.com server for about a day and a half now from my office. From home, it's fine. There have been rare occasions in the past when our provider had dropped (or very slow) connectivity with certain nodes on the

Re: MySQL Website

2004-04-21 Thread Mike Blezien
FYI... Just connected to the www.mysql.com site this morning with no problems :) -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net

Renaming a column

2004-04-21 Thread gunnar.lunde
Hi, I am hoping to get some advice on a problem I have. I have a table that have 109 million records and is about 30 G in size. I need to rename a column, because it seem that localtime have become a reserved word. The alter table statement makes mysql generate a tmp table and regenerate the

Re: INNODB SHOW STATUS

2004-04-21 Thread Emmett Bishop
Arun, Unfortunately, that link contains the exact same info as does the mysql.com page. There's almost no explaination there of what any of the output means. I'm sure that it's really useful stuff but I don't have a starting point. Can someone point me in the right direction (a book or website)

Storing App Settiings

2004-04-21 Thread Bruce Vander Werf
I am developing a php/mysql web application, and I am facing the task of storing application settings. Because it is web based, I will need to read the app settings on a per-session basis. I see one of two choices here - store each setting as a separate record in the table, with the value always

Re: INNODB SHOW STATUS

2004-04-21 Thread Marc Slemko
On Tue, 20 Apr 2004, Emmett Bishop wrote: Howdy all, Quick question about what I'm seeing in the BUFFER POOL AND MEMORY section... I've configured the innodb_buffer_pool_size to be 128M and when I do a show variables like 'innodb%' I see | innodb_buffer_pool_size | 134217728

Replication problem

2004-04-21 Thread Georg Horn
Hi, i'm new to this list, but i use mysql for years an are very happy with it. However, today i ran into a problem that i couldn't find a solution for: I set up database replication with a master and one slave, and it works fine so far. I rewrote my application (web based written in php) so that

Newbie - Load Data Command and File Location

2004-04-21 Thread Chris Stevenson
I'm working through a self study book and I am trying to learn how to do a load data local infile. I downloaded a sample database and I have the txt file but each time I type in the command LOAD DATA LOCAL INFILE 'member.txt' INTO TABLE member; I get the following message ERROR: File 'member.txt'

Re: Problem retrieving Unicode data

2004-04-21 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stormblade wrote: Thanks. I'd read that already but I re-read it and noticed this part here: When a client connects, it sends to the server the name of the character set that it wants to use. The server sets the character_set_client,

files stored in fields

2004-04-21 Thread adrian Greeman
Please excuse a very simple inquiry from a near beginner If I wish to store a complete Word file or similar (Open Office perhaps) or an archive file - is that possible and what kind of field do I need for it? How do you insert a file into a table if so? I know that you can store pictures - what

Re: Modelling specialized M:N relationships?

2004-04-21 Thread Leandro Melo
I'm actually i deep doubts with this. Price is not a thing itself, good point. But in my case, it was the best way i found out to model. Suppose you got a company the rents a place (just a big room, or a party house) for any kinda envents you'd to make. The company is clear an entity, and the

MySQL Distribution and Shared Libraries

2004-04-21 Thread Gabriel Ricard
Why doesn't the MySQL binary distribution include the shared libraries? (At least, the Mac OS X version does not) I'd prefer to use this distribution, but I have to roll my own in order to get shared libs to use with PHP, Perl (for mytop), etc. - Gabriel -- MySQL General Mailing List For list

reuse a results set

2004-04-21 Thread Scott Swaim
I have a form that does the following ? while ($speaker = db_fetch_object($qid_speaker)) { ? option value=? pv($speaker-first_name) ? ? pv($speaker-last_name) ? ? pv($speaker-first_name) ? ?

Re: Problem retrieving Unicode data

2004-04-21 Thread Stormblade
On Wed, 21 Apr 2004 10:35:16 -0500, Mark Matthews wrote: Stormblade, If you're using UTF-8 data and JDBC, and you _haven't_ set the _server_ charset to UTF-8, you'll need to add 'characterEncoding=UTF-8' as a property to your JDBC connection string. I have set the default charset to utf8.

Re: files stored in fields

2004-04-21 Thread William R. Mussatto
adrian Greeman said: Please excuse a very simple inquiry from a near beginner If I wish to store a complete Word file or similar (Open Office perhaps) or an archive file - is that possible and what kind of field do I need for it? How do you insert a file into a table if so? I know that you

RE: Replication problem

2004-04-21 Thread Mechain Marc
Add this in your my.cnf slave file: slave-skip-errors = 1062 Marc. -Message d'origine- De : Georg Horn [mailto:[EMAIL PROTECTED] Envoyé : mercredi 21 avril 2004 17:31 À : [EMAIL PROTECTED] Objet : Replication problem Hi, i'm new to this list, but i use mysql for years an are very

Re: Newbie - Load Data Command and File Location

2004-04-21 Thread gerald_clark
Chris Stevenson wrote: I'm working through a self study book and I am trying to learn how to do a load data local infile. I downloaded a sample database and I have the txt file but each time I type in the command LOAD DATA LOCAL INFILE 'member.txt' INTO TABLE member; I get the following

Re: files stored in fields

2004-04-21 Thread colbey
Sure.. checkout this article: http://php.dreamwerx.net/forums/viewtopic.php?t=6 Very fast mysql storage implementation in PHP, port the design to whatever lanaugage suits you. On Wed, 21 Apr 2004, adrian Greeman wrote: Please excuse a very simple inquiry from a near beginner If I wish to

mySqlDump grant command

2004-04-21 Thread Carl Karsten
I am sure that i used mysqldump to create a script that had both CREATE TABLE and GRANT commands, but now I can't figure out how. Carl K http://www.personnelware.com/carl/resume.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Restrictions on inserting ???

2004-04-21 Thread Leandro Melo
Hi, is there a way i can make a restriction for inserting data on a table? I'll expose this idea with a simple (not real) example. Suppose i got table EMPLOYEE, wich has an attribute called FLG_HAS_DEPENDENTS. I also have a table called DEPENDENTS, wich has data for the dependents of some

Confused by max and group by

2004-04-21 Thread Noah Spurrier
I'm having trouble with max() and group by. It seems pretty simple. I hope someone can point out my mistake. I want to select the max index of a group. In other words, I want to find the last record added for each group. The problem I'm having is that the columns of the resulting rows are mixed

Query question

2004-04-21 Thread Alex croes
I'm trying to select specified data from a field in a table. The field from which the data has to come contains the following: 'something;else;anything;everything;name;my' (and so on), it's a long text. I need in the case just 'my' from the field, thus between the ';'. This time there are only

Re: mySqlDump grant command

2004-04-21 Thread Paul DuBois
At 11:57 -0500 4/21/04, Carl Karsten wrote: I am sure that i used mysqldump to create a script that had both CREATE TABLE and GRANT commands, but now I can't figure out how. mysqldump doesn't generate GRANT statements. Perhaps you are thinking of some other program. -- Paul DuBois, MySQL

RE: Confused by max and group by

2004-04-21 Thread Chris
You aren't making any mistakes, it's just not possible to do. You can't rely on which row MySQL will return when using a GROUP BY clause. The standard method would be to do something like this: CREATE TEMPORARY TABLE mytemptable SELECT max(myindex) as myindex, mycat FROM `mytest`

Re: Newbie - Load Data Command and File Location

2004-04-21 Thread Paul DuBois
At 11:29 -0400 4/21/04, Chris Stevenson wrote: I'm working through a self study book and I am trying to learn how to do a load data local infile. I downloaded a sample database and I have the txt file but each time I type in the command LOAD DATA LOCAL INFILE 'member.txt' INTO TABLE member; I get

If() syntax question

2004-04-21 Thread Don Dachner
Is it possible to do something like this? If(select * from xxx, if record found..update it, if record not found ..insert it) Thanks, Don

RE: If() syntax question

2004-04-21 Thread Mike Johnson
From: Don Dachner [mailto:[EMAIL PROTECTED] Is it possible to do something like this? If(select * from xxx, if record found..update it, if record not found ..insert it) Try the REPLACE INTO syntax: http://dev.mysql.com/doc/mysql/en/REPLACE.html -- Mike Johnson Web Developer Smarter

Re: Query question

2004-04-21 Thread Don Read
On 21-Apr-2004 Alex croes wrote: I'm trying to select specified data from a field in a table. The field from which the data has to come contains the following: 'something;else;anything;everything;name;my' (and so on), it's a long text. I need in the case just 'my' from the field, thus

grant problem!!!

2004-04-21 Thread lga2
hi, I am having problems with mysql. 1. I downloaded mysql on to my system. 2.installed it 3. ran the server using the command prompt C:\mysql\bin\mysqld --console it gave me the results that i could start using the service. 4. i started mysql on another command prompt. what i

Re: Problem retrieving Unicode data

2004-04-21 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stormblade wrote: On Wed, 21 Apr 2004 10:35:16 -0500, Mark Matthews wrote: Stormblade, If you're using UTF-8 data and JDBC, and you _haven't_ set the _server_ charset to UTF-8, you'll need to add 'characterEncoding=UTF-8' as a property to your

Re: grant problem!!!

2004-04-21 Thread Victoria Reznichenko
[EMAIL PROTECTED] wrote: hi, I am having problems with mysql. 1. I downloaded mysql on to my system. 2.installed it 3. ran the server using the command prompt C:\mysql\bin\mysqld --console it gave me the results that i could start using the service. 4. i started mysql on

RE: Gripe with MySQL

2004-04-21 Thread Jochem van Dieten
Peter J Milanese said: The lack of error checking on the server side means better performance in my opinion. Does it? Or does client side error checking use server resources as well? Lets suppose that we want to validate a new message that is entered into a thread on a messageboard. Then we

BLOB data and mysql_escape_string

2004-04-21 Thread Eric J. Janus
I'm attempting to put an image into a BLOB field. I'm using Visual Basic 6 with ADO, although I wouldn't think that's making a difference. I create a string that contains the binary representation of the file. At this point the string is 5064 characters long. I call mysql_escape_string and the

Re: Confused by max and group by

2004-04-21 Thread Brent Baisley
I think what is happening is that you are getting the max value for one field, but the first values for the other fields. Try ordering you group by: SELECT max(myindex), myval, mycat FROM `mytest` GROUP BY mycat DESC; On Apr 21, 2004, at 1:35 PM, Noah Spurrier wrote: I'm having trouble with

Fw: reuse a results set

2004-04-21 Thread Scott Swaim
I have a form that does the following ? while ($speaker = db_fetch_object($qid_speaker)) { ? option value=? pv($speaker-first_name) ? ? pv($speaker-last_name) ? ? pv($speaker-first_name) ? ?

reuse results set

2004-04-21 Thread Scott Swaim
I have a form that does the following ? while ($speaker = db_fetch_object($qid_speaker)) { ? option value=? pv($speaker-first_name) ? ? pv($speaker-last_name) ? ? pv($speaker-first_name) ? ?

Re: Searching the Docs

2004-04-21 Thread Lou Olsten
I use the online docs extensively as I am still very much in learning mode with MySQL. However, I've been frustrated recently because it appears I cannot search for an EXACT string literal, which brings me back a ton of hits I don't want. For example, I'm trying to search for the dynamic

Escape characters

2004-04-21 Thread John Mistler
When issuing commands through the terminal (in Mac OS 10.3) to MySQL, I understand that if you surround a variable with \\` it will allow for characters such as - and space. Will it also allow for all other non-alphanumeric characters such as / and * and , etc.? Thanks, John -- MySQL General

Re: Problem retrieving Unicode data

2004-04-21 Thread Stormblade
On Wed, 21 Apr 2004 14:07:48 -0500, Mark Matthews wrote: I have set the default charset to utf8. When I view my variables they all show that utf8 as their value. My URL is as follows: What does the JDBC connection _itself_ show? Execute the following query on a java.sql.Statement, and tell

Re: Escape characters

2004-04-21 Thread Rhino
Wouldn't it be faster to simply try this than wait on people here to notice your question and write a reply? Have you checked the manual? It may answer your question too Rhino - Original Message - From: John Mistler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 21,

RE: Searching the Docs

2004-04-21 Thread Donny Simonton
Lou, I normally download the html version of the manual and have a little search feature just for it. And you are correct, I've looked for a few of your examples and can't find any information on them besides you can turn them on or off basically. Not in the mood to bust out the code to figure

problem

2004-04-21 Thread lga2
hi, I reinstalled mysql again and did what the website said. C:\ C:\mysql\bin\mysql -u root mysql mysql DELETE FROM user WHERE Host='localhost' AND User=''; mysql FLUSH PRIVILEGES; mysql QUIT C:\ C:\mysql\bin\mysqladmin -u root password newpwd C:\ C:\mysql\bin\mysqladmin -u root -h

Re: Confused by max and group by

2004-04-21 Thread Brent Baisley
The problem you are running into is that you are getting the max of one field and grouping by another. But then you want to get a third field that changes within the grouping. Perhaps this might work SELECT myindex, myval, mycat FROM `mytest` GROUP BY mycat ORDER BY myindex DESC;

mysql using big two tables in BSD

2004-04-21 Thread kamlesh pandey
Hi, I'm new to mysql. I have two big tables ,tableA4GB and tableB1GB. both tables around 10 million rows,each. tableA has following two cols. user_id(varchar(255) PRIMARY KEY user_data1(MEDIUMTEXT) entries looks like user1 xyz user2 x1.. tableB

User Conference Presentations

2004-04-21 Thread David Perron
Does anyone know if the presentations from the User Conference are available online? Thanks dp

first LIMIT then ORDER

2004-04-21 Thread Jacek Jaroczynski
Is there possibility to first LIMIT and then ORDER records? Using simple query I can first ORDER and then LIMIT like that: SELECT id, name FROM table ORDER BY name LIMIT 20,10 Maybe should I use procedures ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

ERROR 1030: Got error 127 from table handler

2004-04-21 Thread Bhaskar Borthakur
Hi I have been using MySQL server version 4.0.14 for the last six months in our project and it was running just fine. We use Linux AS 3.0 (kernel version 2.4.21-4.0.1.EL #1) However, since last week we started to get the following error : ERROR 1030: Got error 127 from table handler ( please

RE: Confused by max and group by

2004-04-21 Thread Chris
Well, in traditional SQL you'd use a sub-query for this type of operation. In MySQL 4.1+ you could do this: SELECT t1.myindex, t1.myval, t1.mycat FROM mytest t1 WHERE myindex = (SELECT max(t2.myindex) FROM mytest t2 WHERE t2.mycat=t1.mycat); once again, just illustrating the theory,

first LIMIT then ORDER

2004-04-21 Thread Jacek Jaroczynski
Is there possibility to first LIMIT and then ORDER records? Using simple query I can first ORDER and then LIMIT like that: SELECT id, name FROM table ORDER BY name LIMIT 20,10 Maybe should I use procedures ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

re-using a results set

2004-04-21 Thread Scott Swaim
I have a form that does the following ? while ($speaker = mysql_fetch_object($qid_speaker)) { ? option value=? pv($speaker-first_name) ? ? pv($speaker-last_name) ? ? pv($speaker-first_name) ? ?

reuse a results set

2004-04-21 Thread Scott Swaim
I have a form that does the following ? while ($speaker = db_fetch_object($qid_speaker)) { ? option value=? pv($speaker-first_name) ? ? pv($speaker-last_name) ? ? pv($speaker-first_name) ? ?

sorry for the multiple post. my error

2004-04-21 Thread Scott Swaim

RE: re-using a results set

2004-04-21 Thread Chris
This is a PHP question, not MySQL. http://www.php.net/mysql_data_seek -Original Message- From: Scott Swaim [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 2:47 PM To: Mysql Subject: re-using a results set I have a form that does the following ? while

RE: re-using a results set

2004-04-21 Thread Mike Johnson
From: Scott Swaim [mailto:[EMAIL PROTECTED] I have a form that does the following ? while ($speaker = mysql_fetch_object($qid_speaker)) { ? option value=? pv($speaker-first_name) ? ? pv($speaker-last_name) ?

Re: re-using a results set

2004-04-21 Thread Scott Swaim
Thank you Chris for that answer. I did not know if it was a mysql problem or php problem. Again I apologize (especially to Mike Johsnon) for the multiple request. I was getting a return error on the list and I thought it was a configuration error on my part. I did not mean to upset anyone.

MySQL 4.0 and Unicode

2004-04-21 Thread Stormblade
Ok, what is the recommended way of handling Unicode data with version 4.0. I believe I read that it doesn't support utf8 so how do people with version 4.0 deal with it? Do they store is as a binary object perhaps? Looking for techniques and ideas so I'll be able to see how much work is involved

Re: reuse a results set

2004-04-21 Thread Patrick
I generally set an array if I'm going to reuse a result. In your example, I would do something like the following: ? $i=0 ? ? while ($speaker = db_fetch_object($qid_speaker)) { $speakerName[i]=sprintf(%s %s,$speaker-first_name,

Re: User Conference Presentations

2004-04-21 Thread Robert Reed
Yes, I'm anxious to get my hands on some of the presentations myself. I think I saw a couple of brief mentions of a url but it wasn't written down anywhere. I'd also like to see some of the pictures I saw David snapping everywhere. :) --- David Perron [EMAIL PROTECTED] wrote: Does anyone

Re: User Conference Presentations

2004-04-21 Thread Robert J Taylor
You don't mean at the Discovery Cove near the Jimmy Buffet cover band do you? Speaking of which, Lars... there's an English expression that uses the word Cluster...but has nothing to do with databases... :) (Kidding! Just kidding!) Robert Reed wrote: Yes, I'm anxious to get my hands on

Converting tables to innoDB

2004-04-21 Thread Brad Tilley
Hello Mysqlers, I have a few small DB's (less than 10,000 entries per table) that track computer inventory in a mid-sized organization. Currently, all of the tables are MyISAM. Is there any compelling reason to convert these to InnoDB? We're not having any performance or size issues...

Syntax problems in MySQL v. 4.1.1-alpha-standard-log

2004-04-21 Thread cristopher pierson ewing
Apologies if this is an easy one, I'm stumped! I'm having some trouble with syntax running MySQL from the command line. I'm running MySQL 4.1.1-alpha from the OS X standard installer package on a G5 running panther. I have logged into MySQL as the root user, providing the correct password, and

Uninstall mysql

2004-04-21 Thread vasanthsena x
Hi, I tried to uninstall mysql from win Xp.however it did not remove everything completely.I tried to remove the files manually but specifically it does not let me delete mysqld.exe.it says access denied. Can anyone help me?I would to reinstall mysql. S.

Re: Problems adding table to Crystal Reports using ODBC Connection

2004-04-21 Thread Patrick
The only other thing I can think of off the top of my head is Crystal's very poor handling of prefix and postfix data in sub-reports. If you are using sub-reports make sure a field in the table in question is at least referenced on the main report. Sorry I couldn't be more help. Pat... -

bajar mysql

2004-04-21 Thread María de los Angeles Vargas
De donde puedo bajar la ultima versión de mysql.

  1   2   >