Re: about big5 charset
Ben, This really belongs on the main list, so I'm CCing that instead of internals. How carefully have you read section 4.6 of the manual? http://www.mysql.com/doc/L/o/Localisation.html You shouldn't have to make a big5.conf. Big5 is supported in the standard distribution for quite some time, and the necessary files should be in place. The file you need to edit (or make) for MSWinjunk is probably C:\WINNT\my.ini. Look over the manual carfully. -- Joel Rees [EMAIL PROTECTED] Ben Koo inquired Dear Sirs, would you mind to tell me how to add "big5" or "gb" chinese charset into mySQL DB since my DB now is not support big5, and i don't know how to make a big5.conf file and don't know put it in which directory, is it (e.g: C:\MySQL\share\)?? i read the manual it said that put it in C:\MySQL\share\string\, but i haven't that directory... so could you explain it to me... Thanks a lot! Best Regards, Ben == $B%r%o%((BL$B!<%/%1%&%1(Ba$B%A(Bn$B%=~C(B|$B!#(BGhttp://sms.sina.com.hk/ringtone/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Joining question
Hi I'm designing 2 tables, where tabProds has the foreign key of tabUsers. So when I want to join them I use.. WHERE tabProds.usr_ID = tabUsers.usr_ID Ok But the thing is that sometimes will not be possible to specify a user when you insert a Product(becaouse we don't know at that time)... And I'm anticipating the query mentioned above would not display the products that doesn't match any user's ID, AND I want those records to be showed too. Would be like this...? WHERE (tabProds.usr_ID = tabUsers.usr_ID) or (tabProd.usr_ID= Null) But, with this query, what is going to show on the User's columns when it gets a Null field..? ProdID UserID UserName 232John 34Null? --- What's going to happen here..? 454Pedro Or is there anohter options..? like Left joins.. and all that, (I haven't analize them yet) I know you may think... Well do the test and see it, well yes, is just that affects the way I'm thinking to design the web system, and I would like to know when I'm on the DB design and before the programming Thank you jgarza - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delphi MySQL Access Components
Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySql 3.23 to version 4 upgrade
Hi all , i'm about to upgrade from MySql 3.23 to version 4 are there any issues that should be addressed ie uninstall v3 prior to installing v4 or can i just install over v3. Any suggested sites' ,FAQ regarding my question. -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
M$ Acesss Front MySql-Backend field datatype issues using Myodbc
Hi again . I have a project whereby the client has a legacy M$ Access ( as far as im concerned ) and i'm to design.build and construct a MySql v4 Back-end and more than likely pursue a front-end with MS Access due to easability and conversant of it's user's nevertheless are there any field datatype issues and if so is there a site or FAQ that suggests prior to development the tried and tested field datatype that will run smoothly between both front back end . If it is clumbberson i more than likely use MySql-Front. Plz can someone confirm that MySql Front has similiar look feel in relation to Forms , buttons and alike. Plz post any good links regarding field datatypes or Sample Projects built with MySql v4 Front. -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Bug or feature fulltext search?
Hello Sergei, Tuesday, July 23, 2002, 10:17:06 PM, you wrote: SG Hi! SG On Jul 23, Artem V. Ryabov wrote: Hello mysql, see this 2 queries: why they not equal? why first skip many records? mysql select left(ftText,20) from Txt_index where match(ftText) against('+(wùd200206*) +wù12p' in boolean mode); 3 rows in set (0.36 sec) mysql select left(ftText,20) from Txt_index where match(ftText) against('+wùd200206* +wù12p' in boolean mode); 42 rows in set (8.00 sec) mysql show variables like 'version'; +---+-+ | Variable_name | Value | +---+-+ | version | 4.0.2-alpha-log | +---+-+ 1 row in set (0.00 sec) SG Obviously, it's a bug. yes. next query prove it: mysql select left(ftText,17),match(ftText) against('+(wùd200206*) +wù12p' in boolean mode) as m from Txt_index where match(ftText) against('+wùd200206* +wù12p' in boolean mode); +---+--+ | left(ftText,17) | m| +---+--+ | wùd20020601 wù12p |1 | | wùd20020601 wùnw |1 | | wùd20020604 wù12p |1 | | wùd20020604 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020611 wù12p |1 | | wùd20020611 wù12p |1 | | wùd20020611 wù12p |1 | | wùd20020611 wù12p |1 | | wùd20020611 wù12p |1 | | wùd20020614 wù12p |1 | | wùd20020614 wù12p |1 | | wùd20020619 wù12p |1 | | wùd20020619 wù12p |1 | | wùd20020619 wù12p |1 | | wùd20020619 wù12p |1 | | wùd20020619 wù12p |1 | | wùd20020625 wù12p |1 | | wùd20020625 wù12p |1 | | wùd20020625 wù12p |1 | | wùd20020625 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | +---+--+ 42 rows in set (3.46 sec) mysql SG Could you provide a test case ? but how? Table very big: mysql SHOW TABLE STATUS like 'Txt_index'; +---+++---++-+-+--+---++-+-+-++---+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | |Max_data_length | Index_length | Data_free | Auto_increment | Create_time | |Update_time | Check_time | Create_options | Comment | +---+++---++-+-+--+---++-+-+-++---+ | Txt_index | MyISAM | Dynamic| 42744 | 6032 | 257856408 | |4294967295 |166645760 | 0 | 58071 | 2002-07-11 15:22:31 | |2002-07-11 15:30:56 | 2002-07-11 15:42:25 || Ïîëíîòåêñòîâûé èíäåêñ | +---+++---++-+-+--+---++-+-+-++---+ 1 row in set (0.03 sec) mysql show create table Txt_index; +---++ | Table | Create Table | || +---++ | Txt_index | CREATE TABLE `Txt_index` ( `ID` int(11) NOT NULL auto_increment, |`ftText` mediumtext NOT NULL, PRIMARY KEY (`ID`), FULLTEXT KEY `ftText` |(`ftText`)) TYPE=MyISAM COMMENT='Ïîëíîòåêñòîâûé èíäåêñ' | +---++ 1 row in set (0.02 sec) mysql short table work without bug: mysql create table
RE: Joins, ANSI 92 or the old way
Hi, As I understand it an ANSI92 join is written as; SELECT b.columnA FROM tableB AS b JOIN ON tableC AS c ON b.id = c.id Whereas the 'old' style would be; SELECT b.columnA FROM tableB AS b, tableC AS c WHERE b.id = c.id Personally I find the former much easier to read though not sure about the practical differences between them when the statements are executed. Regards, Matt -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: 23 July 2002 18:23 To: Defryn, Guy Cc: '[EMAIL PROTECTED]' Subject: Re: Joins, ANSI 92 or the old way Hi. On Wed 2002-07-17 at 14:16:39 +1200, [EMAIL PROTECTED] wrote: I was wondering what advantages one has over the other. I think the old way is easier but is it good enough? I have no clue what you are talking about and I am sure I am not the only one. Mind giving an example? Greetings, Benjamin. -- [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.377 / Virus Database: 211 - Release Date: 15/07/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.377 / Virus Database: 211 - Release Date: 15/07/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Important: Got error 127 from table handler (1030)?
Hi, well, the subject says it all. I'm using version 3.23.41-log, and I got the following error message when trying to update a row: Got error 127 from table handler (1030) It's a normal query which has succeeded several thousand times already. Any ideas what might be wrong? Thanks, Daniel Brockhaus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange NULL.
Description: Strange NULL in reply. How-To-Repeat: mysql CREATE TABLE S (ID1 int, ID2 int, ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID)); Query OK, 0 rows affected (0.00 sec) mysql insert into S values (1,244,NULL),(2,243,NULL),(134,223,NULL),(185,186,NULL); Query OK, 4 rows affected (0.00 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql mysql # my request (strange NULL in reply) mysql select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level - from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 - group by xID order by xID1; +-+--+---+ | xID | xID1 | Level | +-+--+---+ | 1 | NULL | * | // !!! | 3 | NULL | *** | // !!! | 2 |2 | **| | 4 | 185 | | +-+--+---+ 4 rows in set (0.00 sec) mysql # small changes in REQ for solve problem. mysql # w/o repeat('*',) mysql select S.ID as xID, S.ID1 as xID1, count(distinct yS.ID) as Level - from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 - group by xID order by xID1; +-+--+---+ | xID | xID1 | Level | +-+--+---+ | 1 |1 | 1 | | 2 |2 | 2 | | 3 | 134 | 3 | | 4 | 185 | 4 | +-+--+---+ 4 rows in set (0.00 sec) mysql mysql # w/o distinct mysql select S.ID as xID, S.ID1 as xID1, repeat('*',count(yS.ID)) as Level - from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 - group by xID order by xID1; +-+--+---+ | xID | xID1 | Level | +-+--+---+ | 1 |1 | * | | 2 |2 | **| | 3 | 134 | *** | | 4 | 185 | | +-+--+---+ 4 rows in set (0.00 sec) mysql # w/o order by mysql select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level - from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 - group by xID; +-+--+---+ | xID | xID1 | Level | +-+--+---+ | 1 |1 | * | | 2 |2 | **| | 3 | 134 | *** | | 4 | 185 | | +-+--+---+ 4 rows in set (0.00 sec) mysql mysql # w/o alias in order by mysql select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level - from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 - group by xID order by S.ID1; +-+--+---+ | xID | xID1 | Level | +-+--+---+ | 1 |1 | * | | 2 |2 | **| | 3 | 134 | *** | | 4 | 185 | | +-+--+---+ 4 rows in set (0.00 sec) mysql mysql drop table S; Query OK, 0 rows affected (0.00 sec) = repeat w/o reply = CREATE TABLE S (ID1 int, ID2 int, ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID)); insert into S values (1,244,NULL),(2,243,NULL),(134,223,NULL),(185,186,NULL); # my request (strange NULL in reply) select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 group by xID order by xID1; # small changes in REQ for solve problem. # w/o repeat('*',) select S.ID as xID, S.ID1 as xID1, count(distinct yS.ID) as Level from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 group by xID order by xID1; # w/o distinct select S.ID as xID, S.ID1 as xID1, repeat('*',count(yS.ID)) as Level from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 group by xID order by xID1; # w/o order by select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 group by xID; # w/o alias in order by select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 group by xID order by S.ID1; drop table S; Fix: Small changes in reqest :-( Submitter-Id: submitter ID Originator:Andrew Shirrayev Organization: MySQL support: none Synopsis: count(distinct)OrderBy... generate strange NULL Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.49 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.49, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.49-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 1 day 15 hours 35 min 15 sec Threads: 1 Questions: 61 Slow queries: 0 Opens: 24 Flush tables: 1 Open tables: 6 Queries per second avg: Environment: System: Linux temphost 2.4.18 #1 SMP Fri Apr 12 00:24:28 MSD
mysql to dbf
Hello. Is there a tool that i can use to convert mysql tables (structure) to dbf tables? Most of the tools i encounter converts dbf to mysql. I want to do it the other way around. tia Get your own 800 number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Delphi MySQL Access Components
Daniel, Wednesday, July 24, 2002, 11:23:05 AM, you wrote: DK Can someone tell me what is the best MySQL native component set for Delphi? DK It does not matter if it is commercial, but I need one urgently. I'm not a professional with Delphi+MySQL, but Zeos Library looks fine for me: http://www.mysql.com/downloads/contrib.html You can also find some other Delphi interfaces for libmysql.dll there. I have tried all and decided to use Zeos... -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Network access?
Steve, Monday, July 22, 2002, 3:39:52 AM, you wrote: SD I am a MySQL newbie and can not seem to find the documentation that SD explains how to allow network or remote access to a running MySQL SD server. It does not seem to be in the my.cnf file or in the manual??? SD I am sure this is a simple thing but it is really holding me up right SD now. Thanks for any help. First of all, you should allow to connect from remote host. Look at the GRANT syntax: http://www.mysql.com/doc/G/R/GRANT.html http://www.mysql.com/doc/P/r/Privileges.html When you connect to the remote MySQL server you should specify host name, i.e.: mysql -hsome.host.name -uuser_name -p -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: fix auto increment column
Yamin, Monday, July 22, 2002, 11:15:30 AM, you wrote: YP I had a auto increment column YP let say the auto increment would look like this YP 100,1001,1003,1101,1103,10005,10006 YP yes I had delete several column in tha past YP now I would like to sort it again so it would be an order from 100 to 1006 YP is it possible for mysql to do that with out drop the column first ?? In general you can, f.e: SET INSERT_ID=100; ALTER TABLE table_name ADD COLUMN id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY FIRST; but I think it's a not an efficient way ... Why do you want to change the numbering of the column? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query as source for query
Publici-Textes, Tuesday, July 23, 2002, 10:40:40 PM, you wrote: PT In MSAccess, I am able to use a query as a (partial) source for another query. PT LSelect Names, Department from qrySelectedEmployees, tblDepartment PT where qrySelectedEmployees.EmplId = tblDepartment.EmplId PT Is this possible with MySQL? If so, how is it implemented? No, MySQL doesn't currently support sub-selects: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Sorting order in MySQL
Daniel, Monday, July 22, 2002, 11:47:17 AM, you wrote: DK Nikolaos and Victoria, DK Victoria! Just like Nikolaos, I also don't know what you mean send new DK character sets as seen with the explanations. DK The first thing I have to mention that I'm not sure how MySQL string DK comparison works, but I think it just compares the characters at the same DK position (by the actual char set). Am I right? DK Because if I am, the problem is not the actual character sets distributed DK with MySQL. The problem is the METHOD of string comparison. (In case of DK Hungarian and in case of Greek also, I think. And maybe in case of other DK languages.). DK So, I think we should discuss it in details, but first of all I need some DK detailed manual about string comparison in MySQL. Where can I find it? Well.. Look at the charsets dir, you can find *.conf files that contains 4 arrays which describe character types, lower-case and upper-case equivalencies and sorting orders. Correctness of the result of sorting and comparison depends on this map (sort_order[] array). So, if you consider that result is wrong, you can create a new character set (ex. mycharset.conf) that would provide right way for you sorting and comparison. You can find some notes about it at: http://www.mysql.com/doc/C/h/Character_arrays.html http://www.mysql.com/doc/S/t/String_collating.html http://www.mysql.com/doc/A/d/Adding_character_set.html and also some info in the 'sql/share/charsets/README' file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: mysqlimport usage
James, Tuesday, July 23, 2002, 8:32:10 PM, you wrote: JC There didn't seem to be any responses to this question last time I posted. JC So I'll try again. Does anyone know where to locate mysqlimport logs, if JC there are any? No, mysqlimport doesn't write logs and you can't see warnings. mysqlimport just send LOAD DATD INFILE command: http://www.mysql.com/doc/L/O/LOAD_DATA.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: mysqldump question
Bill, Tuesday, July 23, 2002, 11:04:27 PM, you wrote: BB Also, do you happen to know how old is 3.23.21-beta-log? Our MYSQL is BB old, but I can't find out how old, is there a version history online BB anywhere? Check MySQL manual: http://www.mysql.com/doc/index.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump and DBs with FKs
Sergio, Wednesday, July 24, 2002, 6:15:57 AM, you wrote: SB Im getting in trouble trying to restore a .sql dump generated with SB mysqldump for a database with lots of foreign keys because of the SB order of tables in the .sql. the first table already declares a SB FOREIGN KEY referencing a table not yet created, halting with a SB 'cant create blahblahblah'. SB (ERROR 1005 at line 11: Can't create table './sdb_teste/alertas.frm' (errno: 150)) SB Any solutions to this problem? According InnoDB manual using SET NO_FOREIGN_KEY_CHECKS=1, it will come in 3.23.52: http://www.innodb.com/ibman.html#InnoDB_history -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Very minor buglet
We are discussing the 'mysql' client which is often used to write scripts that run under the UNIX shell. ... If you write a script that has two semi-colons in a row, the second one is ignored and no error message is given. Err, not true (in amysql script anyway) I think you are trying to compare the ';' at the end of an SQL statement with putting a blank line in a comman interpretter, because you are assuming that the ; is intended to separate commans as it would in the shell. i.e. echo hello echo world is the same as echo hello; echo world;o and thus ;; works because the shell does not pproduce an error message for a blank line when you hit return. but this is not the function of the ; in mySQL- its part of the SQL syntax and thus a ';' will always produce an error as its not valid to have a ';'on a line by itself. You might disagree with the behaviour, but if so then the properplace to complain is to the ANSI SQL people, not mySQL. ORACLE also generates an error for ;; - it takes the 2nd semicolon as the statement terminator and complains about the first one ebing not a valid part of the query. -pcf. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
about set page size and set line size
hi all, is there any command in mysql prompt for set page size and set line size like SQL*Plus? TIA ivan paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Delphi MySQL Access Components
Hi, Yes, I'm using it actually, but I ask te author if MySQL features will be extended to stored procedures, when will he come out with the new version. He told me that he finished the development of the component set and gave it to sourcesorge.net to continue it. Anyway, the newest version of it is still in beta state. And it never will be finished. So, any other ideas? Thanks, Daniel At 17:22 2002.07.24. +0800, you wrote: Use WinZeos component for delphi 6 Search it on GOOGLE It helps me too R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No.(Office) (088) 858-1028 (Home) (088) 858-8889 Mobile No. (63) (919-3085267) -Original Message- From: Daniel Kiss [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 4:23 PM To: [EMAIL PROTECTED] Subject:Delphi MySQL Access Components Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Joining question
Use: tabProds LEFT JOIN tabUsers ON tabProds.usr_ID = tabUsers.usr_ID from the manual: If there is no matching record for the right table in the |ON| or |USING| part in a |LEFT JOIN|, a row with all columns set to |NULL| is used for the right table. Jorge Garza wrote: Hi I'm designing 2 tables, where tabProds has the foreign key of tabUsers. So when I want to join them I use.. WHERE tabProds.usr_ID = tabUsers.usr_ID Ok But the thing is that sometimes will not be possible to specify a user when you insert a Product(becaouse we don't know at that time)... And I'm anticipating the query mentioned above would not display the products that doesn't match any user's ID, AND I want those records to be showed too. Would be like this...? WHERE (tabProds.usr_ID = tabUsers.usr_ID) or (tabProd.usr_ID= Null) But, with this query, what is going to show on the User's columns when it gets a Null field..? ProdID UserID UserName 232John 34Null? --- What's going to happen here..? 454Pedro Or is there anohter options..? like Left joins.. and all that, (I haven't analize them yet) I know you may think... Well do the test and see it, well yes, is just that affects the way I'm thinking to design the web system, and I would like to know when I'm on the DB design and before the programming Thank you jgarza - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Important: Got error 127 from table handler (1030)?
Pada Wed, 24 Jul 2002 11:01:24 +0200 Daniel Brockhaus [EMAIL PROTECTED] menulis : Hi, well, the subject says it all. I'm using version 3.23.41-log, and I got the following error message when trying to update a row: Got error 127 from table handler (1030) It's a normal query which has succeeded several thousand times already. table got corrupt ... you have to repair the table ... ;) -- /* Host controller interrupts must not be running while calling this * function or the penguins will get angry. */ 2.2.16 /usr/src/linux/drivers/usb/ohci.c MySQL 3.23.51 : up 33 days, Queries : 354.803 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone : +62 21 79199577 - Web : http://1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Important: Got error 127 from table handler (1030)?
By coincidence, we had this yesterday for the first time in our experience. It is a corrupt table, and we fixed is with isamchk. We are running an older version, you might have to use myisamchk. _justin = Daniel Brockhaus wrote: Hi, well, the subject says it all. I'm using version 3.23.41-log, and I got the following error message when trying to update a row: Got error 127 from table handler (1030) It's a normal query which has succeeded several thousand times already. Any ideas what might be wrong? Thanks, Daniel Brockhaus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[2]: Bug or feature fulltext search?
Hi, I've encountered a similar bug on my own table. If you want, I can upload a tar.gz of my table (5 MB), with the associated query needed to reproduce the problem ? Regards, Jocelyn - Original Message - From: Artem V. Ryabov [EMAIL PROTECTED] To: Sergei Golubchik [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 10:43 AM Subject: Re[2]: Bug or feature fulltext search? Hello Sergei, Tuesday, July 23, 2002, 10:17:06 PM, you wrote: SG Hi! SG On Jul 23, Artem V. Ryabov wrote: Hello mysql, see this 2 queries: why they not equal? why first skip many records? mysql select left(ftText,20) from Txt_index where match(ftText) against('+(wùd200206*) +wù12p' in boolean mode); 3 rows in set (0.36 sec) mysql select left(ftText,20) from Txt_index where match(ftText) against('+wùd200206* +wù12p' in boolean mode); 42 rows in set (8.00 sec) mysql show variables like 'version'; +---+-+ | Variable_name | Value | +---+-+ | version | 4.0.2-alpha-log | +---+-+ 1 row in set (0.00 sec) SG Obviously, it's a bug. yes. next query prove it: mysql select left(ftText,17),match(ftText) against('+(wùd200206*) +wù12p' in boolean mode) as m from Txt_index where match(ftText) against('+wùd200206* +wù12p' in boolean mode); +---+--+ | left(ftText,17) | m| +---+--+ | wùd20020601 wù12p |1 | | wùd20020601 wùnw |1 | | wùd20020604 wù12p |1 | | wùd20020604 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020609 wù12p |1 | | wùd20020611 wù12p |1 | | wùd20020611 wù12p |1 | | wùd20020611 wù12p |1 | | wùd20020611 wù12p |1 | | wùd20020611 wù12p |1 | | wùd20020614 wù12p |1 | | wùd20020614 wù12p |1 | | wùd20020619 wù12p |1 | | wùd20020619 wù12p |1 | | wùd20020619 wù12p |1 | | wùd20020619 wù12p |1 | | wùd20020619 wù12p |1 | | wùd20020625 wù12p |1 | | wùd20020625 wù12p |1 | | wùd20020625 wù12p |1 | | wùd20020625 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | | wùd20020627 wù12p |1 | +---+--+ 42 rows in set (3.46 sec) mysql SG Could you provide a test case ? but how? Table very big: mysql SHOW TABLE STATUS like 'Txt_index'; +---+++---++-+-- ---+--+---++ -+-+-++- --+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +---+++---++-+-- ---+--+---++ -+-+-++- --+ | Txt_index | MyISAM | Dynamic| 42744 | 6032 | 257856408 | 4294967295 |166645760 | 0 | 58071 | 2002-07-11 15:22:31 | 2002-07-11 15:30:56 | 2002-07-11 15:42:25 || Ïîëíîòåêñòîâûé èíäåêñ | +---+++---++-+-- ---+--+---++ -+-+-++- --+ 1 row in set (0.03 sec) mysql show create table Txt_index; +---+--- -+ | Table | Create Table | +---+--- -+ | Txt_index | CREATE TABLE `Txt_index` ( `ID` int(11) NOT NULL auto_increment, `ftText` mediumtext NOT NULL, PRIMARY KEY (`ID`), FULLTEXT KEY `ftText` (`ftText`)) TYPE=MyISAM COMMENT='Ïîëíîòåêñòîâûé èíäåêñ' |
RE: mysqldump question
On Tue, 2002-07-23 at 21:04, Bill Bernat wrote: Hey, thanks *so* much for checking into this. Your message did help. In case you're curious. First, I had the admin create a 777 dump directory from root. Still couldn't write out. Then, though, I just tried going to /tmp as you had done, and that was fine. /tmp -- I feel like an idiot, but at least I'm an idiot who can dump the database now:) Also, do you happen to know how old is 3.23.21-beta-log? Our MYSQL is old, but I can't find out how old, is there a version history online anywhere? Check this: http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.23.x It shows some release dates. -Original Message- From: Diana Soares [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 3:22 AM To: Bill Bernat Cc: [EMAIL PROTECTED] Subject: Re: mysqldump question On Tue, 2002-07-16 at 02:31, Bill Bernat wrote: Question: is there anything I need to be aware of when writing dump files to a local directory for my user, I'm having the following problem. 1. I create a directory in my own home directory (linux, red hat 7.2) ~/dumps and give it 777 permissions 2. I run /usr/local/mysql/bin/mysqldump -uroot -ppass --tab ~/dumps dbname table1 table2 3. The .sql file for table1 gets created, correctly, in the dumps directory fine. 4. mysqldump pukes when trying to write the .txt file: /usr/local/mysql/bin/mysqldump: Got error: 1: Can't create/write to file '/home/bbernat/dumps/customer_relations_database.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' QUESTION: What have I done wrong and how can I fix it? Hi, I was curious about your problem and decided to try it. As user root (in the filesystem, redhat7.2), i created the dir ~/dumps with 777 permissions and have run root@cartman:~# mysqldump -uroot -p --tab ~/dumps/ test (root mysqluser has FILE permissions). It gave me the same error. Then i tried with a common filesystem user (dsoares): dsoares@cartman:~$ mysqldump -uroot -p --tab ~/dumps/ test And it worked! I went to see my /root permissions and it was: dsoares@cartman:~$ ll -d /root/ drwxr-x--- 31 root root 4096 Jul 16 11:09 /root/ So the problem was there! mysql user doesn't have permissions to access /root directory. Maybe this is your problem. (also as root i tried with /tmp/dumps directory, 777 permissions, and it worked.) -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
offtopic - Information Tech in Brazil
Hi Guys Sorry this is quite off topic. Any idea hows IT doing in Brazil... -Arul sql , query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange NULL.
Description: Strange NULL in reply. How-To-Repeat: mysql CREATE TABLE S (ID1 int, ID2 int, ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID)); Query OK, 0 rows affected (0.00 sec) mysql insert into S values (1,244,NULL),(2,243,NULL),(134,223,NULL),(185,186,NULL); Query OK, 4 rows affected (0.00 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql mysql # my request (strange NULL in reply) mysql select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level - from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 - group by xID order by xID1; +-+--+---+ | xID | xID1 | Level | +-+--+---+ | 1 | NULL | * | // !!! | 3 | NULL | *** | // !!! | 2 |2 | **| | 4 | 185 | | +-+--+---+ 4 rows in set (0.00 sec) mysql # small changes in REQ for solve problem. mysql # w/o repeat('*',) mysql select S.ID as xID, S.ID1 as xID1, count(distinct yS.ID) as Level - from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 - group by xID order by xID1; +-+--+---+ | xID | xID1 | Level | +-+--+---+ | 1 |1 | 1 | | 2 |2 | 2 | | 3 | 134 | 3 | | 4 | 185 | 4 | +-+--+---+ 4 rows in set (0.00 sec) mysql mysql # w/o distinct mysql select S.ID as xID, S.ID1 as xID1, repeat('*',count(yS.ID)) as Level - from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 - group by xID order by xID1; +-+--+---+ | xID | xID1 | Level | +-+--+---+ | 1 |1 | * | | 2 |2 | **| | 3 | 134 | *** | | 4 | 185 | | +-+--+---+ 4 rows in set (0.00 sec) mysql # w/o order by mysql select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level - from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 - group by xID; +-+--+---+ | xID | xID1 | Level | +-+--+---+ | 1 |1 | * | | 2 |2 | **| | 3 | 134 | *** | | 4 | 185 | | +-+--+---+ 4 rows in set (0.00 sec) mysql mysql # w/o alias in order by mysql select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level - from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 - group by xID order by S.ID1; +-+--+---+ | xID | xID1 | Level | +-+--+---+ | 1 |1 | * | | 2 |2 | **| | 3 | 134 | *** | | 4 | 185 | | +-+--+---+ 4 rows in set (0.00 sec) mysql mysql drop table S; Query OK, 0 rows affected (0.00 sec) = repeat w/o reply = CREATE TABLE S (ID1 int, ID2 int, ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID)); insert into S values (1,244,NULL),(2,243,NULL),(134,223,NULL),(185,186,NULL); # my request (strange NULL in reply) select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 group by xID order by xID1; # small changes in REQ for solve problem. # w/o repeat('*',) select S.ID as xID, S.ID1 as xID1, count(distinct yS.ID) as Level from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 group by xID order by xID1; # w/o distinct select S.ID as xID, S.ID1 as xID1, repeat('*',count(yS.ID)) as Level from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 group by xID order by xID1; # w/o order by select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 group by xID; # w/o alias in order by select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level from S left join S as yS on S.ID1 between yS.ID1 and yS.ID2 group by xID order by S.ID1; drop table S; Fix: Small changes in reqest :-( Submitter-Id: submitter ID Originator:Andrew Shirrayev Organization: MySQL support: none Synopsis: count(distinct)OrderBy... generate strange NULL Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.49 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.49, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.49-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 1 day 15 hours 35 min 15 sec Threads: 1 Questions: 61 Slow queries: 0 Opens: 24 Flush tables: 1 Open tables: 6 Queries per second avg: Environment: System: Linux temphost 2.4.18 #1 SMP Fri Apr 12 00:24:28 MSD
Embedded server problems
Hello, I've been using MySQL for over 2 years in my Bacula GPL project (network backup program). To simplify installation for users, I would like to offer them the possibility of using the embedded MySQL server. However, I'm having a few problems, and maybe you can help me: 1. There seems to be no way to build a mysql with the embedded server. If there is please tell me how. This is important because mysql is used to create the databases. 2. The embedded server apparently doesn't support the default table type, which I imagine is MYISAM or ISAM. From the documentation, it seems it only supports InnoDB database. However, I'm using BLOBs and TINYBLOBs, and InnoDB doesn't accept these. Is there a way that I can make the embedded server support the standard tables, or is there someone who could answer a few questions to help me convert to the appropriate InnoDB types? 3. How can I get some help making sure my tables are optimal? I'm willing to pay the $250 (it comes out of my personal pocket) for the basic service contract, but I'm not sure it will cover this kind of help. Thank you. Kern Sibbald PS: please reply directly to my email address as I am only subscribed to the announce list. PPS: I build MySQL from source on RedHat Linux and Solaris systems. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Storing and recovering changes to tables
[EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Benjamin Pflugmann wrote: I do not think that there is an really elegant solution. Greetings, Benjamin. Many thanks Benjamin, this is a helpful addition to my own thoughts. I'm pleased that I can rule out using the logs. I also had the idea for a mirror/archive of each table, so I was pleased to see it in your suggestion. I think that with this solution, the process of making the copy does not interfere too much with the process of updating the master. And, it is a bit more self-documenting than the other methods, even if it uses more space. I'm only likely to have a few thousand records (though each may contain a lot of text) which will change infrequently. I can leave it to the module that retrieves old versions to work out exactly what changed and when. Thanks again Richard / \ Richard M Davis / Digital Archives \ University of London Computer Centre / Tel: +44 (0) 20 7692 1350 \ mailto: [EMAIL PROTECTED] / -- / \ Richard M Davis / Digital Archives \ University of London Computer Centre / Tel: +44 (0) 20 7692 1350 \ mailto: [EMAIL PROTECTED] / - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL - Ecommerce problem
I just moved my servers and have new DNS names and IP addresses. I need to update my MySQL databases because our Ecommerce sites are giving Internal Server Errors in Apache, see this link: http://www.toyotaworld.com/cart/toyotaecommerce.cgi?store=toyotaecommerceac tion=filefile=home.tmpl I used PhpAdmin to make some changes in the Shopping Cart main database (from cs1.cityscope.net to ns1.cityscope.net), but I am still getting the errors. Can anyone tell me where I need to change the server info and what are the commands to do it? I appreciate your help, thanks. Ingrid Kast Fuller CityScope Net 3910 Fairmont Parkway #264 Pasadena, TX 77504-3066 (713) 477-6161 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Concat() Syntax..
Hi all, I have a table with a field full of urls.. what I need to do is to append to those urls with a new url, so for example, if the field had http://www.yahoo.com i want to make it http://www.myserver.com/login?url=http://www.yahoo.com .. I have tried the following which I thought should work:- update table set field = concat(http://www.myserver.com/login?url=;, field) where restriction=D and location=local; It goes all fine, however when I do a search I have records that now show the url as http://www.myserver.com/login?url=http: and it chops off the rest.. I have checked the size of the field itself and it was a varchar(255).. I thought maybe it was the restriction, which it was for about 51 of them cause they showed up as warnings when I ran the update command, so I changed the varchar to a blob to see the difference and no longer are there any warnings, but it still chops off everything after http: Any ideas? sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: rounding?!
Thanks, that was simple enough...guess I just couldnt think of that. Thanks again! -Nick Gordon said: Try round(value*4,0)/4 Worked on the samples I tried -Original Message- From: Nicholas Stuart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 1:47 PM To: [EMAIL PROTECTED] Subject: rounding?! Ok here's the problem. Trying to write a select statement to be able to round a set of numbers to the nearest quarter of an inch. Here is what I have so far: *--- -- * SELECT CONCAT(ROUND(inside_length + (wall_thickness * 2), 0),'\'-', mod(((inside_length + (wall_thickness * 2)) * 12), 12),'\ x ', ROUND(inside_width + (wall_thickness * 2), 0),'\'-', mod(((inside_width + (wall_thickness * 2)) * 12), 12),'\' ) AS footprint, CONCAT(ROUND(inlet_invert - inlet_sump - base_slab_thck, 2), '\'') as outside_Bottom_Elevation, CONCAT(inlet_invert, '\'') as inlet_invert, CONCAT(outlet_invert, '\'') AS outlet_invert, CONCAT(TopofTank, '\'') AS TopOfTank, CONCAT(Rim, '\'') as Rim, CONCAT(ROUND(((inlet_Sump + base_slab_thck) - (((inlet_ko_dia - inlet_dia) / 2) / 12)) * 12, 1), '\') AS inlet_ko_outside, CONCAT(ROUND(((outlet_Sump + base_slab_thck) - (((outlet_ko_dia - outlet_dia) / 2) / 12)) * 12, 1), '\') AS outlet_ko_outside, CONCAT(ROUND((inlet_Sump + base_slab_thck) * 12, 1), '\') as inlet_invert_outside, CONCAT(ROUND((outlet_Sump + base_slab_thck) * 12, 1), '\') as outlet_invert_outside, CONCAT(ROUND(inlet_Sump * 12, 1), '\ ') AS inlet_Sump, CONCAT(ROUND(outlet_Sump * 12, 1), '\') AS outlet_Sump, CONCAT(ROUND(inlet_Sump * 12 + (inlet_dia / 2), 1), '\') AS inlet_cl_floor, CONCAT(ROUND(outlet_Sump * 12 + (outlet_dia / 2), 1), '\') AS outlet_cl_floor, CONCAT(inlet_dia, '\') AS inlet_dia, CONCAT(outlet_dia, '\') AS outlet_dia, CONCAT(inlet_ko_dia, '\') AS inlet_ko_dim, CONCAT(outlet_ko_dia, '\') AS outlet_ko_dim, CONCAT(ROUND((inlet_ko_dia - inlet_dia) / 2, 1), '\') AS inlet_invert_ko_invert, CONCAT(ROUND((outlet_ko_dia - outlet_dia) / 2, 1), '\') AS outlet_invert_ko_invert, CONCAT(inlet_offset, '\') AS inlet_offset, CONCAT(outlet_offset, '\') AS outlet_offset FROM tbl_prj_dims *--- -- * This will get all of the values I need in decimal inches but I would like to be able to round them up or down to the nearest quarter of an inch, so the only decimal values will be .0 or .25 or .5 or .75 I'm not really sure if there is efficent way to do it and would like all of your inputs. And dont mind the first few values in feet. Those need to be like that. Thanks a lot! -Nick Stuart Filter Fodder: MySQL QUERY - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Network access?
Network access or remote access is handled by the OS such as Linux. All you need to do is make sure you have a user setup that is allowed to access the database from those locations. Example: shell mysql --user=root mysql mysql GRANT ALL PRIVILEGES ON *.* TO monty@localhost - IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql GRANT ALL PRIVILEGES ON *.* TO monty@% - IDENTIFIED BY 'some_pass' WITH GRANT OPTION; With this example you just created a super users that can access mysql from the server where it resides or from anywhere else. Unless you want this try to be more specific with super users access points like maybe you just want it for the internal network like this: [EMAIL PROTECTED]% For more information on this look at adding new users under the documentations section. Once you have this setup then you can access the database using the mysql client tool or ODBC or any other types of connections that have been developed for mysql (See download section for developed connection drivers). Matthew Scarrow ComIT Solutions Inc. www.comit.ca Phone: 519-442-0100 Fax: 519-442-0429 -Original Message- From: Steve Dickey [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 21, 2002 8:40 PM To: [EMAIL PROTECTED] Subject: Network access? I am a MySQL newbie and can not seem to find the documentation that explains how to allow network or remote access to a running MySQL server. It does not seem to be in the my.cnf file or in the manual??? I am sure this is a simple thing but it is really holding me up right now. Thanks for any help. scd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySql 3.23 to version 4 upgrade
Well I have FreeBSD 4.2 and MySQL 3.23.33 running on localhost. I use PhpMyAdmin to do any modifications. I did make the nameserver changes in: Database ShoppingCart - table stores Database mysql - table db Database mysql - table host Database mysql - table user I reset mysql and apache and still get Internal Server errors and here's whats in the logs: DBI-connect(toyotaecommerce:ns1.cityscope.net) failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) at /usr/local/www/data/cart/toyotaecommerce.cgi line 33 [Wed Jul 24 07:44:37 2002] [error] Can't call method prepare on an undefined value at /usr/local/lib/perl5/site_perl/5.005/CityScope/ShoppingCart.pm line 267. this is line 33... my $dbh = DBI-connect(DBI:mysql:$toyotaecommerce{dbname}:$toyotaecommerce{dbhostname }, $toyotaecommerce{dbuser}, $toyotaecomm this is line 267 sub getIDdb { my ($self, $dbh, $id, $store) = @_; my ($check, $sth, @cart); $check = 'select * from carts where(id = ' . $id . ');'; $sth = $dbh-prepare($check) or $self-Error('Could not prepare select statement in sub getIDdb(); ' . $dbh-errstr); Ingrid Kast Fuller CityScope Net 3910 Fairmont Parkway #264 Pasadena, TX 77504-3066 (713) 477-6161 -Original Message- From: chuck amadi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 7:14 AM To: Ingrid Kast Fuller Subject: Re: MySql 3.23 to version 4 upgrade Ingrid Kast Fuller wrote: Hey Chuck, since you're up at this time, could I ask you for some MySQL help? I changed my name server names and IP addresses and having trouble getting them put in the database and my ecommerce sites are currently down. I have phpAdmin and went into one file and changed all the cs1.cityscope.net to ns1.cityscope.net but that didn't help. Where else would I change the info so the database will work. I keep getting Internal Server Error's? Your help is appreciated. Ingrid Kast Fuller CityScope Net 3910 Fairmont Parkway #264 Pasadena, TX 77504-3066 (713) 477-6161 -Original Message- From: chuck amadi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 3:33 AM To: mysql Subject: MySql 3.23 to version 4 upgrade Hi all , i'm about to upgrade from MySql 3.23 to version 4 are there any issues that should be addressed ie uninstall v3 prior to installing v4 or can i just install over v3. Any suggested sites' ,FAQ regarding my question. -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Hi There Plz could explain what O/s and Server as I'm currently running Apache v1 with PhpMyAdmin (maintenace purposes only) running on my Win Box 98 for testing development etc. Work stuff is linux based environment System Administrator sorts that stuff out. Thus i edited C:\Program Files \ Apache Group\Apache\Conf\httpd.conf and look for # ServerName new.host.name and add your ipAddress thus if your'e running virutally hosts go to the bottom - #NameVirtualHost VirtualHost ServerName DocumentRoot ServerName Also check your'e WebAppConnection Conn Warp yourHost:8008 (your port) Best thing to do is C P to list altering of cause your ipAddress details. I hope this helps or someone with more exp continue's the thread. -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Search SQL optimization
Let us say I have two tables tab1 and tab2. tab1: col1 col2 tab2: col3 col4 For my search, a user can enter space delimited words to search, e.g., microsoft windows xp i have to search for EACH of these words, and join the 2 tables too, so my sql query looks somewhat like this: select * from tab1, tab2 where tab1.col1 = tab2.col3 and ( tab1.col1 = microsoft or tab1.col2 = microsoft or tab1.col1 = windows or tab1.col2 = windows or tab1.col1 = xp or tab1.col2 = xp ) ; now my question is how can i optimize this query? apart from the sql, can i set some indices which will help me make this faster? thanks/erick __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BUG report (select distinct...) 4.0.2 and latest bk snapshot
Sergey S. Kostyliov writes: At first I want to thank you for a fast answer, On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote: On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote: Description: ERROR 2013: Lost connection to MySQL server during query. snip Note: The same results with oficial mysql-4.0.2 and latest bk snapshot, mysql was compiled with both gcc-3.1 and gcc-295.3 Unfortunately we can't test this bug report as we do not have tables to run this query with. Please check tables you have at first to eliminate corrupted table is the source of the problem and if problem persist upload them into secret directory at ftp://support.mysql.com Sorry, but it doesn't looks like a table corruption. To be sure i've tested this with fresh tables created from a sql script. I can also add that this is easily reproducable on two of my boxes (UP SMP) If you are able to create small repeatable case you may send it in the mail. Unfortunately it's a kind of big test case (1.2Mb) I had uploaded a test case with name select_distinct-ssk.tar.gz to ftp://support.mysql.com/pub/mysql/secret -- Best regards, Sergey S. Kostyliov [EMAIL PROTECTED] Public PGP key: http://sysadminday.org.ru/rathamahata.asc If the table names are : product_supplier route supplier shop_product_supplier then I have got them. I will test your case today. Is it one bug or two ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB: Lock wait timeout exceeded from all programs after errorand backout
Hi! Do anybody can help me? Every time a program has an error and did his backout, all other programs get an Lock wait timeout if they do an update. Allways I have to restart the database to get back the access for the programs. The programm with the error did his backout completely! We use the system for the daily business for ordering, billing and managing the stock. Environment: Redhat Linux 7.2 Apache 1.3.19 Php 4.2.1 MySQL with InnoDB 3.23.49 70 Tables (760 MB) We have 3 Tables in the Database which are MyISAM, but they ar never in a Transaction. We use the Transaction in the way: set AUTOCOMMIT=0: BEGIN; update .; ... ... COMMIT; set AUTOCOMMIT=1; or ROLLBACK; set AUTOCOMMIT=1; If someone has an idea what happens here, please answer! Greetings Charley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Very minor buglet
Pete French wrote: We are discussing the 'mysql' client which is often used to write scripts that run under the UNIX shell. ... If you write a script that has two semi-colons in a row, the second one is ignored and no error message is given. Err, not true (in amysql script anyway) echo select 10;; select 20; | mysql produces: 10 10 20 20 with no errors. at least with 3.23.38 I think you are trying to compare the ';' at the end of an SQL statement with putting a blank line in a comman interpretter, because you are assuming that the ; is intended to separate commans as it would in the shell. i.e. echo hello echo world is the same as echo hello; echo world;o and thus ;; works because the shell does not pproduce an error message for a blank line when you hit return. but this is not the function of the ; in mySQL- its part of the SQL syntax and thus a ';' will always produce an error as its not valid to have a ';'on a line by itself. You might disagree with the behaviour, but if so then the properplace to complain is to the ANSI SQL people, not mySQL. ORACLE also generates an error for ;; - it takes the 2nd semicolon as the statement terminator and complains about the first one ebing not a valid part of the query. -pcf. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BUG report (select distinct...) 4.0.2 and latest bk snapshot
On Wednesday 24 July 2002 17:23, Sinisa Milivojevic wrote: Sergey S. Kostyliov writes: At first I want to thank you for a fast answer, On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote: On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote: Description: ERROR 2013: Lost connection to MySQL server during query. cut I had uploaded a test case with name select_distinct-ssk.tar.gz to ftp://support.mysql.com/pub/mysql/secret cut If the table names are : product_supplier route supplier shop_product_supplier Yes they are. 4 tables, names are right. then I have got them. I will test your case today. Is it one bug or two ?? It'is a one bug AFAIK. -- Best regards, Sergey S. Kostyliov [EMAIL PROTECTED] Public PGP key: http://sysadminday.org.ru/rathamahata.asc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: libmysqlclient.so.10
In the last episode (Jul 23), Steve Dickey said: Can anyone tell me how to get an RPM that provides the libmysqlclient.so.10? I am trying to install the php-mysql-4.1.2-7.i386.rpm and it says that this is a requirement. It comes in an older version of the mysql database rpm but I have 3.23.51 installed and apparently that one does not come with this library??? I am having trouble getting PHP to work with mysql. www.rpmfind.net -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installing on Win (XP): InstallShield errors in _ins5176._mp
I'm having problems installing MySQL Server 3.23.51. When trying, I'm using all standard options during installation. Quite late in the installation -- it seems like after all files have been unpacked and copied to their proper locations -- I get an error message titled InstallShield Engine. Details: AppName: _ins5176._mp AppVer: 5.10.130.0 ModName: unknown ModVer: 0.0.0.0 Offset: Further details from Windows is located below this message. It is also impossible to uninstall using Add and remove programs, it errs with message The log file 'C:\mysql\Uninst.isu' is not valid or the data has been corrupted. Uninstallation will not continue., so I have to uninstall it manually (using Explorer and RegEdit). I've been doing extensive searching on the Internet (for _ins5176._mp) to find the solution to this. Similar problems have occurred for other users trying to install other programs and these people have been asked to: * upgrade the InstallShield application (impossible for me; I'm not packaging MySQL...) * delete all temp-files, try again * disable the antivirus software, try again I've tried all this; even tried to install MySQL in Safe mode with an absolute minimum of processes running. Same result. I'm using an English version of Microsoft Windows XP [Version 5.1.2600] with all available updates. It's a Dell laptop with 1,2GHz PIII and 512 MB. The install file I'm using is not corrupt. Help much appreciated. Thanks, Fredrik Dettner [EMAIL PROTECTED] - XP's detailed error message: EXE NAME=_INS5176._MP FILTER=GRABMI_FILTER_PRIVACY MATCHING_FILE NAME=ZDATAI51.DLL SIZE=53760 CHECKSUM=0x1AB9B617 BIN_FILE_VERSION=5.10.130.0 BIN_PRODUCT_VERSION=5.10.130.0 PRODUCT_VERSION=5, 10, 130, 0 FILE_DESCRIPTION=ZDATAI51.DLL COMPANY_NAME=InstallShield Corp. PRODUCT_NAME=InstallShield FILE_VERSION=5, 10, 130, 0 ORIGINAL_FILENAME=ZDATAI51.DLL INTERNAL_NAME=ZDATA LEGAL_COPYRIGHT=Copyright © 1997 VERFILEDATEHI=0x0 VERFILEDATELO=0x0 VERFILEOS=0x40004 VERFILETYPE=0x2 MODULE_TYPE=WIN32 PE_CHECKSUM=0x0 LINKER_VERSION=0x0 UPTO_BIN_FILE_VERSION=5.10.130.0 UPTO_BIN_PRODUCT_VERSION=5.10.130.0 LINK_DATE=10/09/1997 20:45:22 UPTO_LINK_DATE=10/09/1997 20:45:22 VER_LANGUAGE=English (United States) [0x409] / MATCHING_FILE NAME=_INS5176._MP SIZE=594944 CHECKSUM=0xA218076 BIN_FILE_VERSION=5.10.130.0 BIN_PRODUCT_VERSION=5.10.130.0 PRODUCT_VERSION=5.10.130.0 FILE_DESCRIPTION=InstallShield Engine COMPANY_NAME=InstallShield Software Corporation PRODUCT_NAME=InstallShield® FILE_VERSION=5.10.130.0 LEGAL_COPYRIGHT=Copyright© 1996-1997 InstallShield Software Corporation, Phone: (847) 240-9111 VERFILEDATEHI=0x0 VERFILEDATELO=0x0 VERFILEOS=0x10001 VERFILETYPE=0x1 MODULE_TYPE=WIN32 PE_CHECKSUM=0x0 LINKER_VERSION=0x0 UPTO_BIN_FILE_VERSION=5.10.130.0 UPTO_BIN_PRODUCT_VERSION=5.10.130.0 LINK_DATE=11/19/1997 22:02:47 UPTO_LINK_DATE=11/19/1997 22:02:47 VER_LANGUAGE=English (United States) [0x409] / MATCHING_FILE NAME=_ISTMP0.DIR\25ef1c.DLL SIZE=129536 CHECKSUM=0x7FB7CC64 BIN_FILE_VERSION=5.10.130.0 BIN_PRODUCT_VERSION=5.10.130.0 PRODUCT_VERSION=5.10.130.0 FILE_DESCRIPTION=InstallShield Resources COMPANY_NAME=InstallShield Software Corporation PRODUCT_NAME=InstallShield® FILE_VERSION=5.10.130.0 LEGAL_COPYRIGHT=Copyright© 1990-1997 InstallShield Software Corporation, Phone: (847) 240-9111 VERFILEDATEHI=0x0 VERFILEDATELO=0x0 VERFILEOS=0x10001 VERFILETYPE=0x1 MODULE_TYPE=WIN32 PE_CHECKSUM=0x0 LINKER_VERSION=0x0 UPTO_BIN_FILE_VERSION=5.10.130.0 UPTO_BIN_PRODUCT_VERSION=5.10.130.0 LINK_DATE=11/19/1997 22:02:17 UPTO_LINK_DATE=11/19/1997 22:02:17 VER_LANGUAGE=English (United States) [0x409] / MATCHING_FILE NAME=_ISTMP0.DIR\IsUninst.Exe SIZE=303616 CHECKSUM=0x9210B539 BIN_FILE_VERSION=5.10.130.0 BIN_PRODUCT_VERSION=5.10.130.0 PRODUCT_VERSION=5.10.130.0 FILE_DESCRIPTION=InstallShield® unInstaller COMPANY_NAME=InstallShield So ftware Corporation PRODUCT_NAME=InstallShield® unInstaller FILE_VERSION=5.10.130.0 LEGAL_COPYRIGHT=Copyright© 1990-1997 InstallShield Software Corporation Phone : (847) 240-9111 VERFILEDATEHI=0x0 VERFILEDATELO=0x0 VERFILEOS=0x10001 VERFILETYPE=0x1 MODULE_TYPE=WIN32 PE_CHECKSUM=0x0 LINKER_VERSION=0x0 UPTO_BIN_FILE_VERSION=5.10.130.0 UPTO_BIN_PRODUCT_VERSION=5.10.130.0 LINK_DATE=11/19/1997 22:02:28 UPTO_LINK_DATE=11/19/1997 22:02:28 VER_LANGUAGE=English (United States) [0x409] / /EXE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug or feature fulltext search?
Hi! On Jul 24, Jocelyn Fournier wrote: Hi, I've encountered a similar bug on my own table. If you want, I can upload a tar.gz of my table (5 MB), with the associated query needed to reproduce the problem ? Regards, Jocelyn sure, thank you. upload it to ftp://support.mysql.com/pub/mysql/secret/ Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL - Ecommerce problem
Check you users table under 'mysql' database. This is what controls access. Here, check the 'hosts' column. Update the old IP/DSN to the new ones and then do a 'flush privileges' and you should be fine. If you don't want to update but add a new record that should be fine to. Do a GRANT . for the new 'user'@'host'. Regards, Bhavin. - Original Message - From: Ingrid Kast Fuller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 4:58 AM Subject: MySQL - Ecommerce problem I just moved my servers and have new DNS names and IP addresses. I need to update my MySQL databases because our Ecommerce sites are giving Internal Server Errors in Apache, see this link: http://www.toyotaworld.com/cart/toyotaecommerce.cgi?store=toyotaecommerceac tion=filefile=home.tmpl I used PhpAdmin to make some changes in the Shopping Cart main database (from cs1.cityscope.net to ns1.cityscope.net), but I am still getting the errors. Can anyone tell me where I need to change the server info and what are the commands to do it? I appreciate your help, thanks. Ingrid Kast Fuller CityScope Net 3910 Fairmont Parkway #264 Pasadena, TX 77504-3066 (713) 477-6161 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.51 compile problems with SuSE 8.0
I have come across a problem compiling MySQL 3.23.51 on a SuSE 8.0 computer. I have tried compiling the same source code on a SuSE 7.3 computer with no apparent problems. Note that I have not actually used the version compiled on the 7.3 machine - I simply wanted to make sure it would compile. The commands I issue are as follows: # CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static # make The configure part runs fine. The make part fails with: gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -O3 -c libmysql.c -fPIC -DPIC -o .libs/libmysql.lo libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/tmp/download/mysql-3.23.51/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/tmp/download/mysql-3.23.51' make: *** [all-recursive-am] Error 2 Is there something I am doing wrong? Is there a problem with the source? Or does the problem lie with SuSE 8.0? Or gcc? The SuSE 8.0 computer is a dual PII-400 with 128Mb of memory, the SuSE 7.3 computer is a dual PIII-1GHz with 1Gb of memory. The compiler in both cases is gcc 2.95.3, though the version on the SuSE 8.0 machine is 2.95.3-219 and the version on the SuSE 7.3 machine is 2.95.3-52 (according to the rpm information). I have also tried 3.23.49 on the SuSE 8.0 machine and got the following error during the configure phase (using the same ./configure script as above): ... checking for c++... gcc checking whether the C++ compiler (gcc -O3 -felide-constructors -fno-exceptions -fno-rtti ) works... no configure: error: installation or configuration problem: C++ compiler cannot create executables. Any help in getting 3.23.51 compiled would be greatly appreciated! Regards Dr. Andy Dawson [EMAIL PROTECTED] http://www.mossie.org http://www.museum-explorer.org.uk Never attribute to malice that which is adequately explained by stupidity. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Create Table error with MySQL version 3.23.39-max-nt, Access 2000, and MyODBC 2.50.39-nt
I am currently using MySQL version 3.23.39-max-nt, MS Access 2000 as my gui, and MyODBC 2.50.39-nt I am able to run reports, queries and use the SQL pass through in access to retrieve data from the MySQL database through MyODBC. The problem is that I can not create a table in MySQL from Access in using the pass through to MyODBC. The SQL code works fine from the command line, but I am unable to get it to run through the pass-through in access. All of my other queries run fine, the only problem I have is with the create table and it gives me a generic error code. I have tested the DSN and it connects successfully. Any assistance would be helpful! TIA, Liz Craig - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL - Ecommerce problem
Hi, You must reconfigure httpd.conf , because i suppose you don't change the path to your new location of the CGI scriptor...you not have right to execute POST/GET method on your serverand this mean that your CGI script can not run. This error is specific about what i aforementioned. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ingrid Kast Fuller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 2:58 PM Subject: MySQL - Ecommerce problem I just moved my servers and have new DNS names and IP addresses. I need to update my MySQL databases because our Ecommerce sites are giving Internal Server Errors in Apache, see this link: http://www.toyotaworld.com/cart/toyotaecommerce.cgi?store=toyotaecommerceac tion=filefile=home.tmpl I used PhpAdmin to make some changes in the Shopping Cart main database (from cs1.cityscope.net to ns1.cityscope.net), but I am still getting the errors. Can anyone tell me where I need to change the server info and what are the commands to do it? I appreciate your help, thanks. Ingrid Kast Fuller CityScope Net 3910 Fairmont Parkway #264 Pasadena, TX 77504-3066 (713) 477-6161 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL dies after longtext field created
My MySQL server 3.23.51 died in an hour after I created a table containing longtext field. I am not sure that this was the reason but suspect so since it was running for few weeks w/out problems. It stopped accepting answering TCP UNIX socket connections, although was still listening on TCP. killall mysqld didn't stop it. During those kills it logged: Forcing close of thread 187 user: 'yuri' for several different thread numbers. Anyone knows if longtext functionality is still unstable so it shouldn't be used? Yuri. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Joins, ANSI 92 or the old way
Hi. On Wed 2002-07-24 at 09:46:03 +0100, [EMAIL PROTECTED] wrote: As I understand it an ANSI92 join is written as; SELECT b.columnA FROM tableB AS b JOIN ON tableC AS c ON b.id = c.id Ah. Okay. Was not aware that this was new in ANSI92. Whereas the 'old' style would be; SELECT b.columnA FROM tableB AS b, tableC AS c WHERE b.id = c.id Personally I find the former much easier to read though not sure about the practical differences between them when the statements are executed. AFAICT, there should be no differences on execution speed. Greetings, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Important: Got error 127 from table handler (1030)?
At 16:53 24.07.02 +0700, you wrote: Pada Wed, 24 Jul 2002 11:01:24 +0200 Daniel Brockhaus [EMAIL PROTECTED] menulis : well, the subject says it all. I'm using version 3.23.41-log, and I got the following error message when trying to update a row: Got error 127 from table handler (1030) It's a normal query which has succeeded several thousand times already. table got corrupt ... you have to repair the table ... ;) Well, who corrupted the table, then? Neither the computer running mysqld nor mysqld has crashed. No program besides one mysqld server is accessing the database files. The harddisk is new, and there are no read or write errors in the OS logs. And why did the same query succeed a few minutes later? Confused, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to update time field with current time?
Hi Probably a silly question but how can I set a time field to the current time with update in mysql? I have 4 time fields per record. Should I have used set them up as timestamp? Thanx. Dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432 1100 * Fax: 0207 286 8668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem in deleting multi table
Hi! Minjie == Minjie Qiu [EMAIL PROTECTED] writes: Minjie Hello, Minjie I'm working on a purge utility to purge 3 tables: call_record, Minjie modem_call_rec and makrup. Those 3 tables are related with foreign key Minjie recid, so I used the following sql to purge data that is older than 30 days: Minjie delete call_record, modem_call_rec, markup from call_record, Minjie modem_call_rec, markup where to_days(now())-to_days(call_record.setup)=30, Minjie and call_record.recid=modem_call_rec.recid and call_record.recid=markup.recid; Minjie The result is, it works well with limited number of records. But when the Minjie number of records increases, for example to 500 records per table, Minjie call_record table is purged correctly, but the other two tables Minjie (modem_call_rec and markup) are not purged at all. Minjie The mysql manual mentioned that delete may not work when deleting tables Minjie with correlated columns. Is that the reason why the above query does not work? No, this should not be the case here. I don't see any reason for why the above should not work. Can you produce a test case for this so that we can look into it? If yes, send it to ftp:://support.mysql.com/pub/mysql/secret and we will try to fix this. cut Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql 3.23 to version 4 upgrade
Question is, can you connect via the mysql client. This looks like an authentication issue as opposed to something specific to PHP. Bhavin. - Original Message - From: Ingrid Kast Fuller [EMAIL PROTECTED] To: chuck amadi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 5:59 AM Subject: RE: MySql 3.23 to version 4 upgrade Well I have FreeBSD 4.2 and MySQL 3.23.33 running on localhost. I use PhpMyAdmin to do any modifications. I did make the nameserver changes in: Database ShoppingCart - table stores Database mysql - table db Database mysql - table host Database mysql - table user I reset mysql and apache and still get Internal Server errors and here's whats in the logs: DBI-connect(toyotaecommerce:ns1.cityscope.net) failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) at /usr/local/www/data/cart/toyotaecommerce.cgi line 33 [Wed Jul 24 07:44:37 2002] [error] Can't call method prepare on an undefined value at /usr/local/lib/perl5/site_perl/5.005/CityScope/ShoppingCart.pm line 267. this is line 33... my $dbh = DBI-connect(DBI:mysql:$toyotaecommerce{dbname}:$toyotaecommerce{dbhostname }, $toyotaecommerce{dbuser}, $toyotaecomm this is line 267 sub getIDdb { my ($self, $dbh, $id, $store) = @_; my ($check, $sth, @cart); $check = 'select * from carts where(id = ' . $id . ');'; $sth = $dbh-prepare($check) or $self-Error('Could not prepare select statement in sub getIDdb(); ' . $dbh-errstr); Ingrid Kast Fuller CityScope Net 3910 Fairmont Parkway #264 Pasadena, TX 77504-3066 (713) 477-6161 -Original Message- From: chuck amadi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 7:14 AM To: Ingrid Kast Fuller Subject: Re: MySql 3.23 to version 4 upgrade Ingrid Kast Fuller wrote: Hey Chuck, since you're up at this time, could I ask you for some MySQL help? I changed my name server names and IP addresses and having trouble getting them put in the database and my ecommerce sites are currently down. I have phpAdmin and went into one file and changed all the cs1.cityscope.net to ns1.cityscope.net but that didn't help. Where else would I change the info so the database will work. I keep getting Internal Server Error's? Your help is appreciated. Ingrid Kast Fuller CityScope Net 3910 Fairmont Parkway #264 Pasadena, TX 77504-3066 (713) 477-6161 -Original Message- From: chuck amadi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 3:33 AM To: mysql Subject: MySql 3.23 to version 4 upgrade Hi all , i'm about to upgrade from MySql 3.23 to version 4 are there any issues that should be addressed ie uninstall v3 prior to installing v4 or can i just install over v3. Any suggested sites' ,FAQ regarding my question. -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Hi There Plz could explain what O/s and Server as I'm currently running Apache v1 with PhpMyAdmin (maintenace purposes only) running on my Win Box 98 for testing development etc. Work stuff is linux based environment System Administrator sorts that stuff out. Thus i edited C:\Program Files \ Apache Group\Apache\Conf\httpd.conf and look for # ServerName new.host.name and add your ipAddress thus if your'e running virutally hosts go to the bottom - #NameVirtualHost VirtualHost ServerName DocumentRoot ServerName Also check your'e WebAppConnection Conn Warp yourHost:8008 (your port) Best thing to do is C P to list altering of cause your ipAddress details. I hope this helps or someone with more exp continue's the thread. -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
random order with rand() is foreseeing
Description: The problem is affected in combination with 'order by' and 'rand()'. Please check the report under: http://bugs.php.net/bug.php?id=13287edit=1 How-To-Repeat: You can compare my results with the method which is reported in php bug report number 13287 http://bugs.php.net/bug.php?id=13287edit=1 Fix: Rewrote the random routines. I think this is not only a small bug, it is a potentially security hole if someone using this type of random results in a security environment. Category: mysql Class: sw-bug Release: mysql-4.0.2-alpha (Source distribution) and mysql-3.x.x System: Linux tratos 2.4.18-6mdk #1 Fri Mar 15 02:59:08 CET 2002 i686 unknown Architecture: i686 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL on a Cobalt RAQ4
Hi, I'm in the same situation (installing mysql on a raq4). The package master site's most recent version (that I noticed) of mysql is MySQL 3.23.37 Does anyone have suggestions for a more recent version in .pkg? Thanks, Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL - Ecommerce problem
Hi, You must reconfigure httpd.conf , because i suppose that you don't change the path to your new location of the CGI scriptor...you not have right to execute POST/GET method on your serverand this mean that your CGI script can not run. This error is specific about what i aforementioned. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ingrid Kast Fuller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 2:58 PM Subject: MySQL - Ecommerce problem I just moved my servers and have new DNS names and IP addresses. I need to update my MySQL databases because our Ecommerce sites are giving Internal Server Errors in Apache, see this link: http://www.toyotaworld.com/cart/toyotaecommerce.cgi?store=toyotaecommerceac tion=filefile=home.tmpl I used PhpAdmin to make some changes in the Shopping Cart main database (from cs1.cityscope.net to ns1.cityscope.net), but I am still getting the errors. Can anyone tell me where I need to change the server info and what are the commands to do it? I appreciate your help, thanks. Ingrid Kast Fuller CityScope Net 3910 Fairmont Parkway #264 Pasadena, TX 77504-3066 (713) 477-6161 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem downloading MySQL4.0.2a for windows
Hi All, Do anyone knows when the MySQL4.0.2a for windows is available for download? Thanks. Regards, Michael -Original Message- From: Tam, Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 11:38 AM To: 'Victoria Reznichenko'; [EMAIL PROTECTED] Subject: RE: Problem downloading MySQL4.0.2a for windows Hi Victoria, Do you know when the 4.0.2a-MAX would be available for download then? Thank you. Regards, Michael -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 4:26 AM To: [EMAIL PROTECTED] Subject: Re: Problem downloading MySQL4.0.2a for windows Tam, Tuesday, July 23, 2002, 12:39:33 AM, you wrote: T I have difficulties obtaining the MySQL4.0.2a. It seems that numerous T downloads T links point to the files stated as 4.0.2 zip file but during the setup , it T was 4.0.1a T instead. Where can I obtain the 4.0.2a ? Many thanks. There was troubles only with mysql-max-4.0.2-alpha-win. This file was the same as mysql-max-4.0.1, but mysql-4.0.2-alpha-win (without -max) works well... -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query Optimization
I was wondering if somebody could give me any suggestions on how to optimize a query I am working on. This is my table: CREATE TABLE testdata ( Begin char(9) NOT NULL default '', End char(9) NOT NULL default '', UNIQUE KEY BeginEndIndex (Begin,End) ) TYPE=MyISAM; It is a table of ranges. i.e. 1-5, 7-11, 2-24000. None of the ranges overlap, and I'm trying to write a query to find a range that contains a specific number such as 500,000. So this is what I've written for a query: select Begin, End from testdata where begin = '00500' and end = '00500' On a table with 100,000 records the explain command tells me it is using the BeginEndIndex, it says the key length is 9, and that it has to look through about 27,000 records. I would like to be able to configure the query or indexes , so it will only have to look through a couple records if possible. MySQL is super fast at a query like this: select Begin from testdata where Begin = '00500'; So I had the idea of trying this: select max(Begin) from testdata where Begin = '00500'; I was hoping that it would do the same as the simple select, and then because it has a sorted index it wouldn't have to search the previous records to find the max, but explain still puts this at about 27,000 records. Has anyone else tried writing a query similar to this? Does anybody have any suggestions? Thanks in advance, Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug or feature fulltext search?
Hi, I uploaded the table under ftp://support.mysql.com/pub/mysql/secret/config.tar.gz To reproduce the bug : SELECT pseudo FROM config WHERE MATCH (config) AGAINST ('+(tes*) +test' IN BOOLEAN MODE); SELECT pseudo FROM config WHERE MATCH (config) AGAINST ('+tes* +test' IN BOOLEAN MODE); mysql SELECT pseudo FROM config WHERE MATCH (config) AGAINST ('+(tes*) +test' IN BOOLEAN MODE); ++ | pseudo | ++ | bart70 | | brioche| | chupabouc | | Cobalt | | Delio | | igor | | jojo61 | | kalisto| | lancelot75 | | matthias | | napalm02 | | picha | | The Mad| | tuxinette | | utcddzeus | | vachefolle | | WildGoose | | xeo| ++ 18 rows in set (0.01 sec) mysql SELECT pseudo FROM config WHERE MATCH (config) AGAINST ('+tes* +test' IN BOOLEAN MODE); ++ | pseudo | ++ | bart70 | | brioche| | chupabouc | | Cobalt | | Delio | | igor | | jojo61 | | kalisto| | lancelot75 | | matthias | | napalm02 | | picha | | The Mad| | tuxinette | | utcddzeus | | vachefolle | | WildGoose | | xeo| | _jajax | ++ 19 rows in set (0.01 sec) Regards, Jocelyn - Original Message - From: Sergei Golubchik [EMAIL PROTECTED] To: Jocelyn Fournier [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 4:45 PM Subject: Re: Bug or feature fulltext search? Hi! On Jul 24, Jocelyn Fournier wrote: Hi, I've encountered a similar bug on my own table. If you want, I can upload a tar.gz of my table (5 MB), with the associated query needed to reproduce the problem ? Regards, Jocelyn sure, thank you. upload it to ftp://support.mysql.com/pub/mysql/secret/ Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query Optimization
Hi, I did some more research on my problem. (Sorry for not doing it before I posted the other message), and I think perhaps my question could be summarized into the following. Can I use an index to speed up a select max() or select min()? I read what the manual has to say about a query like this: SELECT MIN(key_part2),MAX(key_part2) FROM table_name where key_part1=10 However I want to do this: SELECT MAX(key_part1) FROM table_name where key_part1 10 also what I want to do is basically equivalent to this: SELECT key_part1 FROM table_name WHERE key_part1 10 ORDER BY key_part1 DESC LIMIT 1 In testing the second statement seems slower than the max() for some reason though. Is there anyway to get close to a O(logN) search time on these queries? Thanks again, Dave -Original Message- From: Dave Dutcher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 1:04 PM To: [EMAIL PROTECTED] Subject: Query Optimization I was wondering if somebody could give me any suggestions on how to optimize a query I am working on. This is my table: CREATE TABLE testdata ( Begin char(9) NOT NULL default '', End char(9) NOT NULL default '', UNIQUE KEY BeginEndIndex (Begin,End) ) TYPE=MyISAM; It is a table of ranges. i.e. 1-5, 7-11, 2-24000. None of the ranges overlap, and I'm trying to write a query to find a range that contains a specific number such as 500,000. So this is what I've written for a query: select Begin, End from testdata where begin = '00500' and end = '00500' On a table with 100,000 records the explain command tells me it is using the BeginEndIndex, it says the key length is 9, and that it has to look through about 27,000 records. I would like to be able to configure the query or indexes , so it will only have to look through a couple records if possible. MySQL is super fast at a query like this: select Begin from testdata where Begin = '00500'; So I had the idea of trying this: select max(Begin) from testdata where Begin = '00500'; I was hoping that it would do the same as the simple select, and then because it has a sorted index it wouldn't have to search the previous records to find the max, but explain still puts this at about 27,000 records. Has anyone else tried writing a query similar to this? Does anybody have any suggestions? Thanks in advance, Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slow queries
Hello, I am running mysql in our production environment, which have a few reporting tables with millions of rows. Certain queries cascade 2 such tables that have millions of rows and there by, there are extremely slow, sometimes taking over 10 minutes. However, we are ok with that since the size of the data is extremely large. However, the problem that we are facing is that when these queries are running, other queries, *unrelated to the 2 large tables* are also put on hold, so they can't be executed either and basically mysql becomes unresponsive until I kill the SLOW query and then everything is back to normal. Anybody knows why this happens and if there is a solution for this (like maybe, reprioritizing the slow query to a very low priority or something). I would think that mysql would independently try to execute the other queries but that does not seem to be happening. Thanks, Bhavin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Primary and Foreign Keys in MySQL
Hello, I am working on MySQL database. I have come across a 'problem' but don't know how to get around that. The problem is the following: I have a table, say TABLE1, with primary key being called as table1_id. Now there are other tables, like TABLE1A, TABLE1B, TABLE1C etc.. where I want to use primary key of TABLE1 (i.e table1_id) as foreign key. I see a problem in using the function LAST_INSERT_ID(). Lets say I use it to insert a record in TABLE1A, that will work fine. But now if I use it to put a record in TABLE1B it would give me the primary key ID of TABLE1A rather than TABLE1. Please help me out on this. Aamer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: how to update time field with current time?
It would be a lot easier for you to have just used a timestamp, it automatically updates itself when a record is modified. Otherwise you would just update the time field in question when you do your other updates SET timefield = NOW() should work Though using a TIME datatype is not very informative as it only stores the time 00:00:00, and we all know that that time happens once a day, every day for the rest of eternity :) -Original Message- From: Dermot Paikkos [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:46 PM To: [EMAIL PROTECTED] Subject: how to update time field with current time? Hi Probably a silly question but how can I set a time field to the current time with update in mysql? I have 4 time fields per record. Should I have used set them up as timestamp? Thanx. Dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432 1100 * Fax: 0207 286 8668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Joining question
You gave the answer. Using left join it will work and give you NULL values for not found records. I had a similar problem here and left join worked ok. Bye, Anderson Ataides = Em Quarta 24 Julho 2002 03:51, you wrote: Hi I'm designing 2 tables, where tabProds has the foreign key of tabUsers. So when I want to join them I use.. WHERE tabProds.usr_ID = tabUsers.usr_ID Ok But the thing is that sometimes will not be possible to specify a user when you insert a Product(becaouse we don't know at that time)... And I'm anticipating the query mentioned above would not display the products that doesn't match any user's ID, AND I want those records to be showed too. Would be like this...? WHERE (tabProds.usr_ID = tabUsers.usr_ID) or (tabProd.usr_ID= Null) But, with this query, what is going to show on the User's columns when it gets a Null field..? ProdID UserID UserName 232John 34Null? --- What's going to happen here..? 454Pedro Or is there anohter options..? like Left joins.. and all that, (I haven't analize them yet) I know you may think... Well do the test and see it, well yes, is just that affects the way I'm thinking to design the web system, and I would like to know when I'm on the DB design and before the programming Thank you jgarza - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Configure/Make problem, SuSE 8.0, mysql-3.23.51
Description: Make reports this: libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/home/perl/downloads/db/mysql-3.23.51/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/perl/downloads/db/mysql-3.23.51' make: *** [all-recursive-am] Error 2 How-To-Repeat: configure/make Fix: Unknown Submitter-Id: [EMAIL PROTECTED] Originator: [EMAIL PROTECTED] Organization: MySQL support: none Synopsis: Configure/Make problem, SuSE 8.0, mysql-3.23.51 Severity: non-critical Priority: low Category: mysql Class:support Release: mysql-3.23.51 (Source distribution) Environment: machine: Dell Optiplex GX1, os: SuSE Linux 2.4.18-4GB, target: ? libraries ? System: Linux hdeteam 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1394238 Mar 23 12:34 /lib/libc.so.6 -rw-r--r--1 root root 25361424 Mar 23 12:05 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 23 12:05 /usr/lib/libc.so Configure command: CFLAGS=-O3 CC=gcc CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions \ -fno-rtti ./configure --prefix=/usr/local/mysql --enable-assembler \ --with-named-curses-libs=/usr/lib/curses \ --with-mysqld-ldflags=-all-static (See attached file: config.log.gz) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to update time field with current time?
On Wed, 24 Jul 2002, Dermot Paikkos wrote: Date: Wed, 24 Jul 2002 17:46:00 +0100 From: Dermot Paikkos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: how to update time field with current time? Hi Probably a silly question but how can I set a time field to the current time with update in mysql? I have 4 time fields per record. Should I have used set them up as timestamp? the function NOW(). Note you can have only one TimeStamp field in a table (i.e., one which will be automatically updated). The other ones should be datetime fields to avoid confusion. Thanx. Dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432 1100 * Fax: 0207 286 8668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
hebrew/arabic language
hi guys, am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show characters of language such as hebrew/arabic? thanks for help sql -- Hytham Shehab - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query Optimization
In the last episode (Jul 24), Dave Dutcher said: I was wondering if somebody could give me any suggestions on how to optimize a query I am working on. This is my table: CREATE TABLE testdata ( Begin char(9) NOT NULL default '', End char(9) NOT NULL default '', UNIQUE KEY BeginEndIndex (Begin,End) ) TYPE=MyISAM; It is a table of ranges. i.e. 1-5, 7-11, 2-24000. None of the ranges overlap, and I'm trying to write a query to find a range that contains a specific number such as 500,000. So this is what I've written for a query: select Begin, End from testdata where begin = '00500' and end = '00500' Put an index on (begin,end). It will only have to do a range scan on that index to find the matching records. You might also want to make those columns integers instead of chars; they'll take up a bit less space that way. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Primary and Foreign Keys in MySQL
I'm assuming you have AUTO_INCREMENT columns in each table? Try this: INSERT INTO TABLE1(...) VALUES(...); SELECT @t1id := LAST_INSERT_ID(); INSERT INTO TABLE1A(table1_id, ...) VALUES(@t1id, ); INSERT INTO TABLE1B(table1_id, ...) VALUES(@t1id, ); ... -JF -Original Message- From: Aamer Rauf [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:55 PM To: [EMAIL PROTECTED] Subject: Primary and Foreign Keys in MySQL Hello, I am working on MySQL database. I have come across a 'problem' but don't know how to get around that. The problem is the following: I have a table, say TABLE1, with primary key being called as table1_id. Now there are other tables, like TABLE1A, TABLE1B, TABLE1C etc.. where I want to use primary key of TABLE1 (i.e table1_id) as foreign key. I see a problem in using the function LAST_INSERT_ID(). Lets say I use it to insert a record in TABLE1A, that will work fine. But now if I use it to put a record in TABLE1B it would give me the primary key ID of TABLE1A rather than TABLE1. Please help me out on this. Aamer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to update time field with current time?
On 2002-07-24 08:46, Dermot Paikkos [EMAIL PROTECTED] wrote: Hi Probably a silly question but how can I set a time field to the current time with update in mysql? I have 4 time fields per record. Should I have used set them up as timestamp? Now() will update to the current time Insert into table values(now()); - hcir [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question about varchars
Hello there Mysql documentation says the following: values are stored using only as many characters as are needed, plus one byte to record the length. Values are not padded; instead, trailing spaces are removed when values are stored. So, then would there be anything wrong with making all my varchar's up to 255. That is defining most of my fields to be varchar(255) even when i know they may only go 100? Thanks Desmond _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Important: Got error 127 from table handler (1030)?
Pada Wed, 24 Jul 2002 18:43:43 +0200 Daniel Brockhaus [EMAIL PROTECTED] menulis : At 16:53 24.07.02 +0700, you wrote: Pada Wed, 24 Jul 2002 11:01:24 +0200 Daniel Brockhaus [EMAIL PROTECTED] menulis : well, the subject says it all. I'm using version 3.23.41-log, and I got the following error message when trying to update a row: Got error 127 from table handler (1030) It's a normal query which has succeeded several thousand times already. table got corrupt ... you have to repair the table ... ;) Well, who corrupted the table, then? Neither the computer running mysqld nor mysqld has crashed. No program besides one mysqld server is accessing the database files. The harddisk is new, and there are no read or write errors in the OS logs. And why did the same query succeed a few minutes later? first error 127 doesn't always mean the whole table can't be accessed, it could be only some part of it was corrupt. well just to make sure your table is ok ... do query check table tablename extended and if it's corrupt ... you have to repair the table ;-) -- panic(esp: what could it be... I wonder...); 2.2.16 /usr/src/linux/drivers/scsi/esp.c MySQL 3.23.51 : up 33 days, Queries : 353.747 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone : +62 21 79199577 - Web : http://1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Splitting textarea values to put into a database
Hi, Does anyone know how to separate values in a text area field, to enter the separated values into a database? For instance if enter these values into a text area field Dogs Cats Fish I want to be able to take Dogs, Cats and Fish and put them in different rows in a database. I guess the biggest problem I have is splitting the values in the text area field that is separated by a carriage return. Once I have that, and I know how to separate the values, then I can easily put them into a database. BTW I am using CGI/PERL to enter the values into a MySql database. Thanks for any advice Emma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question about varchars
Hello there Mysql documentation says the following: values are stored using only as many characters as are needed, plus one byte to record the length. Values are not padded; instead, trailing spaces are removed when values are stored. So, then would there be anything wrong with making all my varchar's up to 255. That is defining most of my fields to be varchar(255) even when i know they may only go 100? Thanks Desmond _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Grant Question
I have an existing mysql user that I wish to add the INDEX privilege. Is there a command that I can use to add a privilege without first deleting the user and then recreating with the GRANT command? Thank You - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
IBM-AIX 4.3 MySQL Binnary Installation Problem: libz is missing.
Hi, When I try to execute scripts/mysql_install_db, I get some errors about some libraries missing: exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-150 Dependent module libz.a(shr.o) could not be loaded. 0509-022 Cannot load module libz.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. How can I get those libraries and what should I do once I get them? Thanks in advance. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Slow queries
Bhavin I'm doing queries to one table with 4 other smaller tables. The large table is 12-14 million records. With an index, the table select is 13-15 seconds. With a compound index, the delay is sub one second. Use explain to verify which index is being used. Read the manual to tune your index's. The only time it is slower (4-6 seconds) is when the index is in swap. Can anyone tell me how to prevent Solaris from moving part of mysqld to swap? I'm thinking a config file - but where. David -Original Message- From: Bhavin Vyas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 3:54 PM To: [EMAIL PROTECTED] Subject: Slow queries Hello, I am running mysql in our production environment, which have a few reporting tables with millions of rows. Certain queries cascade 2 such tables that have millions of rows and there by, there are extremely slow, sometimes taking over 10 minutes. However, we are ok with that since the size of the data is extremely large. However, the problem that we are facing is that when these queries are running, other queries, *unrelated to the 2 large tables* are also put on hold, so they can't be executed either and basically mysql becomes unresponsive until I kill the SLOW query and then everything is back to normal. Anybody knows why this happens and if there is a solution for this (like maybe, reprioritizing the slow query to a very low priority or something). I would think that mysql would independently try to execute the other queries but that does not seem to be happening. Thanks, Bhavin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Grant question
I have an existing mysql user that I wish to add the INDEX privilege. Is there a command that I can use to add a privilege without first deleting the user and then recreating with the GRANT command? Thank You -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 6:27 PM To: Paul Maine Subject: Re: Grant question Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I have an existing user that I wish to add the INDEX privilege. Is there a command that I can use to add a privilege without first deleting the user and then recreating with the GRANT command? Thank You - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem downloading MySQL4.0.2a for windows
Hi All, Sorry about the typo. MySQL4.0.2a should be MySql4.0.2a-Max instead. Thank you. Regards, Michael -Original Message- From: Tam, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 10:54 AM To: [EMAIL PROTECTED] Subject: RE: Problem downloading MySQL4.0.2a for windows Importance: High Hi All, Do anyone knows when the MySQL4.0.2a for windows is available for download? Thanks. Regards, Michael -Original Message- From: Tam, Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 11:38 AM To: 'Victoria Reznichenko'; [EMAIL PROTECTED] Subject: RE: Problem downloading MySQL4.0.2a for windows Hi Victoria, Do you know when the 4.0.2a-MAX would be available for download then? Thank you. Regards, Michael -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 4:26 AM To: [EMAIL PROTECTED] Subject: Re: Problem downloading MySQL4.0.2a for windows Tam, Tuesday, July 23, 2002, 12:39:33 AM, you wrote: T I have difficulties obtaining the MySQL4.0.2a. It seems that numerous T downloads T links point to the files stated as 4.0.2 zip file but during the setup , it T was 4.0.1a T instead. Where can I obtain the 4.0.2a ? Many thanks. There was troubles only with mysql-max-4.0.2-alpha-win. This file was the same as mysql-max-4.0.1, but mysql-4.0.2-alpha-win (without -max) works well... -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Delphi MySQL Access Components
Daniel, Personally I found ZEOS a pain in proverbial - poorly documented, constant AVs etc.. D6 dbExpress works very well for me, but I think it only comes with D6 Enterprise. The myODBC driver is another way to go, in which case you could probably use the BDE. There is an ADO driver for mySQL somewhere as well. I could never get it work but if it could be made to work then you could use the ADO components distributed with D6 Pro and Enterprise. Pierre http://www.finalfiler.com Daniel Kiss wrote: Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parte' Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: M$ Acesss Front MySql-Backend field datatype issues using Myodbc
I may be a little OT, but the current myODBC driver does work quite well with Access. So you can use Access to write your queries and app etc and have mySQL as your backend. I've mainly used Access and myODBC to port manipulate Access data to mySQL. For writing mySQL frontends my preferred development tool is Delphi. Hope this helps Pierre http://www.finalfiler.com chuck amadi wrote: Hi again . I have a project whereby the client has a legacy M$ Access ( as far as im concerned ) and i'm to design.build and construct a MySql v4 Back-end and more than likely pursue a front-end with MS Access due to easability and conversant of it's user's nevertheless are there any field datatype issues and if so is there a site or FAQ that suggests prior to development the tried and tested field datatype that will run smoothly between both front back end . If it is clumbberson i more than likely use MySql-Front. Plz can someone confirm that MySql Front has similiar look feel in relation to Forms , buttons and alike. Plz post any good links regarding field datatypes or Sample Projects built with MySql v4 Front. -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Performance Problem - LEFT JOIN
I have 3 tables tableA, tableB and tableC and the fields tableA.id, tableB.idA and tableC.idA. I'm using this query (bellow) to call information from the database that has in tableA but tableA.id is not found on tableB.idA and tableC.idA. SELECT tableA.* FROM tableA LEFT JOIN tableB ON (tableB.idA = tableA.id) LEFT JOIN tableC ON (tableC.idA = tableA.id) WHERE tableB.idA IS NULL AND tableC.idA IS NULL; With a low ammount of data (30 records) I receive the data really fast. However with a greater ammount of data (1800 records) it takes 26 seconds to return data and it consumes 100% of processor. This situation happens when I have all tableA.id registered on tableB.ida or tableC.ida. Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: THIS IS NOT AN ADVERTISEMENT
From: [EMAIL PROTECTED] To: Desmond Lee [EMAIL PROTECTED] Subject: Re: THIS IS NOT AN ADVERTISEMENT Date: Thu, 25 Jul 2002 03:37:48 +0200 Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: { Original-Message-ID: [EMAIL PROTECTED] Original-Sender: Desmond Lee [EMAIL PROTECTED] Original-Subject: question about varchars Original-Date: Wed, 24 Jul 2002 16:42:31 -0700 } _ Chat with friends online, try MSN Messenger: http://messenger.msn.com _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Grant Question
Pada Wed, 24 Jul 2002 18:52:44 -0500 Paul Maine [EMAIL PROTECTED] menulis : I have an existing mysql user that I wish to add the INDEX privilege. Is there a command that I can use to add a privilege without first deleting the user and then recreating with the GRANT command? you can run : grant privilege on db.table to username@host; flush privileges; it will add/update new privilege for user; or you can edit the values on DB mysql ... with table user or db ;-) -- Who is General Failure and why is he reading my hard disk? Microsoft spel chekar vor sail, worgs grate !! -- Felix von Leitner, [EMAIL PROTECTED] MySQL 3.23.51 : up 33 days, Queries : 353.598 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone : +62 21 79199577 - Web : http://1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Grant question
Another grant command for the existing privileges + index privs. should work Bhavin. - Original Message - From: Paul Maine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 5:33 PM Subject: RE: Grant question I have an existing mysql user that I wish to add the INDEX privilege. Is there a command that I can use to add a privilege without first deleting the user and then recreating with the GRANT command? Thank You -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 6:27 PM To: Paul Maine Subject: Re: Grant question Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I have an existing user that I wish to add the INDEX privilege. Is there a command that I can use to add a privilege without first deleting the user and then recreating with the GRANT command? Thank You - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: libmysqlclient.so.10
On Tue, Jul 23, 2002 at 09:22:55PM -0600, Steve Dickey wrote: Can anyone tell me how to get an RPM that provides the libmysqlclient.so.10? I am trying to install the php-mysql-4.1.2-7.i386.rpm and it says that this is a requirement. It comes in an older version of the mysql database rpm but I have 3.23.51 installed and apparently that one does not come with this library??? I am having trouble getting PHP to work with mysql. That is part of the mysql-4.x RPMs (as opposed to the mysql-3.x ones). -- SCSI is usually fixed by remembering that it needs three terminations: One at each end of the chain. And the goat. -- Andrew McDonald, HantsLUG - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
about set page size and set line size
hi all, is there any command in mysql prompt for set page size and set line size like SQL*Plus? TIA ivan paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Delphi MySQL Access Components
Hello Daniel! It works fine. Been using it for several years. Close your connection and query objects and there will be no AV problems... Fredrick - Original Message - From: Pierre du Parte [EMAIL PROTECTED] To: Daniel Kiss [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 5:39 PM Subject: Re: Delphi MySQL Access Components Daniel, Personally I found ZEOS a pain in proverbial - poorly documented, constant AVs etc.. D6 dbExpress works very well for me, but I think it only comes with D6 Enterprise. The myODBC driver is another way to go, in which case you could probably use the BDE. There is an ADO driver for mySQL somewhere as well. I could never get it work but if it could be made to work then you could use the ADO components distributed with D6 Pro and Enterprise. Pierre http://www.finalfiler.com Daniel Kiss wrote: Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parte' Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is type of datetime timestamp same??
Hello All, I m using mysql 3.23.42 and myodbc 3.51 on linux7.2. I use SQLDescribeCol API to get type of column(field). When i call above functuon it returns type of datetime and timestamp is 93 for both. but the format of inserting datetime value uses ( )and timesstamp value is different. I m having a problem how can I distinguish them so that I can insert the data in correct format.or is there any bug in myodbc driver. Thanx in advance for ur kind help. Rgds, Jenny __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is type of datetime timestamp same??
Hello All, I m using mysql 3.23.42 and myodbc 3.51 on linux7.2. I use SQLDescribeCol API to get type of column(field). When i call above functuon it returns type of datetime and timestamp is 93 for both. but the format of inserting using sql query, datetime value uses ( )and timesstamp value is different. I m having a problem how can I distinguish them so that I can insert the data in correct format.or is there any bug in myodbc driver. Thanx in advance for ur kind help. Rgds, Jenny __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: Using MySQL HPUX 10.20 binary on HPUX 11.0
Can anyone see any problems with using the HPUX 10.20 MySQL binaries on HPUX 11.00- it seems to work fine in small scale tests. Regards, Ian Collins. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php