mysql unicode

2002-01-24 Thread Hery Yulianto
Hi All, I need to know, how to configure MySQL can be support unicode like Chinese (simplified and Traditional), Croation,Chezh or whatever. Thank you for explain to me Best Regard, Hery Yulianto - Before posting, please

Re: Några frågor

2002-01-24 Thread Jonas Björklund
This is an english mailinglist. Please write in english. 1. Nej. 2. Ja, du hittar det på http://www.mysql.com/downloads/contrib.html#SEC641 On Wed, 23 Jan 2002, Jimmy Geschwind wrote: Date: Wed, 23 Jan 2002 23:22:40 +0100 From: Jimmy Geschwind [EMAIL PROTECTED] To: [EMAIL PROTECTED]

FULLTEXT sintax.

2002-01-24 Thread Victor Hugo Reus Valiente
Hi there. Im having some troubles with mysql and FULLTEXT. I create one table like this: create table pets (id INT AUTO_INCREMENT NOT NULL PRIMARY KEY); alter table pets add name TEXT; alter table pets add kind TEXT; alter table pets add FULLTEXT name (name); alter table pets add FULLTEXT kind

RANDOM output order???

2002-01-24 Thread Angela Harneit
Hi, I've an actually quite simple problem, so I guess someone might know an answer... I just need a single random result from my query. With an older MySQL-Version this construction worked fine but with the new one not at all: SELECT ... ORDER BY RAND() LIMIT 1 So I tried out this one:

Re: substring replace

2002-01-24 Thread DL Neil
Hi SF, Hi, Please help me to use SQL (with mysql prompt) command to replace any digit in column. Example: Old value 123466 New value 123456 How to replace old value at fifth digit (6) to 5? You can download the MySQL manual to use it on your own machine, or access it online. Take a

Re: DELETE returns incorrect value

2002-01-24 Thread DL Neil
Gili, When I execute DELETE FROM VALID_CACHE; where VALID_CACHE is the name of a table I get 0 rows affected even if multiple rows are deleted.. I am expecting the return value to be the number of rows which were removed. Sorry, this is expected behavior, check out second paragraph in

ATT: Roger $ all : Re Data Sorting

2002-01-24 Thread Anton
Database, query THANKS TO ALL THAT HELPED, Roger, Egor, David, Anvar and anyone I missed I am runninh MySQL 3.22.32 which puts it just outside the version recommended by Roger, I tried spaces etc, even changed the to '' et etc. I think Roger might be right in the end (that my version) just

sub select

2002-01-24 Thread Sommai Fongnamthip
Hi, I know sub select would not work correct in 3.23.xx but I have a question to ask. I'd like to find top 10 ranking of my customer by amount (using order clause desc) but there are some customer have the same amount. I was solve this problem by using group by and insert it into

Error in accept: Bad file descriptor

2002-01-24 Thread Michael Widenius
Hi! Todd == Todd Ratson [EMAIL PROTECTED] writes: Todd Hi All, Todd I have an OpenBSD box running mysql-3.23.47, php4.1.1 Apache 1.3.22. Todd I have been using php-nuke on it for some time now without incident Todd until today... Todd I have tried to create a new database in order to add

Help! Problems with ASP

2002-01-24 Thread Peter Bremer
Can anybody please help me with this? Some queries I try in ASP don't return any result! Executing them in the EMS MySQL Manager show that they all should return something... % Set con = Server.CreateObject (ADODB.Connection) con.Open (Driver=MySQL;SERVER=peter;DATABASE=ppm3;UID=root) set

Re: DELETE returns incorrect value

2002-01-24 Thread Dr. Frank Ullrich
Gili, if all rows are affected (as in your case) MySQL just discards the whole table content at once so it cannot return the number of affected rows. If you are interested in it put a dummy where clause into your statement such as 'where 10'. That causes MySQL to delete row by row and then it

Re: mysqld freebsd

2002-01-24 Thread Oleg Prokopyev
Ken Menzel wrote: Hi Oleg, There is some sort of thread problem with freebsd but it usuually is not that bad. How did you compile MySQL? I would recommend using the ports version of Mysql (cd /usr/ports/databases/mysql-3.23-server) . Look at the makefile if you are still havbing

RE: three-way join

2002-01-24 Thread Roger Baklund
* mike vogel thanks to all respondents! one more thing, i have 2 foreign keys in the bridge table, but not a primary key. is a primary key in the bridge necessary for this type of join to work? thanks again. Make the two foreign keys the primary key for this table, that way you prevent the

Re: Help! Problems with ASP

2002-01-24 Thread Nuno Gonçalves
Try using a recordset: Set con = Server.CreateObject (ADODB.Connection) Set rst = Server.CreateObject(ADODB.Recordset) rst.Open SELECT ID FROM Items, con, 3, 3 ' Use de results of the recordset here rst.Close Nuno A. S. Gonçalves [EMAIL PROTECTED] - Original Message - From: Peter

Simple: Date Stamp mySQL and PHP

2002-01-24 Thread Shannon Kendrick
Hi all, Ive got a timestamp in a database column and basically I was wondering if there was any function in PHP to parse the date into something more readable from 20020123143547 23 Jan 2002 14:35 something like $date1= datetoreadable($date); Thanks Shannon

Re: Is my table good indexed ?

2002-01-24 Thread Ireneusz Piasecki
Hi folks. I have table: mysql describe gosc; +-+-+--+-+-+ ---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+ ---+ |

Re: Simple: Date Stamp mySQL and PHP

2002-01-24 Thread Marcus Müller
Hi, have a look at http://www.php.net/manual/en/function.date.php According to your example, it would be something like: ?php $date1=date(d M Y H:i, 20020123143547); ? Regards Marcus Ive got a timestamp in a database column and basically I was wondering if there was any function in PHP to

Problem with MySQL4.0.1 speed, cpu- and memory-usage

2002-01-24 Thread Marcus Mueller
Hello, in order to be able to use the replication features of MySQL we recently gave version 4.0.1alpha a try, since these features are reportedly more reliable in this version - although it is still alpha. Unfortunately the disadvantages - at least on our machines - don't seem to make up for

Re: Simple: Date Stamp mySQL and PHP

2002-01-24 Thread DL Neil
What's this? PHP on the MySQL list - such heresy!!! Do not pass go, go directly to: http://www.mysql.com/doc/D/a/Date_and_time_functions.html =dn - Original Message - From: Marcus Müller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 24 January 2002 11:17 Subject: Re: Simple: Date

Re: Simple: Date Stamp mySQL and PHP

2002-01-24 Thread Marcus Müller
Oops, got it all wrong. Thought it was a real timestamp, but it's already the date, only formatted in a different way. The date() function expects a Unix-timestamp as its second argument. Thus you could try to leave the conversion to MySQL by using UNIX_TIMESTAMP(your_timestamp_column) or if you

Hoe to create indexes on existing tables

2002-01-24 Thread Princy . Thomas
Hi, I'm a bit to Mysql. We are trying to use mysql as a backend for our Visual Basic application. I had a set of tables which I exported from Access database. But now, I want to index these tables. How do I go about that? Also, any suggestions of how cursors work with mysql would be of great

Need very very Urgent help

2002-01-24 Thread PARDHASARADHI VENKATA NARAPARAJU
Hi, I installed mysql-3.23.47-win version on Win NT 4.0 Workstation, but I cant start MySQL service. When I am trying to start mysql service, I get an error msg like this: Could not start the MySql service on \\SARADHI. Error 1067 : The process terminated unexpectedly. I installed mysql

Re: Hoe to create indexes on existing tables

2002-01-24 Thread Marcus Müller
I had a set of tables which I exported from Access database. But now, I want to index these tables. How do I go about that? http://www.mysql.com/doc/A/L/ALTER_TABLE.html mysql ALTER TABLE your_table ADD KEY(your_column); Hope that helps Marcus

Re: ¿bug?

2002-01-24 Thread Carmen Pedrajas
Hola: ¿No es posible utilizar una funcion en el default de un campo de una table? Intentando, en un campo, poner default = sysdate(), para almacenar automáticamente la fecha de inserción de cada registro, la fecha que se almacena es 00-00-0001. ¿Es esto un bug? Un saludo, Carmen

table description in database differs from script definition

2002-01-24 Thread Roman Zagorowski
i create table from script: create table if not exists msg00m1 ( id int primary key auto_increment, hid int not null, dsg char(10) not null, nt char(7) not null, gn char(2) not null, wot char(12) not null, k char(19) not null, k2 varchar(20) not

Re: Hoe to create indexes on existing tables

2002-01-24 Thread webmaster
|Hi, | |I'm a bit to Mysql. We are trying to use mysql as a backend for our Visual |Basic application. | |I had a set of tables which I exported from Access database. |But now, I want to index these tables. How do I go about that? | Hi! the simplest solution is to get a GUI client for

perl DBD::mysql question

2002-01-24 Thread Paul van den Berg
Hello list, the regular mysql-client returns some useful information after batch-inserts like: Query OK, 11393 rows affected (0.47 sec) Records: 11393 Duplicates: 0 Warnings: 0 I can fetch the number of effected rows in perl/DBI with $sth-rows, but is it possible to fetch the count of

Re: It stoped working, and won't work anymore

2002-01-24 Thread Gerald Clark
What did you change? And the logs say? Lauren Matheson wrote: I've just bumped into the same problem - a RedHat 6.1 server that ran for 2 years with MySQL-3.22.27-1.i386 rpm's from the mysql site, and the server just died and is having identical behaviour to that describe - hangs on

Re: Export database

2002-01-24 Thread Gerald Clark
Can you be more specific? Export to what/where? Manish Mehta wrote: Hi i have 3.23.32 version of mysql. i wants to export the database from \mysql\bin\ please tell. thanks in advance Manish Mehta CORE Solucomm Limited 423 B, Hamilton Court, DLF City, Phase IV, Gurgaon, India - 122 001. Tel:

Re: Strange MyISAMCHK warning

2002-01-24 Thread Gerald Clark
Since you said tables ( plural ), I hope you are not running myisamchk while the server is running. Fournier Jocelyn [Presence-PC] wrote: Hi, myisamchk shows me the following warning message on some of my tables : myisamchk -a searchjoinhardwarefr2.MYI Checking MyISAM file:

Re: Installing Mysql 4.0.1 on Redhat 7.2 with PHP 4.0.6

2002-01-24 Thread Trond Eivind Glomsrød
On Wed, 23 Jan 2002, Jim Lucas [jimmysql] wrote: But I am installing all the apps from the RPM's that came from Redhat.com The apps coming from Red Hat Linux work together. You have downloaded and installed a different (development ) version of MySQL. It's not compatible with the old one.

Re: Is my table good indexed ?

2002-01-24 Thread Gerald Clark
You have a function on a field in the where clause, so no index can be used. Do your date_add() on the NOW() and compare it directly to the field. Ireneusz Piasecki wrote: Hi folks. I have table: mysql describe gosc; +-+-+--+-+-+

mysql_use_result, out of sync, Mysql

2002-01-24 Thread Bernard Chambon
Hello What do to if mysql_use_result return NULL ? I can't understand ? I have only one query by connection, of course. I talk about SELECT statement in my query (not INSERT or anything else) Mysql run on linux. From time to time mysql_use_result() return NULL. I throw and catch an

Re: Help to install MySql on SuSE 7.1

2002-01-24 Thread Egor Egorov
Alessandro, Wednesday, January 23, 2002, 9:43:00 PM, you wrote: How did you install MySQL? Is it the binary distribution from MySQL or you have compiled the software from the sources? AT I used the rpm inside the SuSE's distribution. Download the binary distribution from

RANDOM output order???

2002-01-24 Thread Egor Egorov
Angela, Thursday, January 24, 2002, 11:15:46 AM, you wrote: AH With an older MySQL-Version this construction worked fine but with the AH new one not at all: AH SELECT ... ORDER BY RAND() LIMIT 1 This should work fine. I think there are problems in your statement where you have put ... in

RE: Can Anyone explain / help with auto_increment fields.

2002-01-24 Thread Egor Egorov
Matthew, Thursday, January 24, 2002, 12:30:13 AM, you wrote: MD thanks a simple but effective explination. You can insert whatever you want in that field - here applies all the rules of a primary key. But when you insert zero (or nothing), the database server will insert the next available

Re: Problem granting DELETE privileges on only a few tables in a

2002-01-24 Thread Egor Egorov
Diana, Wednesday, January 23, 2002, 7:33:35 PM, you wrote: DS Maybe you did not execute FLUSH PRIVILEGES or run mysqladmin DS flush-privileges to tell the server to reload the grant tables. DS Until this, your changes will not take effect. There is no need to run mysqladmin reload or FLUSH

Export database

2002-01-24 Thread Victoria Reznichenko
Manish, Thursday, January 24, 2002, 8:57:01 AM, you wrote: MM Hi MM i have 3.23.32 version of mysql. i wants to export the database from MM \mysql\bin\ MM please tell. If you would like to export database, use mysqldump: http://www.mysql.com/doc/m/y/mysqldump.html If you would like to move

mysqld startup help!!

2002-01-24 Thread Victoria Reznichenko
Rahadul, Thursday, January 24, 2002, 12:17:17 AM, you wrote: RK Hi, RKI installed MySQL version 3.23.47. It starts up and stop when i RK use the following command RK /etc/rc.d/init.d/mysql start RK /etc/rc.d/init.d/mysql stop RK Bu I attem to start /usr/sbin/mysqld server and edit the

Re: Hoe to create indexes on existing tables

2002-01-24 Thread Victoria Reznichenko
Princy, Thursday, January 24, 2002, 3:23:24 PM, you wrote: PT Hi ! PT I did try using the mysql client gui but you cant create indexes thru that. PT Also, since I've exported from access, the datatype all seem to be PT MEDIUMTEXT. PT So, when I try the create index syntax, PT ie, CREATE

table description in database differs from script definition

2002-01-24 Thread Victoria Reznichenko
Roman, Thursday, January 24, 2002, 2:36:45 PM, you wrote: RZ i create table from script: RZ create table if not exists msg00m1 ( RZ id int primary key auto_increment, RZ hid int not null, RZ dsg char(10) not null, RZ nt char(7) not null, RZ gn char(2) not null, RZ

Recovery Problem

2002-01-24 Thread Victoria Reznichenko
Ives, Thursday, January 24, 2002, 5:04:09 AM, you wrote: IS Hi there, IS yesterday my mysql server (running under irix) has gone away IS and took one table with it IS so i tried to recover the data with isamchk -o table_name IS unfortunalty during the recoveryprocess half of the data IS will

SOME ITEMS THAT YOU MAY BE INTERESTED IN OR BE ABLE TO ADVISE ME ON

2002-01-24 Thread kriss rolo
These are the items that iam interested in selling.. Could you help me with some details on the goods, history, origin etc. are these worth anything and if so who would i contact with regards to selling them? and the best way to sell them ie auction etc APOLOGISE IF YOU HAVE ALREADY RECEIVED

multi-master replication

2002-01-24 Thread Greg Donald
Will MySQL, at any time in the near future, support multi-master replication? We're looking at splitting some very large databases up among several machines, but we need a way to bring them back together for our stats creation databases on the backend. What we need is a way to combine databases

I deleted my root user!

2002-01-24 Thread Lisa Williams
Please help. I accidentally deleted the root user and now I can't do anything. How can I recreate this user with super user privileges? I'm new to MySQL so please be detailed. Thanks in advance Lisa - Before posting,

RE: I deleted my root user!

2002-01-24 Thread Andrew Schmidt
http://www.mysql.com/doc/R/e/Resetting_permissions.html after starting mysql with the --skip-grant-tables, you'll have to execute a grant statement http://www.mysql.com/doc/G/R/GRANT.html GRANT ALL PRIVILEGES ON *.* TO root@localhost INDENTIFIED BY 'somepassword' WITH GRANT OPTION; then

How do you know?

2002-01-24 Thread Jay Paulson
How do you know what the maximum connections you can have at one time with mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

RE: How do you know?

2002-01-24 Thread Roger Baklund
* Jay Paulson How do you know what the maximum connections you can have at one time with mysql? mysql show variables like max_connections; -- Roger query, table - Before posting, please check:

Re: How do you know?

2002-01-24 Thread Garrett Marone
log into the mysql command line, type show variables and look for max_connections In the last episode (Thursday 24 January 2002 11:24 am), Jay Paulson wrote: How do you know what the maximum connections you can have at one time with mysql?

Re: How do you know?

2002-01-24 Thread Jay Paulson
Next question: How do you increase that variable? Also, is there a number that is generally considered too high or does that depend on the server you are running MySQL on? (an example would be GREAT!) thanks. - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL

MyVBQL in depth help needed

2002-01-24 Thread Joe Bradbury
I have seen this question a couple times on the mailing list, but have not seen a legitimate answer except a link to the website it can be downloaded. I have downloaded and set everything up for MyVBQL, but I am new to databases in general and have no idea where to start to even try to connect. I

Re[4]: regarding the MySQL's server Caching feature

2002-01-24 Thread Victoria Reznichenko
Hello Chetan, CL hi, CL I wanted to set variable query_cache_size.. CL I have tried for this as in below but the machine hangs up every time i CL am doing this... CL Any other method by which I can set this Variable..? Try to run safe_mysqld in background mode. CL shell mysqld -u root

FULLTEXT sintax.

2002-01-24 Thread Victoria Reznichenko
Victor, Thursday, January 24, 2002, 10:59:03 AM, you wrote: VHRV Hi there. VHRV Im having some troubles with mysql and FULLTEXT. [] VHRV Now, I have the next rows: VHRV ID NAME KIND VHRV 1Boby Asiatic and colored VHRV 2Linda American,

Re: MyVBQL in depth help needed

2002-01-24 Thread Joel Wickard
mysql, database http://shop.barnesandnoble.com/booksearch/results.asp?WRD=MySqluserid=6AF42 HL01D - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: Mysql very slow --why???

2002-01-24 Thread Simon Green
What if you run SQL questons from MySQL command line? What SQL questons are you trying to run? Simon PS yes MySQL if very fast -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 January 2002 17:19 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Mysql very

Re: Mysql very slow --why???

2002-01-24 Thread Christopher Thompson
At 05:19 PM 1/24/2002 +, [EMAIL PROTECTED] wrote: I've installed Mysql on my machine, two of my machines, one on win98 and other on windows 2000. But for some reason when the developer is trying to run any query from a VB applications, it tends to slow and hang both the machines. I 'm trying

Database Maintenance Routines?

2002-01-24 Thread Kalok Lo
Hi, I'm new at the Database Maintenance Role. Can anyone tell me what are the basic things that need to be done to keep my database healthy ? i.e. I've heard that it's good to regularly rebuild indexes. How frequently should that be done ? And what is the best way to go about it. -

Re: C++ API

2002-01-24 Thread Sinisa Milivojevic
Christopher Thompson writes: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 For various reasons, I need a C++ API to MySQL for use in Windows (and possibly Linux as well). I know I can find one or two in the downloads/contrib section but I'm looking for suggestions. I'm quite happy

Re: Problem with UPDATE and User Variables

2002-01-24 Thread Paul DuBois
At 18:32 +0100 1/24/02, Peter Bremer wrote: Hi, Can anybody explain why the following does not work? SELECT @variable := value1; UPDATE table SET field1 = @variable WHERE field2 = value2; The result is always that field1 is set to NULL... Works for me, if I substitute a real value for

HOSTNAME-bin.001 ???

2002-01-24 Thread Jacob Friis Larsen
I found files whith names like localhost-bin.001, localhost-bin.002 in /tmp/ What are they ? Also, what does it mean that my MySQL database version is 3.23.47-log. What does -log mean ? Regards Jacob [ www.sharksforum.com | www.eksperten.dk | +45 70 27 07 67 ]

Re: how to repair bdb tables?

2002-01-24 Thread Egor Egorov
Kalok, Thursday, January 24, 2002, 6:51:26 PM, you wrote: KL I'm having the same need. KL It looks like the following is intended for MyISAM tables only: KL http://www.mysql.com/doc/U/s/Using_mysqlcheck.html KL Has anyone else had any other luck ? Sometimes mysqlcheck works for BDB tables.

RE: Problem with UPDATE and User Variables

2002-01-24 Thread Peter Bremer
Ooops!! This seems to be a bug in EMS MySQL Manager... Sorry to bother you all... Regards Peter -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: do 24 jan 2002 18:51 To: Peter Bremer; Mysql (E-mail) Subject: Re: Problem with UPDATE and User Variables At

Re: HOSTNAME-bin.001 ???

2002-01-24 Thread Gerald Clark
Jacob Friis Larsen wrote: I found files whith names like localhost-bin.001, localhost-bin.002 in /tmp/ What are they ? Log files. Also, what does it mean that my MySQL database version is 3.23.47-log. What It means it is logging. does -log mean ? Regards Jacob [ www.sharksforum.com

Re: Processlist Commands in sql/sql_parse.cc:72

2002-01-24 Thread Sinisa Milivojevic
On Wed, 23 Jan 2002 16:53:47 -0800 Jeremy Zawodny [EMAIL PROTECTED] wrote: In sql/sql_parse.cc:72 (roughly), a list of command names is defined: const char *command_name[]={ Sleep, Quit, Init DB, Query, Field List, Create DB, Drop DB, Refresh, Shutdown, Statistics, Processlist,

JDBC Driver for MySQL3.23.47-1

2002-01-24 Thread Rahadul Kabir
hi, I recently installed MySQL3.23.47 and now I need the JDBC drivers for it. Does anyone know where can I find a Free JDBC driver that would work with MySQL 3.23.47-1? thanks so much --rahad - Before posting, please check:

Re: JDBC Driver for MySQL3.23.47-1

2002-01-24 Thread Neil Zanella
http://mmmysql.sourceforge.net/ On Thu, 24 Jan 2002, Rahadul Kabir wrote: hi, I recently installed MySQL3.23.47 and now I need the JDBC drivers for it. Does anyone know where can I find a Free JDBC driver that would work with MySQL 3.23.47-1? thanks so much --rahad

benchmarking pgsql with mysql benchmark suite

2002-01-24 Thread jon-david schlough
hi. i'm trying to benchmark pgsql living in cygwin on a 2K box with mysql installed normaly on windows. i get: C:\mysql\benchperl run-all-tests --host=PAVILION --server=Pg --user=n --password=x --log --comment 2x Pentium II 400mz, 256M, under vmware Got error:

Getting only the latest entries in a table...

2002-01-24 Thread Anthony R. J. Ball
MySQL 3.23.41 on Solaris Is it possible to select only the latest entries from a table? For instance I have a table of datasets that get loaded each day. I want to find the latest date that each dataset was loaded. I thought maybe a join against itself might be the answer, but this

Re: It stoped working, and won't work anymore

2002-01-24 Thread Lauren Matheson
I don't know of any changes that happened right at the time that it went down. Now, the box _was_ rooted :-), but I *think* mysql going down was independent of that. Since then I've reinstalled every rpm on the system, so it should be clean. MySQL hangs as I install the rpm for it though as

Re: Processlist Commands in sql/sql_parse.cc:72

2002-01-24 Thread Sasha Pachev
On Thursday 24 January 2002 11:44 am, Sinisa Milivojevic wrote: ?(2) Can someone give me an idea what these correspond to: ? ? ? ?Connect Out Slave connecting to master. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __

Re: Strange MyISAMCHK warning

2002-01-24 Thread Fournier Jocelyn [Presence-PC]
Of course not ;) I only run myisamchk -a on several table, and I noticed sometime a similar message (although the tables seem to work perfectly) Jocelyn - Original Message - From: Gerald Clark [EMAIL PROTECTED] To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]

DataBreeze for MySQL

2002-01-24 Thread Joe Junkin
Hi all MySQL'ers, We have finally completed our initial public version of the DataBreeze Web Application system that uses MySQL as the underlying SQL database. The system requires Linux(or unix), Apache, Perl, ModPerl and MySQL. As this is a MySQL specific system, feedback from the MySQL

temporary table?

2002-01-24 Thread mike vogel
how can i select a join and then use the resulting table in another join? i did it with a temporary table, but is there a way to do it with a single compound statement? thanks in advance! - Before posting, please check:

Optimizing and more connections

2002-01-24 Thread Jay Paulson
I'm trying to increase the maxium number of connections to my MySQL database but I am not sure how to do this. I've gone to the manual and it doesn't say too much (maybe i'm looking in the wrong spot?). The machine I'm running is an AMD 650 with 512 Ram on RedHat 7.1 and MySQL 3.23.41 so I

Re: Linking problems

2002-01-24 Thread Guy-Maurice Lepoutre
Hello, I am using Visual C++ 6.0 and I have some linking problems while trying to run the example program MFC_ex.cpp included in the downloading files in the mysql.com website. Here are the errors I get: Configuration: MFC_ex - Win32 Debug Linking...

Slow updates with two keys in where.

2002-01-24 Thread Brian Moon
I have pasted below some queries and a table structure that I am finding to be very slow. As you can see, if I or the two keyed fields, the query takes ~7 seconds. If I just run them by themselves, it takes no measurable time. Is this something we just have to live with? Or, is there something

Re: Getting only the latest entries in a table...

2002-01-24 Thread Erv Young
Sounds like you have a table (lkup_info) of load dates (date), in which you record fileid (did) and date. Sounds like you do not have a separate table of fileids. I'm assuming that the lkup_info table is updated synchronously with the loading of each file that the table is recording, though

Varchars Vs. Chars on Read Only Table

2002-01-24 Thread Michael Stearne
When doing selects on a read-only myISAM packed table, are varchar fields still slower than char fields? Thanks, Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Tighly packed table

2002-01-24 Thread Michael Stearne
We have a somewhat large read-only table (2.9 million recs). I am wonder if there is a utility that will look at each row of each columns and come up with a summary of the largest field (in character length) for each column. For example, scan each row's firstname field and report that the

RE: Slow updates with two keys in where.

2002-01-24 Thread Andrew Schmidt
MySQL can only use 1 index per query. So take your first query for example: update forum set approved='N' where id=644122 or thread=644122 it can only use the id key OR the thread key, not both. and since you have an 'or' in your query MySQL must scan the entire table for either id being

Re: Varchars Vs. Chars on Read Only Table

2002-01-24 Thread Jeremy Zawodny
On Thu, Jan 24, 2002 at 04:06:57PM -0500, Michael Stearne wrote: When doing selects on a read-only myISAM packed table, are varchar fields still slower than char fields? Since it's essentially a MyISAM table with compression done at the row-level, I'd expect so. But the difference has to be

Re: Tighly packed table

2002-01-24 Thread Christopher Thompson
At 04:10 PM 1/24/2002 -0500, Michael Stearne wrote: We have a somewhat large read-only table (2.9 million recs). I am wonder if there is a utility that will look at each row of each columns and come up with a summary of the largest field (in character length) for each column. For example,

Re: Installing Mysql 4.0.1 on Redhat 7.2 with PHP 4.0.6

2002-01-24 Thread Jim Lucas [jimmysql]
Is this what you had to do? If so, could you point me to a location on the web or in a book store to aquire knowledge on how to compile new software. I have only compiled one piece of software, Courier Mail Service. It was interesting! But, I feel that I would need a little more help with all

Re: Installing Mysql 4.0.1 on Redhat 7.2 with PHP 4.0.6

2002-01-24 Thread Trond Eivind Glomsrød
On Thu, 24 Jan 2002, Jim Lucas [jimmysql] wrote: Is this what you had to do? No, I don't do it. If you stay with the stable version of MySQL, you avoid this problem. MySQL 4 will show up in Red Hat Linux (at least the development tree when it's declared the) stable branch, and applications

Re: Tighly packed table

2002-01-24 Thread Michael Stearne
Christopher Thompson wrote: At 04:10 PM 1/24/2002 -0500, Michael Stearne wrote: We have a somewhat large read-only table (2.9 million recs). I am wonder if there is a utility that will look at each row of each columns and come up with a summary of the largest field (in character length)

Re: how to repair bdb tables?

2002-01-24 Thread Heikki Tuuri
Hi! CHECK TABLE does not do anything on BDB tables. On InnoDB and MyISAM tables CHECK TABLE tries to verify the physical consistency of the table and its indexes. The way to repair InnoDB or BDB tables is to dump, drop, and reimport them. Best regards, Heikki Tuuri Innobase Oy --- Order

RE: Installing Mysql 4.0.1 on Redhat 7.2 with PHP 4.0.6

2002-01-24 Thread Trond Eivind Glomsrød
On Thu, 24 Jan 2002, Shankar Unni wrote: Should we take this offline? The Redhat packaging for MySQL calls it mysql (lowercase). MySQL AB's packaging calls it MySQL (upper/mixed case). The layout in each of those packages is quite different. But that wasn't the problem. So version

RE: Tighly packed table

2002-01-24 Thread Roger Karnouk
select max(length(firstname)) from TableName; -Original Message- From: Michael Stearne [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 4:38 PM To: Christopher Thompson Cc: [EMAIL PROTECTED] Subject: Re: Tighly packed table Christopher Thompson wrote: At 04:10 PM 1/24/2002

RE: Tighly packed table

2002-01-24 Thread Christopher Thompson
Acck! Yes, please please do that. O(n) instead of O(n^2) (*). This is a much better solution. I was trying to convert 'there exists n such that for all m where n != m, n = m, return n'. Damn logic. (*) To be honest, I'm not even sure what the runtime of my original query was. A good

Re: Tighly packed table

2002-01-24 Thread Michael Stearne
The problem is, this query really hurts (I don't know if it finishes) for unindexed field for 2.9 million rows. But I'm sure it will finish eventually. Michael Roger Karnouk wrote: select max(length(firstname)) from TableName; -Original Message- From: Michael Stearne [mailto:[EMAIL

Efficiently storing md5

2002-01-24 Thread Steven Roussey
Does anyone have a best practices for efficiently storing md5 hash values in MySQL? Since it is a 32 character string of hex numbers, I originally stored them in a char(32) binary column. But that is wasted space (by a factor of 2). And of course, these things add up, both in data files and

Re: Tighly packed table

2002-01-24 Thread Christopher Thompson
At 05:58 PM 1/24/2002 -0500, Michael Stearne wrote: The problem is, this query really hurts (I don't know if it finishes) for unindexed field for 2.9 million rows. But I'm sure it will finish eventually. Yes, it will really hurt. After all, there's no way for MySQL to do this other than

Re: mysqld freebsd

2002-01-24 Thread Jeremy Zawodny
On Thu, Jan 24, 2002 at 12:19:12PM +0200, Oleg Prokopyev wrote: Ken Menzel wrote: Hi Oleg, There is some sort of thread problem with freebsd but it usuually is not that bad. How did you compile MySQL? I would recommend using the ports version of Mysql (cd

Re: Tighly packed table

2002-01-24 Thread Michael Stearne
I actually have all the records in a 1GB text file, so here comes perl to the rescue!! (Easier than C to me, maybe I'll do it in Java as an exercise.) BTW if anyone has any questions on the ability of MacOS X with medium size DBs. This DB is running on a 500Mhz iMac G3 with 1GB of RAM and

Which is faster VarChar(255) or Text?

2002-01-24 Thread BD
I will be putting variable length text into a field (up to 255 characters but typically around 60 characters) and wonder what makes for faster retrieval? Or does it matter? A field defined as Varchar(255) or Text? It is unlikely this field will be used for searching and it will not be

Re: Tighly packed table

2002-01-24 Thread DL Neil
...and because no one has been really cynical... After that query runs, then prepare for a coffee overload whilst you perform the ALTER TABLE, then get ready because if you shorten the field to (say) 12 characters/bytes the very next day, someone with a 13 character name is going to try to

LOAD DATA INFILE - Duplicate entry '' for key...

2002-01-24 Thread Bogdan Stancescu
Hi all! I bumped in a strange problem. I dumped a help table (i.e. only text) into a file. The table contains two fields: a topic (unique) field and a content field. Then performed a LOAD DATA INFILE on the resulting file in a different database with identical structure. Everything worked

Re: Slow updates with two keys in where.

2002-01-24 Thread Brian Moon
Is this just something we have to live with or does MySQL 4 handle this better? Brian. - Original Message - From: Andrew Schmidt [EMAIL PROTECTED] To: Brian Moon [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 3:11 PM Subject: RE: Slow updates with two keys in

Re: LOAD DATA INFILE - Duplicate entry '' for key...

2002-01-24 Thread Bogdan Stancescu
Just for the record, found the glitch: somehow, somebody on the way decided to change LF's into CRLF's (I remotely dumped the data and e-mailed it locally where I test the setup process, so maybe the mail agent?). I just had to replace 0x0d0a's into 0x0a's in a hex editor and everything works

other mailing lists?

2002-01-24 Thread Michael Oblena
Anyone, Are there any other mailing lists about databases out there? If so, can you post a link to their site where i can register? Thanks, Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual)

  1   2   >