Re: Data Truncated warning about join, not insert?
Hi, Tom Cunningham wrote: I have a funny problem: I'm getting thousands of Data Truncated warnings when I insert a single row of data into a table, using an INSERT...SELECT. I bet that the columns you're joining on have different sizes. -- Matthias Urlichs | {M:U} IT Design @ m-u-it.de | [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Outputting Data
Hi Christopher You need the FROM MembersData directly after the SELECT and before outputting. HTH Steve Christopher Chamber wrote: I have a query: $QRY = SELECT * FROM MembersData; -- Executes fine, no problems. I have another though: $DataSet3 = SELECT * INTO OUTFILE '/www/Export/DataSet3.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' LINES TERMINATED BY '\n' FROM MembersData; -- This returns an error saying the query is empty. Any suggestions people...? --- Christopher Chamber http://gem-hs.org/cc.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ulimit problem
Hi. Usually myisamchk doesn't have the suid bit set, and it seems to be ran as root. See http://dev.mysql.com/doc/mysql/en/Table_maintenance.html Especially http://dev.mysql.com/doc/mysql/en/myisamchk_memory.html J S [EMAIL PROTECTED] wrote: Hi, I've run myisampack to compress a table and am now trying to recreate the index using myisamchk (as root) but I get an error 27. # myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp internet_usage.MYI - check record delete-chain - recovering (with sort) MyISAM-table 'internet_usage.MYI' Data records: 30972875 - Fixing index 1 myisamchk: Error writing file '/proxydb/mysql/tmp/ST3hTDMa' (Errcode: 27) myisamchk: error: 27 when fixing table MyISAM-table 'internet_usage.MYI' is not fixed because of errors Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag # perror 27 Error code 27: A file cannot be larger than the value set by ulimit. The ulimits are set as follows: default: fsize = 2097151 core = 2097151 cpu = -1 data = 262144 rss = 65536 stack = 65536 nofiles = 2000 root: fsize = -1 core = -1 cpu = -1 data = -1 rss = -1 stack = -1 nofiles = 4000 When I run myisamchk, is it running with root privilidges or as user mysql? By the way this is a large enabled filesystem. Thanks, JS. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data Truncated warning about join, not insert?
Sorry I forgot to include table-defs: .. OK, I've got it entirely reproducible now, without giving away any sensitive data. No, the column-lengths are the same. But doing this has shown me that it's something to do with the partial key on the 'email' column in the 'user' table. If you remove it, it stops happening. This is not what I would have expected - does it make sense? --- DROP TABLE IF EXISTS customers; CREATE TABLE `customers` ( `id` bigint(20) NOT NULL auto_increment, `email` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; drop table if exists user; CREATE TABLE `user` ( `user_id` int(11) NOT NULL auto_increment, `email` varchar(255) NOT NULL default '', PRIMARY KEY (`user_id`), KEY `user_id` (`user_id`), KEY `email` (`email`(15)) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; insert into user (user_id, email) values (5122 , '[EMAIL PROTECTED]' ), (5143 , '[EMAIL PROTECTED]'); INSERT INTO customers (id) SELECT null FROM user LEFT JOIN user dup_user ON dup_user.user_iduser.user_id AND user.email=dup_user.email LIMIT 1; show warnings; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LOAD DATA LOCAL: The used command is not allowed with this MySQL version
Hi mysql-community! I have a problem with mysql 3.23.49a: If I try to use the statement 'LOAD DATA LOCAL INFILE '/storage/hosting/uxclients/www.xxx.ch/transfer/golfclub.csv' INTO TABLE test' mysql replys: 'The used command is not allowed with this MySQL version'. Why this error-message? Was LOAD DATA LOCAL not supported with 3.23? I read, that LOAD DATA LOCAL was added with 3.22.6 Do you have an idea? Thank you, Martin
Re: select from table hangs?
Hi. Try to upgrade to the latest release (use official binaries from MySQL). Kristina Clair [EMAIL PROTECTED] wrote: Hello, I am having a problem with a mysql (myisam) table that I've never had before, and I'm completely stumped! I am using mysql version 4.0.13. myisamchk -e table.MYI returns no errors. Yet, when I try to do any kind of select from the mysql prompt, it just hangs and never returns an error code. Does anyone have any thoughts on what might be wrong or other ways to debug this? Thanks! -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: LOAD DATA LOCAL: The used command is not allowed with this MySQL version
Hi. See http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html Martin Rytz [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 123 when reading table
Hi. Try to upgrade to the latest version (use official binaries from MySQL). Unreal HSHH [EMAIL PROTECTED] wrote: Sometimes, mysql client got this error, mysql error: Record has changed since last read in table 'table' And I checked from mysql error log, 041023 8:28:06 Got error 123 when reading table './db/table' What's this error? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql tomcat
Hi All, we are using mysql and tomcat ... when i try to access the other system's data the programs throw javax.servlet.ServletException: Server configuration denies access to data source exceptionwhere as when i access the databse on the same system(ie., localhost) then it does not throw any exception and we have checked the priviledges on the other system .everything is fine but still the problem persists please help. thx in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
proper index creating
hi, I have some question about indexes more... in this example we have table just like this: table_tbl tableid int [primary key] tablefield1 tablefield2 ... tablefieldx tablefieldsort1 int tablefieldsort2 varchar(32) there are lots of questions containing order by clause like: select t.* from table_tbl t where condition 1... condition 2... condition x... order by tablefieldsort1 desc tablefirldsort2 asc my question is: what indexes must be created to be used in order by clause? they must speed up search and order by ... with regards DeRyl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql browser
Hi. I was wondering how you can edit/change tables and data inside a table with mysql query browser. I run mysql 5.0.0 on windows xp sp2. It says in the help that you can edit/change tables and data inside tables if there is enough identifiable information inside the table. What does that mean and how do you change it? I cant seem to edit or change anything on any of the tables I have. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql browser
Hi. MySQL Query Browser is a graphical tool designed to help constructing and executing queries. Andy B [EMAIL PROTECTED] wrote: Hi. I was wondering how you can edit/change tables and data inside a table with mysql query browser. I run mysql 5.0.0 on windows xp sp2. It says in the help that you can edit/change tables and data inside tables if there is enough identifiable information inside the table. What does that mean and how do you change it? I cant seem to edit or change anything on any of the tables I have. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql and innoDB
Egor Egorov [EMAIL PROTECTED] wrote: Stefan Gnann [EMAIL PROTECTED] wrote: I have a mysql database 4.0.15 on a suse linux 9.x system running. First, upgrade to .20 version officially built by MySQL AB (http://dev.mysql.com/). RPM version is easy to install and run. Oops, of course I meant the latest, .21. -- -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ulimit problem
Hi. Sounds OK, but don't forget to make a backup. J S [EMAIL PROTECTED] wrote: Thanks for your reply Gleb. I tried running with --safe-recover instead of -qr but that caused some other processes running on the box to hang and coredump so I had to kill it off. I'll try running: myisamchk -qr --tmpdir=/proxydb/mysql/tmp -O sort=16M -O key=16M -O read=1M -O write=1M --sort-index --analyze internet_usage Sound OK? JS. Hi. Usually myisamchk doesn't have the suid bit set, and it seems to be ran as root. See http://dev.mysql.com/doc/mysql/en/Table_maintenance.html Especially http://dev.mysql.com/doc/mysql/en/myisamchk_memory.html J S [EMAIL PROTECTED] wrote: Hi, I've run myisampack to compress a table and am now trying to recreate the index using myisamchk (as root) but I get an error 27. # myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp internet_usage.MYI - check record delete-chain - recovering (with sort) MyISAM-table 'internet_usage.MYI' Data records: 30972875 - Fixing index 1 myisamchk: Error writing file '/proxydb/mysql/tmp/ST3hTDMa' (Errcode: 27) myisamchk: error: 27 when fixing table MyISAM-table 'internet_usage.MYI' is not fixed because of errors Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag # perror 27 Error code 27: A file cannot be larger than the value set by ulimit. The ulimits are set as follows: default: fsize = 2097151 core = 2097151 cpu = -1 data = 262144 rss = 65536 stack = 65536 nofiles = 2000 root: fsize = -1 core = -1 cpu = -1 data = -1 rss = -1 stack = -1 nofiles = 4000 When I run myisamchk, is it running with root privilidges or as user mysql? By the way this is a large enabled filesystem. Thanks, JS. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help with query
Hi, I have two tables: TABLE_1 === - id - name TABLE_2 === - id - table1_id - name How could I make a select on table_1 that returns me only the rows that don´t have any reference in table_2? Any help would be appreciated. Thank´s, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help with query
SELECT `TABLE_1`.* FROM `TABLE_1` JOIN `TABLE_2` USING (`id`) WHERE `TABLE_2`.`id` IS NULL Asuming that the reference is the id field... Regards, Jigal. - Original Message - From: Ronan Lucio [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 3:12 PM Subject: Help with query Hi, I have two tables: TABLE_1 === - id - name TABLE_2 === - id - table1_id - name How could I make a select on table_1 that returns me only the rows that don´t have any reference in table_2? Any help would be appreciated. Thank´s, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] !DSPAM:417f9f13272296489013257! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
help with proper conditions and indexes needed
hi again, I have question like that: SELECT /*! SQL_BUFFER_RESULT */ DISTINCT branza.branzaid, branza.branzanazwa FROM branza, klientbranza, klientwojewodztwo WHERE branza.branzaid = klientbranza.branzaid AND klientbranza.klientid = klientwojewodztwo.klientid AND wojewodztwoid =9 ORDER BY bsort ASC and EXPLAIN SELECT /*! SQL_BUFFER_RESULT */ DISTINCT branza.branzaid, branza.branzanazwa FROM branza, klientbranza, klientwojewodztwo WHERE branza.branzaid = klientbranza.branzaid AND klientbranza.klientid = klientwojewodztwo.klientid AND wojewodztwoid =9 ORDER BY bsort ASC shows me: table type possible_keys key key_len ref rows Extra klientwojewodztwo ref kl_idx,woj_idx woj_idx 3 const 55054 Using where; Using temporary; Using filesort klientbranza ref branzaid,klientid klientid 8 klientwojewodztwo.klientid 1 branza ref id_na id_na 2 klientbranza.branzaid 1 but EXPLAIN SELECT /*! SQL_BUFFER_RESULT */ STRAIGHT_JOIN DISTINCT branza.branzaid, branza.branzanazwa FROM branza, klientbranza, klientwojewodztwo WHERE branza.branzaid = klientbranza.branzaid AND klientbranza.klientid = klientwojewodztwo.klientid AND wojewodztwoid =9 ORDER BY bsort ASC shows me: table type possible_keys key key_len ref rows Extra branza ALL id_na NULL NULL NULL 1451 Using temporary; Using filesort klientbranza ref branzaid,klientid branzaid 2 branza.branzaid 969 Distinct klientwojewodztwo ref kl_idx,woj_idx kl_idx 8 klientbranza.klientid 1 Using where; Distinct how to understand that? what should be the correct order in where clause and what indexes should be used? for this moment I have such indexes: table branza: bsort primary id_na(branzaid,branzanazwa) table klientbranza: branzaid klientid table klientwojewodztwo: klientid wojewodztwoid all these indexes are just index type [not unique or full...] how to correct interpret these explains and how to correct this? with regards DeRyl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yet another question on DECMIAL precision
Dear MySQL Support List: Way back in early 2003 two questions and answers appeared on this list and bug list RE: DECIMAL precision. See both at http://lists.mysql.com/mysql/141268 and http://bugs.mysql.com/bug.php?id=559 1) Did anyone else notice that the 'INSERT INTO' value DID NOT MATCH the 'SELECT * FROM' value in both examples? Shouldn't it truncate/round to the place it's exact (or one digit below) and not offer back bogus digits starting after the 9th decimal place? INSERT: 12345678.123456789012345678901234 SELECT: 12345678.12345678918063640594482 IMO answer should be 12345678.123456789 which is more technically correct than MySQL's answer. 2) Is MySQL doing true unpacked BCD math on the DECIMAL datatype? 3) Are there plans to pack the data in the DECIMAL datatype to save space someday? 4) This has been fixed in MySQL server 4.1, but why wasn't this caveat explicitly WELL DOCUMENTED in the documentation so developers could avoid this land mine along with the additional gotcha under Windows? Could someone please revise the documentation to make these issues clear? 5) I'm sucking data from Oracle into MySQL using Perl and would like to propose a behavior change for DECIMAL datatypes without width and precision to mimic the Oracle behavior to just store the answer/number without rounding. This may require yet another flavor of DECIMAL datatype (perhaps call it NUMBER ?) where the current DECIMAL/NUMERIC retain the SQL-92 behavior where DECIMAL by itself default to DECIMAL(10,0), but NUMBER would store the raw value as best it could. Oracle NUMBER type without parens width/precision values defaults to 22 bytes as a packed decimal. Please see http://www.ixora.com.au/notes/number_representation.htm?number=3.14159265358987354 for more info. 6) It would seem that overflow/underflow numeric data is stored as all 9's in MySQL databases. This is difficult since 999.99, for example, still looks like a valid number. I don't get a warning/error result on INSERTs/UPDATEs of out-of-range data. How do I detect out-of-range values on INSERTs/UPDATEs? 7) The article http://www.ixora.com.au/notes/number_representation.htm?number=3.14159265358987354 shows how Oracle represents +/- infinity values as special values of -~ or ~ (+/- infinity). Could MySQL provide some representation in the database for storage of this data so I can retain it from Oracle data? I've been using MySQL since version 3.2 (now in 4.0) in Windows 2000. I now realize the OS and math lib issues, but issues above should be consistent in their handling/treatment of precision. Could DECIMAL types in MySQL use a true BCD math library functions and not have (as many) rounding issues and be more precise? Perhaps these issues have been vetted somewhere else. Please redirect me if so. I love MySQL and have been using at work since October 2001 and will continue to use it. Thankfully I didn't have any data until now that REQUIRED higher precision data storage and was not adversely impacted by the precision issue, but I'd like someone at MySQL to better address these issues for all, since working with Oracle and Oracle data is still a fact of life for some of us. Thanks, Larry Hixson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Monkeys and Banannas (UPDATE .. JOIN .. SET .. GROUP)
Yes, good keys are crucial but I try to avoid them when demonstrating temp tables (I think it blurs the issue). All you need to do to have keys on a temp table is to either add the KEY() definitions to your CREATE TEMPORARY TABLE statements like this: CREATE TEMPORARY TABLE tmpCount1(KEY(name)) SELECT name, count(1) fq from table1 WHERE (conditions) GROUP BY name; CREATE TEMPORARY TABLE tmpCount2(KEY(name)) SELECT name, count(1) fq from table2 WHERE (conditions) GROUP BY name; (notice that I use one of the column names that will result from the SELECT clause. I could have also said KEY(fq) as fq is one of the columns created in the new table) OR add them to the tables after you create them like this: ALTER TABLE tmpCount1 ADD KEY(name); ALTER TABLE tmpCount2 ADD KEY(name); Either way you wind up with indexed temporary tables. Your queries should fly, now. I'm just glad I could help!! 8-D Shawn Green Database Administrator Unimin Corporation - Spruce Pine Søren Ragsdale [EMAIL PROTECTED] wrote on 10/26/2004 05:38:21 PM: I'm wondering about something: the TEMPORARY TABLEs we're generating here do not have any keys or indexes on them. My EXPLAIN is complaining that it can't use any keys in the INNER JOIN. Is this a problem? Should I be creating TEMPORARY TABLES with keys? Thanks very much for your help - I've finally gotten the hang of temporary tables and they're a big help. On Oct 12, 2004, at 10:34 AM, [EMAIL PROTECTED] wrote: Good, you recognize the need to perform two separate aggregates (GROUP BYs) and compare the separate results... In fact, you may need two temp tables so that you can (INNER / LEFT) JOIN one to the other. (Yes, I can think of a query that works without the second temp table but I think it's kludgey and would rather not post it.) To find same name and count CREATE TEMPORARY TABLE tmpCount1 SELECT name, count(1) fq from table1 WHERE (conditions) GROUP BY name; CREATE TEMPORARY TABLE tmpCount2 SELECT name, count(1) fq from table2 WHERE (conditions) GROUP BY name; SELECT t1.name FROM tmpCount1 t1 INNER JOIN tmpCount2 t2 on t1.name = t2.name and t1.fq = t2.fq; DROP TEMPORARY TABLE tmpCount1, tmpCount2; To find where table2 has MORE than table1 SELECT t2.name FROM tmpCount2 t2 INNER JOIN tmpCount1 t1 on t1.name = t2.name WHERE t1.fq t2.fq; Does this help in a general way? Shawn Green Database Administrator Unimin Corporation - Spruce Pine Laszlo Thoth [EMAIL PROTECTED] wrote on 10/12/2004 01:18:39 PM: Quoting [EMAIL PROTECTED]: Why would you want to do that? bananacount is something you can calculate with a LEFT JOIN and a GROUP BY, so storing it in the DB would break normalization. This would also the first step in creating your own OLAP cube. For each statistic, you save yourself a lot of time if you compute the results of several GROUP BY functions (SUM, AVG, STD, etc) and store those results into intermediate tables. Then when you want to start slicing and dicing your data, you do more retrieval and less computations. This seriously improves the performance of your reports. Each new record inserted into your cube would require you to update every computed statistics table that covered your new record. But that *is* the trade off, isn't it? Much faster analysis for much slower transaction performance. Thus the basic difference between OLAP and OLTP. This is closer to the reason why I'm trying to do this. Obviously this is an example: I'm not actually tracking real monkeys and real banannas with mysql. (Sorry if this disappoints anyone!) In my actual application I'm doing a JOIN between this table and another one with a GROUP BY (a very differentcriteria) and a HAVING clause which selects only members from this other tablewhich have as many elements in this second grouping as appeared in the first grouping. So basically I'm trying to compare the results of two different GROUP BY statements with a HAVING clause and I'm pretty sure I can't do it all within one statement, so I'm caching the results of one of the GROUPs as a value in one of the tables. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help with query
This is a very FAQ: SELECT t1.* FROM TABLE_1 t1 LEFT JOIN TABLE_2 t2 ON t1.id = t2.table1_id WHERE t2.id is null Shawn Green Database Administrator Unimin Corporation - Spruce Pine Ronan Lucio [EMAIL PROTECTED] wrote on 10/27/2004 10:12:42 AM: Hi, I have two tables: TABLE_1 === - id - name TABLE_2 === - id - table1_id - name How could I make a select on table_1 that returns me only the rows that don´t have any reference in table_2? Any help would be appreciated. Thank´s, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help with query
Shawn, Thank you very for your answer. Actually, I thought that a main SELECT couldn´t be filtered by the WHERE clause refered to a field in a LEFT JOIN. Now, looking better in the JOIN documentation I see this issue. Thank´s, Ronan This is a very FAQ: SELECT t1.* FROM TABLE_1 t1 LEFT JOIN TABLE_2 t2 ON t1.id = t2.table1_id WHERE t2.id is null Shawn Green Database Administrator Unimin Corporation - Spruce Pine Ronan Lucio [EMAIL PROTECTED] wrote on 10/27/2004 10:12:42 AM: Hi, I have two tables: TABLE_1 === - id - name TABLE_2 === - id - table1_id - name How could I make a select on table_1 that returns me only the rows that don´t have any reference in table_2? Any help would be appreciated. Thank´s, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Yet another question on DECMIAL precision
Lawrence K. Hixson wrote: 4) This has been fixed in MySQL server 4.1, but why wasn't this caveat explicitly WELL DOCUMENTED in the documentation so developers could avoid this land mine along with the additional gotcha under Windows? Could someone please revise the documentation to make these issues clear? Oops! I meant to say that Heikki Tuuri said it was fixed but the fact it stored an inaccurate number means IT'S NOT FIXED and this is still the current behavior with 4.1 gamma. I will update to the new general release soon and retest. Will someone else please take a look at this again? I think it's still a problem. Larry Hixson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with proper conditions and indexes needed
I really hate to do this to you but if I tried to answer your questions I would be copying from the book anyway. There is a section in the manual that deals specifically with query optimization. It covers index creation and usage, when an order by will and won't use and index and a bunch of other topics. Please review this material and come back to us if you need help understanding anything there. We will all happily do our best to make sense of whatever you are still having problems with. http://dev.mysql.com/doc/mysql/en/MySQL_Optimization.html Respectfully, Shawn Green Database Administrator Unimin Corporation - Spruce Pine DeRyl [EMAIL PROTECTED] wrote on 10/27/2004 09:31:58 AM: hi again, I have question like that: SELECT /*! SQL_BUFFER_RESULT */ DISTINCT branza.branzaid, branza.branzanazwa FROM branza, klientbranza, klientwojewodztwo WHERE branza.branzaid = klientbranza.branzaid AND klientbranza.klientid = klientwojewodztwo.klientid AND wojewodztwoid =9 ORDER BY bsort ASC and EXPLAIN SELECT /*! SQL_BUFFER_RESULT */ DISTINCT branza.branzaid, branza.branzanazwa FROM branza, klientbranza, klientwojewodztwo WHERE branza.branzaid = klientbranza.branzaid AND klientbranza.klientid = klientwojewodztwo.klientid AND wojewodztwoid =9 ORDER BY bsort ASC shows me: table type possible_keys key key_len ref rows Extra klientwojewodztwo ref kl_idx,woj_idx woj_idx 3 const 55054 Using where; Using temporary; Using filesort klientbranza ref branzaid,klientid klientid 8 klientwojewodztwo.klientid 1 branza ref id_na id_na 2 klientbranza.branzaid 1 but EXPLAIN SELECT /*! SQL_BUFFER_RESULT */ STRAIGHT_JOIN DISTINCT branza.branzaid, branza.branzanazwa FROM branza, klientbranza, klientwojewodztwo WHERE branza.branzaid = klientbranza.branzaid AND klientbranza.klientid = klientwojewodztwo.klientid AND wojewodztwoid =9 ORDER BY bsort ASC shows me: table type possible_keys key key_len ref rows Extra branza ALL id_na NULL NULL NULL 1451 Using temporary; Using filesort klientbranza ref branzaid,klientid branzaid 2 branza.branzaid 969 Distinct klientwojewodztwo ref kl_idx,woj_idx kl_idx 8 klientbranza.klientid 1 Using where; Distinct how to understand that? what should be the correct order in where clause and what indexes should be used? for this moment I have such indexes: table branza: bsort primary id_na(branzaid,branzanazwa) table klientbranza: branzaid klientid table klientwojewodztwo: klientid wojewodztwoid all these indexes are just index type [not unique or full...] how to correct interpret these explains and how to correct this? with regards DeRyl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with proper conditions and indexes needed
I'm really sorry wasting your time but... but - at first I read all materials I found [including this chapter you suggested] I can't correct interpret these explains I described - I've tried to change the order in where clause, making different indexes but see no changes and no correction so I think I don't understand that and I decided to write to the list with respect DeRyl - Original Message - From: [EMAIL PROTECTED] To: DeRyl [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 3:53 PM Subject: Re: help with proper conditions and indexes needed I really hate to do this to you but if I tried to answer your questions I would be copying from the book anyway. There is a section in the manual that deals specifically with query optimization. It covers index creation and usage, when an order by will and won't use and index and a bunch of other topics. Please review this material and come back to us if you need help understanding anything there. We will all happily do our best to make sense of whatever you are still having problems with. http://dev.mysql.com/doc/mysql/en/MySQL_Optimization.html Respectfully, Shawn Green Database Administrator Unimin Corporation - Spruce Pine DeRyl [EMAIL PROTECTED] wrote on 10/27/2004 09:31:58 AM: hi again, I have question like that: SELECT /*! SQL_BUFFER_RESULT */ DISTINCT branza.branzaid, branza.branzanazwa FROM branza, klientbranza, klientwojewodztwo WHERE branza.branzaid = klientbranza.branzaid AND klientbranza.klientid = klientwojewodztwo.klientid AND wojewodztwoid =9 ORDER BY bsort ASC and EXPLAIN SELECT /*! SQL_BUFFER_RESULT */ DISTINCT branza.branzaid, branza.branzanazwa FROM branza, klientbranza, klientwojewodztwo WHERE branza.branzaid = klientbranza.branzaid AND klientbranza.klientid = klientwojewodztwo.klientid AND wojewodztwoid =9 ORDER BY bsort ASC shows me: table type possible_keys key key_len ref rows Extra klientwojewodztwo ref kl_idx,woj_idx woj_idx 3 const 55054 Using where; Using temporary; Using filesort klientbranza ref branzaid,klientid klientid 8 klientwojewodztwo.klientid 1 branza ref id_na id_na 2 klientbranza.branzaid 1 but EXPLAIN SELECT /*! SQL_BUFFER_RESULT */ STRAIGHT_JOIN DISTINCT branza.branzaid, branza.branzanazwa FROM branza, klientbranza, klientwojewodztwo WHERE branza.branzaid = klientbranza.branzaid AND klientbranza.klientid = klientwojewodztwo.klientid AND wojewodztwoid =9 ORDER BY bsort ASC shows me: table type possible_keys key key_len ref rows Extra branza ALL id_na NULL NULL NULL 1451 Using temporary; Using filesort klientbranza ref branzaid,klientid branzaid 2 branza.branzaid 969 Distinct klientwojewodztwo ref kl_idx,woj_idx kl_idx 8 klientbranza.klientid 1 Using where; Distinct how to understand that? what should be the correct order in where clause and what indexes should be used? for this moment I have such indexes: table branza: bsort primary id_na(branzaid,branzanazwa) table klientbranza: branzaid klientid table klientwojewodztwo: klientid wojewodztwoid all these indexes are just index type [not unique or full...] how to correct interpret these explains and how to correct this? with regards DeRyl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where is 4.1.7 max 32 bit binary for Solaris?
Is there any plan to release a 32-bit binary 4.1.7 MySQL max for Solaris 9 and Solaris 8? I see all the other binaries for Solaris for everything - any reason to exclude the 32 bit? Thx, R
phpMyAdmin and MySQL 4.1
Greetings After installing the new release of MySQL ( i.e. MySQL 4.1), I know get the following error from phpMyAdmin when using any of the auth types: Error #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client. I get this whether I am using cconfig, http or cookie based authentication. Any ideas why this is happening? Is there a config setting in MySQL I should set to support the protocol? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Design.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Full-Text Search
1. The manual says there is and it gives an example, but I haven't been able to get it to work and neither have other people on this list. If you look at the planned improvements of MySQL, a few of the major items have to do with full text searching. On Oct 26, 2004, at 7:39 PM, Jalil Feghhi wrote: Brent, Thanks for the reply. 1. Is there any way to sort the boolean full-text search results in orther of relevance as in non-bolean mode? I think it is very important. 2. Yes, that is what I meant. You are right. I look into grep. Thanks, -Jalil -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 6:30 AM To: Jalil Feghhi Cc: [EMAIL PROTECTED] Subject: Re: Full-Text Search 1. The rows are sorted in the same order as any other query that doesn't have and order by specified, which means usually in the order they were entered. 2. When you mean location of matches, do you mean something like highlighting? That's the responsibility of the interface, not the database. Remember, MySQL is really just a database engine. It will find your data fast, but it's up to you to present it in a nice format. But, highlighting is fairly easy using grep, which is available in just about any front end you may be using (Perl, Shell, PHP, etc.). On Oct 25, 2004, at 8:37 PM, Jalil Feghhi wrote: In the MySQL documentation, it says that: Boolean full-text searches have these characteristics: * They do not use the 50% threshold. * They do not automatically sort rows in order of decreasing relevance. You can see this from the preceding query result: The row with the highest relevance is the one that contains ``MySQL'' twice, but it is listed last, not first. * They can work even without a FULLTEXT index, although this would be slow. * The minimum and maximum word length full-text parameters apply. * The stopword list applies. I had two questions: 1. How are the returned rows sorted in the boolean full-text searches? 2. Is there any way to get more information (other than the score) from MySQL? For example, can we find out the location of matches? Regards, -Jalil -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin and MySQL 4.1
You need to get caught up on your reading. The password hash changed as of 4.1 and this behavior is well documented. Start here: http://dev.mysql.com/doc/mysql/en/Problems.html and if you have more questions read this http://dev.mysql.com/doc/mysql/en/Password_hashing.html What it boils down to is that you are using pre-4.1 clients (phpMyAdmin is a MySQL client) with a 4.1+ server. Several workaround are in the reading I just gave you. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Schalk Neethling [EMAIL PROTECTED] wrote on 10/27/2004 10:26:09 AM: Greetings After installing the new release of MySQL ( i.e. MySQL 4.1), I know get the following error from phpMyAdmin when using any of the auth types: Error #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client. I get this whether I am using cconfig, http or cookie based authentication. Any ideas why this is happening? Is there a config setting in MySQL I should set to support the protocol? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Design.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Querying on subsets of one-to-many and many-to-many
If the query is applied to a duplicates free set of data and making nolinks 0, it does indeed deliver the expected results. Since the counters are not reused, they can even be used textually in the HAVING clause which doesn't add any extra columns to the final result set. Two things through. First of all, the HAVING clause doesn't use any indexes even though it works with integers which should be pretty fast but I'll mention this later. The second is that I may have over simplified things in my previous email. This type of filter is applied to a query that already has several LEFT and INNER joins applied to it that in turn do not guarantee in any way the uniqueness of one row from the original table. Certain rows from the original table may be duplicated at the moment when this filter is applied so this type of counters is no longer reliable. I came up with a query that looks something like this: select A.* from A left join L using (PK_A) group by A.PK_A having isnull(L.PK_A) or ( sum(L.PK_B = 3) and sum(L.PK_B = 4) and !sum(L.PK_B in (2)) ) This query if I'm not mistaken basically does the same thing without returning extra columns and guaranteeing a correct result set even when duplicates are encountered. I haven't tested this on large data sets yet but the only penalty should come from using the HAVING clause. In this particular case this only implies working on simple booleans and integers but since I'm not familiar with the internals of MySQL, I'm not sure if this constitutes a significant work load given the data figures I mentioned previously. Originally, I also thought of doing this using user variables but I figured that would have required ordering the initial data set according to some predefined criteria which wouldn't have left any possibility of ordering the results according to however I eventually wanted them. Daniel - Original Message - From: [EMAIL PROTECTED] To: Daniel BODEA [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 6:41 PM Subject: Re: Querying on subsets of one-to-many and many-to-many OK, now that I have a better model to work with, let me try again. (And stop being so discouraged! This is hard for everyone until they get the hang of it!!! =8-D ) Given a query that resembles this select * from A where (no links) or ((links to both 3 and 4) and (no links to 2)) This may not be the only way to do this but it's what I thought of first SELECT A.PK_A, A.DATA_A, sum(isnull(L.PK_A)) as nolinks, sum(if(L.PK_B IN (3,4),1,0)) as wanted, sum(if(L.PK_B = 2,1,0)) as rejects FROM A LEFT JOIN L on L.PK_A = A.PK_A GROUP BY 1,2 HAVING nolinks =0 or (wanted = 2 and rejects=0); This returns three more columns that you originally wanted but it's still a one-trip query. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Daniel BODEA [EMAIL PROTECTED] wrote on 10/26/2004 11:55:34 AM: Many thanks for the quick answer. I apologize for leaving out a few details that should have explained the context in greater detail. I'll use less theory below to further explain what's going on and then I'll make some remarks on your answer. Simplified down to the basics of this problem, we have two tables, A and B, both having the same structure: PK_A / PK_B - primary key DATA_A / DATA_B - text Then we have table L with two columns: PK_A - 0..n of primary key for table A PK_B - 0..n of primary key for table B Both A and B contain 3 rows with PKs 1, 2, 3. Data is not an issue. L contains the following mappings: PK_A | PK_B 1 | 3 1 | 4 2 | 2 2 | 3 2 | 4 Given a query that resembles this select * from A where (no links) or ((links to both 3 and 4) and (no links to 2)), we should be able to work (order, limit, etc.) on records 1 and 3 from A. The PKs that the WHERE clause works on are those of B not A. I also thought at first that a sequence of LEFT and INNER joins would both filter the results correctly and work fast enough for this kind of data but two days of joining stuff didn't make it happen and frankly I don't think there is any one query solution. In your first example you filter on PK_A which is my mistake because the selection is actually made on PK_B. I apologize for not making this clearer. Using PK_B in your example though is the first trap I fell into during those joining days. Whatever your conditions in the WHERE clause, you only apply them to one row at a time which means the relevant part of the query is translated into this where PK_A has links to any of PK_B in (3, 4). The NOT IN part has no effect since the row 2 | 2 is excluded but the other two get through. Disregarding PK_A in the WHERE clause and using PK_B instead in the second example, I believe first of all the INNER JOIN filters out all rows that don't have any links
Re: html links inside varchar and text fields
Just put the href into the database. When you output it to html in PHP wrap it wth the rest. $href=$sql-data['href']; echo a href=\ . $href . \The Link/a\n; leegold wrote: I have to put html links inside varchar and text fields. They have to be (somehow) fulltext searchable (of course a substring, %keyword% search, would pick them up - I realize that) and they have to render as clickable links when I output the fields via PHP. How would I do this? Is this more of a PHP level type problem? Thanks, Lee G. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication Issue
I have mysql master and mysql slave on same machine running separately. I have master and slave setup. I was able to do the LOAD DATA FROM MASTER; to get the data but the data does not replicate after that. Looking at the info below can you tell why replication is not taking place. Can I provide you with any other information? Thanks! Randy Here is output from Show Slave Status \G mysql show slave status \G *** 1. row *** Slave_IO_State: Waiting for master to send event Master_Host: localhost Master_User: repuser Master_Port: 3306 Connect_Retry: 10 Master_Log_File: www-bin.001 Read_Master_Log_Pos: 7413 Relay_Log_File: www-relay-bin.02 Relay_Log_Pos: 8092 Relay_Master_Log_File: www-bin.001 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 7413 Relay_Log_Space: 8092 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: OS is redhat e 2.1 Master 3.23.58 -- [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-bin server-id = 1 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Slave 5.0.1-alpha-standard # Example MySQL config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # an important part, or systems up to 128M where MySQL is used together with # other programs (such as a web server) # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data) or # ~/.my.cnf to set user-specific options. # # In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port= 3310 socket = /tmp/mysql5.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3310 socket = /tmp/mysql5.sock datadir = /usr/local/mysql5/data skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M server-id = 2 [mysql.server] user = mysql basedir = /usr/local/mysql5 [safe_mysqld] err-log = /usr/local/mysql5/error.log datadir = /usr/local/mysql5/data pid-file = /var/run/mysqld/mysqld5.pid # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (via the enable-named-pipe option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication log-bin # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 2 # Replication Slave (comment out master section to use this) # # To configure this host as a replication slave, you can choose between # two methods : # # 1) Use the CHANGE MASTER TO command (fully described in our manual) - #the syntax is: # #CHANGE MASTER TO MASTER_HOST=host, MASTER_PORT=port, #MASTER_USER=user, MASTER_PASSWORD=password ; # #where you replace host, user, password by quoted strings and #port by the master's port number (3306 by default). # #Example: # #CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, #MASTER_USER='joe', MASTER_PASSWORD='secret'; # # OR # # 2) Set the variables below. However, in case you choose this method, then #start replication for the first time (even unsuccessfully, for example #if you mistyped the password in master-password and the slave fails to #connect), the slave will create a master.info file, and any later #change in this file to the variables' values below will be ignored and #overridden by the content of the master.info file, unless
Re: html links inside varchar and text fields
Hi. When you output field data inside html pages, browser can interpret the tags inside fields (hackers usually use such things). Try to use htmlentities() and htmlspecialchars() to escape all '' and '' chars in data. Regards. leegold [EMAIL PROTECTED] wrote: I have to put html links inside varchar and text fields. They have to be (somehow) fulltext searchable (of course a substring, %keyword% search, would pick them up - I realize that) and they have to render as clickable links when I output the fields via PHP. How would I do this? Is this more of a PHP level type problem? Thanks, Lee G. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin and MySQL 4.1
Op woensdag 27 oktober 2004 16:52, schreef [EMAIL PROTECTED]: I had the same problem on my Linux suse 9.1 box. I was using a mysql client/server that came with my distro. Got the same error as you trying to connect with phpmyadmin, while I was sure to have installed the proper client (4.1) via rpm (and deleted the 4.0 one). I also read the passw hashing documentation and followed their instructions, with no result. After a while I was getting sick of all the new errors (probably due to myself ;), so I decided to start over from scratch. At the same time I could upgrade to php5 and Apache 2.0 What I did: - deleting all mysql stuff through my package manager (Yast for SUSE) - deleting my apache webserver - deleting PHP4.3 Afterwards: - installed mysql 4.1 client, server and shared rpm's - compiled apache - compiled php5 And I was having the latest lamp working. Phpmyadmin runs without problems Notes: - this was on my development machine - I'm not pushing mysql to the end when I use it (in a basic way) - maybe not the nicest solution, but digging 2 days through documentation isn't nice either. - I got my lamp working in less then 2 hours. Rik You need to get caught up on your reading. The password hash changed as of 4.1 and this behavior is well documented. Start here: http://dev.mysql.com/doc/mysql/en/Problems.html and if you have more questions read this http://dev.mysql.com/doc/mysql/en/Password_hashing.html What it boils down to is that you are using pre-4.1 clients (phpMyAdmin is a MySQL client) with a 4.1+ server. Several workaround are in the reading I just gave you. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Schalk Neethling [EMAIL PROTECTED] wrote on 10/27/2004 10:26:09 AM: Greetings After installing the new release of MySQL ( i.e. MySQL 4.1), I know get the following error from phpMyAdmin when using any of the auth types: Error #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client. I get this whether I am using cconfig, http or cookie based authentication. Any ideas why this is happening? Is there a config setting in MySQL I should set to support the protocol? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Design.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Yet another question on DECMIAL precision
Hi. Thank you for the message, I've sent your report to docs team. 5) I'm sucking data from Oracle into MySQL using Perl and would like to propose a behavior change for DECIMAL ... 7) The article http://www.ixora.com.au/notes/number_representation.htm?number=3.14159265358987354 shows how Oracle represents +/- infinity values as special MySQL is moving towards SQL99, and if it is a part of SQL99 standard, that probably will be implemented. 6) It would seem that overflow/underflow numeric data is stored as all 9's in MySQL databases. This is difficult I think, you should see: http://dev.mysql.com/doc/mysql/en/Problems_with_float.html Lawrence K. Hixson [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: us-ascii, 80 lines --] Dear MySQL Support List: Way back in early 2003 two questions and answers appeared on this list and bug list RE: DECIMAL precision. See both at http://lists.mysql.com/mysql/141268 and http://bugs.mysql.com/bug.php?id=559 1) Did anyone else notice that the 'INSERT INTO' value DID NOT MATCH the 'SELECT * FROM' value in both examples? Shouldn't it truncate/round to the place it's exact (or one digit below) and not offer back bogus digits starting after the 9th decimal place? INSERT: 12345678.123456789012345678901234 SELECT: 12345678.12345678918063640594482 IMO answer should be 12345678.123456789 which is more technically correct than MySQL's answer. 2) Is MySQL doing true unpacked BCD math on the DECIMAL datatype? 3) Are there plans to pack the data in the DECIMAL datatype to save space someday? 4) This has been fixed in MySQL server 4.1, but why wasn't this caveat explicitly WELL DOCUMENTED in the documentation so developers could avoid this land mine along with the additional gotcha under Windows? Could someone please revise the documentation to make these issues clear? 5) I'm sucking data from Oracle into MySQL using Perl and would like to propose a behavior change for DECIMAL datatypes without width and precision to mimic the Oracle behavior to just store the answer/number without rounding. This may require yet another flavor of DECIMAL datatype (perhaps call it NUMBER ?) where the current DECIMAL/NUMERIC retain the SQL-92 behavior where DECIMAL by itself default to DECIMAL(10,0), but NUMBER would store the raw value as best it could. Oracle NUMBER type without parens width/precision values defaults to 22 bytes as a packed decimal. Please see http://www.ixora.com.au/notes/number_representation.htm?number=3.14159265358987354 for more info. 6) It would seem that overflow/underflow numeric data is stored as all 9's in MySQL databases. This is difficult since 999.99, for example, still looks like a valid number. I don't get a warning/error result on INSERTs/UPDATEs of out-of-range data. How do I detect out-of-range values on INSERTs/UPDATEs? 7) The article http://www.ixora.com.au/notes/number_representation.htm?number=3.14159265358987354 shows how Oracle represents +/- infinity values as special values of -~ or ~ (+/- infinity). Could MySQL provide some representation in the database for storage of this data so I can retain it from Oracle data? I've been using MySQL since version 3.2 (now in 4.0) in Windows 2000. I now realize the OS and math lib issues, but issues above should be consistent in their handling/treatment of precision. Could DECIMAL types in MySQL use a true BCD math library functions and not have (as many) rounding issues and be more precise? Perhaps these issues have been vetted somewhere else. Please redirect me if so. I love MySQL and have been using at work since October 2001 and will continue to use it. Thankfully I didn't have any data until now that REQUIRED higher precision data storage and was not adversely impacted by the precision issue, but I'd like someone at MySQL to better address these issues for all, since working with Oracle and Oracle data is still a fact of life for some of us. Thanks, Larry Hixson [-- text/plain, encoding 7bit, charset: us-ascii, 4 lines --] -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin and MySQL 4.1
Hi. See: http://www.phpmyadmin.net/documentation/#faqmysqlversions Regards. Schalk Neethling [EMAIL PROTECTED] wrote: Greetings After installing the new release of MySQL ( i.e. MySQL 4.1), I know get the following error from phpMyAdmin when using any of the auth types: Error #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client. I get this whether I am using cconfig, http or cookie based authentication. Any ideas why this is happening? Is there a config setting in MySQL I should set to support the protocol? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple SQL Question
Anybody? Jeff Burgoon [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sorry, I forgot to mention I am using version 4.0.20a (no subqueries supported) Jeff Burgoon [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I have a simple problem and I'm just wondering the BEST query to solve it. I want to return all the rows of a table whose foreign key value exists more than once in that table. IE... MyTable Region(foreign key)City EastBaltimore EastPhilly EastNewark MidwestCleveland SouthFort Lauderdale West Phoenix WestLos Angeles I want a query that returns only the rows where there are more than one of that particular Region in MyTable. The values returned would be EastBaltimore EastPhilly EastNewark WestPhoenix WestLos Angeles Here is what I'd like to do (but can't because the current stable build of MySQL doesn't support subqueries) SELECT MyTable.* FROM (SELECT Region, Count(*) as cnt FROM MyTable GROUP BY Region HAVING cnt = 2) as Duplicates, MyTable WHERE Duplicates.Region = MyTable.Region Here is what I'm actually doing: CREATE TEMPORARY TABLE Duplicates SELECT Region, Count(*) as cnt FROM MyTable GROUP BY Region HAVING cnt = 2; SELECT MyTable.* FROM MyTable, Duplicates WHERE MyTable.Region = Duplicates.Region; Can anybody tell me if there is a more efficient way of doing this query? Thanks! Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql 3.23 store large data
What type I should use in MySQL 3.23.58 to store large data file? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication Issue
Randy Johnson [EMAIL PROTECTED] wrote: I have mysql master and mysql slave on same machine running separately. I have master and slave setup. I was able to do the LOAD DATA FROM MASTER; to get the data but the data does not replicate after that. =20 Looking at the info below can you tell why replication is not taking = place. Can I provide you with any other information? Look in the tail of .err file, which may contain some clue info. Are you sure that replication slave is running? See http://dev.mysql.com/doc/mysql/en/Replication.html, most issues are covered there. -- -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Replication Issue
Here is what is in the error log: looks awful How do I determine if slave is running correctly. I though show Slave status \G did this... 041026 0:19:44 Slave I/O thread killed while reading event 041026 0:19:44 Slave I/O thread exiting, read up to log 'www-bin.001', position 5685 041026 0:19:44 Error reading relay log event: slave SQL thread was killed 041026 0:20:09 Couldn't fix table with quick recovery: Found wrong number of deleted records 041026 0:20:09 Run recovery again without -q 041026 0:20:09 Note: Retrying repair of: './dotproject/user_tasks' with keycache 041026 0:20:09 Couldn't fix table with quick recovery: Found wrong number of deleted records 041026 0:20:09 Run recovery again without -q 041026 0:20:09 Note: Retrying repair of: './openreports/REPORT' with keycache 041026 0:20:09 Delete link points outside datafile at 180 041026 0:20:09 Note: Retrying repair of: './openreports/REPORT_CHART' with keycache 041026 0:20:09 Delete link points outside datafile at 180 041026 0:20:10 Couldn't fix table with quick recovery: Found wrong number of deleted records 041026 0:20:10 Run recovery again without -q 041026 0:20:10 Note: Retrying repair of: './psa/ClientsTraffic' with keycache 041026 0:20:10 Couldn't fix table with quick recovery: Found wrong number of deleted records 041026 0:20:10 Run recovery again without -q 041026 0:20:10 Note: Retrying repair of: './psa/DomainsTraffic' with keycache 041026 0:20:10 Couldn't fix table with quick recovery: Found wrong number of deleted records 041026 0:20:10 Run recovery again without -q 041026 0:20:10 Note: Retrying repair of: './psa/IP_Addresses' with keycache 041026 0:20:11 Couldn't fix table with quick recovery: Found wrong number of deleted records 041026 0:20:11 Run recovery again without -q 041026 0:20:11 Note: Retrying repair of: './psa/data_bases' with keycache 041026 0:20:11 Delete link points outside datafile at 136 041026 0:20:11 Note: Retrying repair of: './psa/domains' with keycache 041026 0:20:11 Delete link points outside datafile at 136 041026 0:20:11 Delete link points outside datafile at 0 041026 0:20:11 Note: Retrying repair of: './psa/lockout' with keycache 041026 0:20:11 Delete link points outside datafile at 0 041026 0:20:11 Delete link points outside datafile at 0 041026 0:20:11 Note: Retrying repair of: './psa/log_actions' with keycache 041026 0:20:11 Delete link points outside datafile at 0 041026 0:20:11 Delete link points outside datafile at 4700 041026 0:20:11 Delete link points outside datafile at 0 041026 0:20:11 Note: Retrying repair of: './psa/log_components' with keycache 041026 0:20:11 Delete link points outside datafile at 0 041026 0:20:11 Delete link points outside datafile at 4112 041026 0:20:11 Delete link points outside datafile at 0 041026 0:20:11 Note: Retrying repair of: './psa/mail_redir' with keycache 041026 0:20:11 Delete link points outside datafile at 0 041026 0:20:11 Delete link points outside datafile at 0 041026 0:20:11 Note: Retrying repair of: './psa/sessions' with keycache 041026 0:20:11 Delete link points outside datafile at 0 041026 0:20:12 Couldn't fix table with quick recovery: Found wrong number of deleted records 041026 0:20:12 Run recovery again without -q 041026 0:20:12 Note: Retrying repair of: './psa/smtp_poplocks' with keycache 041026 0:20:12 Delete link points outside datafile at 480 041026 0:20:12 Note: Retrying repair of: './psa/sys_users' with keycache 041026 0:20:12 Delete link points outside datafile at 480 041026 0:20:12 Couldn't fix table with quick recovery: Found wrong number of deleted records 041026 0:20:12 Run recovery again without -q 041026 0:20:12 Note: Retrying repair of: './psa/web_users' with keycache 041026 0:20:13 Delete link points outside datafile at 0 041026 0:20:13 Note: Retrying repair of: './winklink/msg_sent' with keycache 041026 0:20:13 Delete link points outside datafile at 0 041026 0:20:20 Slave SQL thread initialized, starting replication in log 'www-bin.001' at position 4, relay log './www-relay-bin.01' position: 4 041026 0:20:20 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'www-bin.001' at position 4 [EMAIL PROTECTED] mysql5]# -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 12:21 PM To: [EMAIL PROTECTED] Subject: Re: Replication Issue Randy Johnson [EMAIL PROTECTED] wrote: I have mysql master and mysql slave on same machine running separately. I have master and slave setup. I was able to do the LOAD DATA FROM MASTER; to get the data but the data does not replicate after that. =20 Looking at the info below can you tell why replication is not taking = place. Can I provide you with any other information? Look in the tail of .err file, which may contain some clue info. Are you sure that replication
Re: Simple SQL Question
[snip] Anybody? I have a simple problem and I'm just wondering the BEST query to solve it. I want to return all the rows of a table whose foreign key value exists more than once in that table. IE... MyTable Region(foreign key)City EastBaltimore EastPhilly EastNewark MidwestCleveland SouthFort Lauderdale West Phoenix WestLos Angeles I want a query that returns only the rows where there are more than one of that particular Region in MyTable. The values returned would be EastBaltimore EastPhilly EastNewark WestPhoenix WestLos Angeles There is no good way to get this in a single query (w/o subqueries). Having applied all sorts of query mangling you would have to be able to carry forward some sort of count or variable in order to draw out the ones where the foreign key was 1. Grouping by the city does not work either as that reduces any count to a one for that record. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Replication Issue
Does this table say that mysql 3.23.33 and up is not compatible to replicate to a mysql 5.0 slave? Thanks! Randy -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 12:21 PM To: [EMAIL PROTECTED] Subject: Re: Replication Issue Randy Johnson [EMAIL PROTECTED] wrote: I have mysql master and mysql slave on same machine running separately. I have master and slave setup. I was able to do the LOAD DATA FROM MASTER; to get the data but the data does not replicate after that. =20 Looking at the info below can you tell why replication is not taking = place. Can I provide you with any other information? Look in the tail of .err file, which may contain some clue info. Are you sure that replication slave is running? See http://dev.mysql.com/doc/mysql/en/Replication.html, most issues are covered there. -- -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Replication Issue
Here is the url sorry: http://dev.mysql.com/doc/mysql/en/Replication_Compatibility.html -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 2:07 PM To: [EMAIL PROTECTED] Subject: RE: Replication Issue Does this table say that mysql 3.23.33 and up is not compatible to replicate to a mysql 5.0 slave? Thanks! Randy -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 12:21 PM To: [EMAIL PROTECTED] Subject: Re: Replication Issue Randy Johnson [EMAIL PROTECTED] wrote: I have mysql master and mysql slave on same machine running separately. I have master and slave setup. I was able to do the LOAD DATA FROM MASTER; to get the data but the data does not replicate after that. =20 Looking at the info below can you tell why replication is not taking = place. Can I provide you with any other information? Look in the tail of .err file, which may contain some clue info. Are you sure that replication slave is running? See http://dev.mysql.com/doc/mysql/en/Replication.html, most issues are covered there. -- -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple SQL Question
What about select distinct a.region, a.city from mytable a , mytable b where a.region=b.region and a.city b.city Jay Blanchard wrote: [snip] Anybody? I have a simple problem and I'm just wondering the BEST query to solve it. I want to return all the rows of a table whose foreign key value exists more than once in that table. IE... MyTable Region(foreign key)City EastBaltimore EastPhilly EastNewark MidwestCleveland SouthFort Lauderdale West Phoenix WestLos Angeles I want a query that returns only the rows where there are more than one of that particular Region in MyTable. The values returned would be EastBaltimore EastPhilly EastNewark WestPhoenix WestLos Angeles There is no good way to get this in a single query (w/o subqueries). Having applied all sorts of query mangling you would have to be able to carry forward some sort of count or variable in order to draw out the ones where the foreign key was 1. Grouping by the city does not work either as that reduces any count to a one for that record. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple SQL Question
[snip] What about select distinct a.region, a.city from mytable a , mytable b where a.region=b.region and a.city b.city [/snip] Crud! Standing too close to the forest and forgot about a self join... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple SQL Question
Good one. I don't know how I missed this either! Thanks! gerald_clark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What about select distinct a.region, a.city from mytable a , mytable b where a.region=b.region and a.city b.city Jay Blanchard wrote: [snip] Anybody? I have a simple problem and I'm just wondering the BEST query to solve it. I want to return all the rows of a table whose foreign key value exists more than once in that table. IE... MyTable Region(foreign key)City EastBaltimore EastPhilly EastNewark MidwestCleveland SouthFort Lauderdale West Phoenix WestLos Angeles I want a query that returns only the rows where there are more than one of that particular Region in MyTable. The values returned would be EastBaltimore EastPhilly EastNewark WestPhoenix WestLos Angeles There is no good way to get this in a single query (w/o subqueries). Having applied all sorts of query mangling you would have to be able to carry forward some sort of count or variable in order to draw out the ones where the foreign key was 1. Grouping by the city does not work either as that reduces any count to a one for that record. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication Issue
Randy Johnson wrote: Here is the url sorry: http://dev.mysql.com/doc/mysql/en/Replication_Compatibility.html Does this table say that mysql 3.23.33 and up is not compatible to replicate to a mysql 5.0 slave? Yes Friedhelm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: what is wrong woth this statement?
Sorry, I don't think I was very clear. I'm asking a more generic question about control flow expressions. I want to run a sql statement but only if a certain condition is met, namely if a particular record exists in a table. I want to do it all in a single mysql statement, like so: If ([record exists]) then Do some sql End If How can I do this? Thanks. -Original Message- From: Leo [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 11:38 PM To: Josh Howe Cc: [EMAIL PROTECTED] Subject: Re: what is wrong woth this statement? i didnt fully catch you... is this the kind of query statement you want? INSERT INTO some_other_table SELECT some_field_list FROM z_mail_systems HAVING COUNT(any_field)0 On Tue, 19 Oct 2004 12:45:30 -0400, Josh Howe [EMAIL PROTECTED] wrote: if (select count(*) from z_mail_systems 0) then [insert statement] endif; How do I do this kind of conditional insert? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: what is wrong woth this statement?
Thanks, but I tried that and it doesn't seem to work any better than an if statement. Have you tried it? Maybe I am doing something wrong. If you could post some working code that would be awesome. -Original Message- From: sol beach [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 3:25 PM To: Josh Howe Subject: Re: what is wrong woth this statement? How can I do this? By using the CASE staement? On Wed, 27 Oct 2004 15:15:11 -0400, Josh Howe [EMAIL PROTECTED] wrote: Sorry, I don't think I was very clear. I'm asking a more generic question about control flow expressions. I want to run a sql statement but only if a certain condition is met, namely if a particular record exists in a table. I want to do it all in a single mysql statement, like so: If ([record exists]) then Do some sql End If How can I do this? Thanks. -Original Message- From: Leo [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 11:38 PM To: Josh Howe Cc: [EMAIL PROTECTED] Subject: Re: what is wrong woth this statement? i didnt fully catch you... is this the kind of query statement you want? INSERT INTO some_other_table SELECT some_field_list FROM z_mail_systems HAVING COUNT(any_field)0 On Tue, 19 Oct 2004 12:45:30 -0400, Josh Howe [EMAIL PROTECTED] wrote: if (select count(*) from z_mail_systems 0) then [insert statement] endif; How do I do this kind of conditional insert? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: what is wrong woth this statement?
Nearly all of the T-SQL style procedural statements (IF... BEGIN... END, WHILE...WEND, cursors, etc.) are not currently available in MySQL. Procedural scripts , like the one you propose, will be available in Stored Procedures (new to MySQL 5.0+). I haven't tested that version yet, so I can't tell you if it will support a statement like yours outside of a stored procedure (as a stand-alone statement). As of right now, you still need to make control-of-flow decisions in your programming language not your SQL statements. Sorry. Depending on what you are trying to do, there may be valid MySQL SQL statement or sequence of statements that will duplicate the behavior of the decision you are trying to make. Can you be very specific about what action(s) you want your statement to make? Shawn Green Database Administrator Unimin Corporation - Spruce Pine Josh Howe [EMAIL PROTECTED] wrote on 10/27/2004 03:15:11 PM: Sorry, I don't think I was very clear. I'm asking a more generic question about control flow expressions. I want to run a sql statement but only if a certain condition is met, namely if a particular record exists in a table. I want to do it all in a single mysql statement, like so: If ([record exists]) then Do some sql End If How can I do this? Thanks. -Original Message- From: Leo [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 11:38 PM To: Josh Howe Cc: [EMAIL PROTECTED] Subject: Re: what is wrong woth this statement? i didnt fully catch you... is this the kind of query statement you want? INSERT INTO some_other_table SELECT some_field_list FROM z_mail_systems HAVING COUNT(any_field)0 On Tue, 19 Oct 2004 12:45:30 -0400, Josh Howe [EMAIL PROTECTED] wrote: if (select count(*) from z_mail_systems 0) then [insert statement] endif; How do I do this kind of conditional insert? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: deadlock caused by odbc and transaction handling
Robert, - Original Message - From: Bagyinszki Rbert [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, October 26, 2004 12:46 PM Subject: deadlock caused by odbc and transaction handling --_=_NextPart_001_01C4BB40.B000D6DB Content-Type: text/plain; charset=iso-8859-1 We are making a multithreaded application on a Solaris 8 system, with mysql 3.23 - InnoDB tables, myodbc 3.51.06, unixODBC2.2.10. When 2 threads want to update a record of a table at the same time, a deadlock is occured. One of them is waiting for the end of the transaction of the other thread - this is normal. But the other thread is waiting in an ODBC method, like SQLRowCount, or SQLAllocHandle. Only when the transaction is ended with timeout in first thread, can it continue. Is this a known problem, or maybe we misuse some function? I assume that you are using two DIFFERENT connections for the threads? That is the correct way. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql 4.1.5 source
Latest realease is 4.1.7 in 4.1.x but I am looking for 4.1.5 source download. Pointers will be helpful. Thanks Aman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: what is wrong woth this statement?
Josh, You cannot do this in mysql, as there is no such construct. Perhaps you've been misled by the title of section 13.2, Control Flow Functions http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html. Despite the name, mysql has no control flow functions. What it has are functions whose return values are conditional. There are some cases where IF (something) THEN (do something) can be rewritten into valid SQL, but in general the solution is to do this in your application code. Michael Josh Howe wrote: Sorry, I don't think I was very clear. I'm asking a more generic question about control flow expressions. I want to run a sql statement but only if a certain condition is met, namely if a particular record exists in a table. I want to do it all in a single mysql statement, like so: If ([record exists]) then Do some sql End If How can I do this? Thanks. -Original Message- From: Leo [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 11:38 PM To: Josh Howe Cc: [EMAIL PROTECTED] Subject: Re: what is wrong woth this statement? i didnt fully catch you... is this the kind of query statement you want? INSERT INTO some_other_table SELECT some_field_list FROM z_mail_systems HAVING COUNT(any_field)0 On Tue, 19 Oct 2004 12:45:30 -0400, Josh Howe [EMAIL PROTECTED] wrote: if (select count(*) from z_mail_systems 0) then [insert statement] endif; How do I do this kind of conditional insert? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqldump error
Running MySQL 4.0.12-NT on a Windows 2k Pro Server. When I attempt to execute mysqldump.exe, I get the following error: mysqldump: ERROR: unknown variable 'local-infile=1' I tried using --force and it didn't help. Showing the variables, I get local-infile to be TRUE. I looked in my.ini and found 3 instances of local-infile=1, for [mysqld], [mysql], and [client]. I thought perhaps if I put spaces around the = sign, that may help, but after editing the file, stopping and starting the service, the same error. This mysql server has been running for well over a year with no problems, but I've never had to do a dump before. Any suggestions welcome. -Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 4.1.5 source
Thanks a ton ! Aman Raheja Nate Blanchard wrote: http://downloads.mysql.com/archives.php -Original Message- From: Aman Raheja [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 3:47 PM To: mysql Subject: mysql 4.1.5 source Latest realease is 4.1.7 in 4.1.x but I am looking for 4.1.5 source download. Pointers will be helpful. Thanks Aman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: what is wrong woth this statement?
Thanks Shawn. Basically, our deployment mechanism involves applying sql change scripts as part of the build process. I created this simple shell script: host=$1 user=$2 pwd=$3 mysql -u$user -p$pwd -h$host -f sinu_com _EOF_ #Put the scripts to execute here: \. z_worklog_alter.sql \. z_companies_alter.sql quit _EOF_ I'd like to be able to run this script multiple times against the same db without corrupting the data or structure, and without generating error messages that don't indicate a real problem with one of the scripts (e.g. that column already exists). To this end, I want to put code in all of the .sql files so that it only executes once. E.g. if the sql is: Insert into users values (myemail,mypassword) I would want some thing like this: If(not exists(select * from users where username=myemail), Insert into users values (myemail,mypassword)) I think I can protect against bad data with the proper keys and unique indexes. I'm not sure about this though. But even if I can protect the db from corruption, I will still get a bunch of primary key violations and such, and this will make it harder to extract the actual errors (e.g. syntax errors in the sql) when I run the script. So that's why I want to do this. I hope that made sense. I guess that rather than trying to execute each script directly I can execute each via an intermediate perl script that updates the db to indicate which change scripts have been applied. That's more complex though. Any ideas would be greatly appreciated. Thanks! From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 3:30 PM To: Josh Howe Cc: Leo; [EMAIL PROTECTED] Subject: RE: what is wrong woth this statement? Nearly all of the T-SQL style procedural statements (IF... BEGIN... END, WHILE...WEND, cursors, etc.) are not currently available in MySQL. Procedural scripts , like the one you propose, will be available in Stored Procedures (new to MySQL 5.0+). I haven't tested that version yet, so I can't tell you if it will support a statement like yours outside of a stored procedure (as a stand-alone statement). As of right now, you still need to make control-of-flow decisions in your programming language not your SQL statements. Sorry. Depending on what you are trying to do, there may be valid MySQL SQL statement or sequence of statements that will duplicate the behavior of the decision you are trying to make. Can you be very specific about what action(s) you want your statement to make? Shawn Green Database Administrator Unimin Corporation - Spruce Pine Josh Howe [EMAIL PROTECTED] wrote on 10/27/2004 03:15:11 PM: Sorry, I don't think I was very clear. I'm asking a more generic question about control flow expressions. I want to run a sql statement but only if a certain condition is met, namely if a particular record exists in a table. I want to do it all in a single mysql statement, like so: If ([record exists]) then Do some sql End If How can I do this? Thanks. -Original Message- From: Leo [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 11:38 PM To: Josh Howe Cc: [EMAIL PROTECTED] Subject: Re: what is wrong woth this statement? i didnt fully catch you... is this the kind of query statement you want? INSERT INTO some_other_table SELECT some_field_list FROM z_mail_systems HAVING COUNT(any_field)0 On Tue, 19 Oct 2004 12:45:30 -0400, Josh Howe [EMAIL PROTECTED] wrote: if (select count(*) from z_mail_systems 0) then [insert statement] endif; How do I do this kind of conditional insert? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: what is wrong woth this statement?
You are right about your PRIMARY KEY and UNIQUE keys being able to protect most of your data. MySQL has an optional switch for INSERT, UPDATE, and ALTER TABLE statements just for some of the situations you described. It's IGNORE and I can vouch that it works well. http://dev.mysql.com/doc/mysql/en/INSERT.html http://dev.mysql.com/doc/mysql/en/UPDATE.html http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html How can we detect that you have already altered a table to add a column to it? Not sure, the CREATE TABLE has an IF NOT EXISTS option but I don't see one for ALTER TABLE ADD column_name column_def It may be safer, in your automated scripts, to create a new table with the correct structure then copy the data over from the old table. Drop the old table, then rename the new one. Basically without the ability for your shell script to get any information from MySQL you are severely limiting your options as to how much optional execution you can perform. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Josh Howe [EMAIL PROTECTED] wrote on 10/27/2004 03:52:45 PM: Thanks Shawn. Basically, our deployment mechanism involves applying sql change scripts as part of the build process. I created this simple shell script: host=$1 user=$2 pwd=$3 mysql -u$user -p$pwd -h$host -f sinu_com _EOF_ #Put the scripts to execute here: \. z_worklog_alter.sql \. z_companies_alter.sql quit _EOF_ I?d like to be able to run this script multiple times against the same db without corrupting the data or structure, and without generating error messages that don?t indicate a real problem with one of the scripts (e.g. ?that column already exists?). To this end, I want to put code in all of the ?.sql? files so that it only executes once. E.g. if the sql is: Insert into users values (?myemail?,?mypassword?) I would want some thing like this: If(not exists(select * from users where username=?myemail?), Insert into users values (?myemail?,?mypassword?)) I think I can protect against bad data with the proper keys and unique indexes. I?m not sure about this though. But even if I can protect the db from corruption, I will still get a bunch of primary key violations and such, and this will make it harder to extract the actual errors (e.g. syntax errors in the sql) when I run the script. So that?s why I want to do this. I hope that made sense. I guess that rather than trying to execute each script directly I can execute each via an intermediate perl script that updates the db to indicate which change scripts have been applied. That?s more complex though. Any ideas would be greatly appreciated. Thanks! From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 3:30 PM To: Josh Howe Cc: Leo; [EMAIL PROTECTED] Subject: RE: what is wrong woth this statement? Nearly all of the T-SQL style procedural statements (IF... BEGIN... END, WHILE...WEND, cursors, etc.) are not currently available in MySQL. Procedural scripts , like the one you propose, will be available in Stored Procedures (new to MySQL 5.0+). I haven't tested that version yet, so I can't tell you if it will support a statement like yours outside of a stored procedure (as a stand-alone statement). As of right now, you still need to make control-of-flow decisions in your programming language not your SQL statements. Sorry. Depending on what you are trying to do, there may be valid MySQL SQL statement or sequence of statements that will duplicate the behavior of the decision you are trying to make. Can you be very specific about what action(s) you want your statement to make? Shawn Green Database Administrator Unimin Corporation - Spruce Pine Josh Howe [EMAIL PROTECTED] wrote on 10/27/2004 03:15:11 PM: Sorry, I don't think I was very clear. I'm asking a more generic question about control flow expressions. I want to run a sql statement but only if a certain condition is met, namely if a particular record exists in a table. I want to do it all in a single mysql statement, like so: If ([record exists]) then Do some sql End If How can I do this? Thanks. -Original Message- From: Leo [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 11:38 PM To: Josh Howe Cc: [EMAIL PROTECTED] Subject: Re: what is wrong woth this statement? i didnt fully catch you... is this the kind of query statement you want? INSERT INTO some_other_table SELECT some_field_list FROM z_mail_systems HAVING COUNT(any_field)0 On Tue, 19 Oct 2004 12:45:30 -0400, Josh Howe [EMAIL PROTECTED] wrote: if (select count(*) from z_mail_systems 0) then [insert statement] endif; How do I do this kind of conditional insert? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:
Re: what is wrong woth this statement?
Have you considered doing what you want to do in Ant? I haven't done exactly what you want to do but Ant supports properties and conditions. I could imagine an Ant task that determines if the desired record exists, then another task that does an insert is executed only if the record doesn't exist. That might be easier than using a programming language if you have a major reluctance to do programming. Rhino - Original Message - From: [EMAIL PROTECTED] To: Josh Howe [EMAIL PROTECTED] Cc: Leo [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 3:29 PM Subject: RE: what is wrong woth this statement? Nearly all of the T-SQL style procedural statements (IF... BEGIN... END, WHILE...WEND, cursors, etc.) are not currently available in MySQL. Procedural scripts , like the one you propose, will be available in Stored Procedures (new to MySQL 5.0+). I haven't tested that version yet, so I can't tell you if it will support a statement like yours outside of a stored procedure (as a stand-alone statement). As of right now, you still need to make control-of-flow decisions in your programming language not your SQL statements. Sorry. Depending on what you are trying to do, there may be valid MySQL SQL statement or sequence of statements that will duplicate the behavior of the decision you are trying to make. Can you be very specific about what action(s) you want your statement to make? Shawn Green Database Administrator Unimin Corporation - Spruce Pine Josh Howe [EMAIL PROTECTED] wrote on 10/27/2004 03:15:11 PM: Sorry, I don't think I was very clear. I'm asking a more generic question about control flow expressions. I want to run a sql statement but only if a certain condition is met, namely if a particular record exists in a table. I want to do it all in a single mysql statement, like so: If ([record exists]) then Do some sql End If How can I do this? Thanks. -Original Message- From: Leo [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 11:38 PM To: Josh Howe Cc: [EMAIL PROTECTED] Subject: Re: what is wrong woth this statement? i didnt fully catch you... is this the kind of query statement you want? INSERT INTO some_other_table SELECT some_field_list FROM z_mail_systems HAVING COUNT(any_field)0 On Tue, 19 Oct 2004 12:45:30 -0400, Josh Howe [EMAIL PROTECTED] wrote: if (select count(*) from z_mail_systems 0) then [insert statement] endif; How do I do this kind of conditional insert? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: what is wrong woth this statement?
Thanks for all of the advice everybody. I'm actually a lot more comfortable with perl than ANT so I think I'll use that. ANT does seem pretty cool though, I'll need to buckle down and learn it at some point. -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 4:51 PM To: Josh Howe; [EMAIL PROTECTED] Cc: Leo; [EMAIL PROTECTED] Subject: Re: what is wrong woth this statement? Have you considered doing what you want to do in Ant? I haven't done exactly what you want to do but Ant supports properties and conditions. I could imagine an Ant task that determines if the desired record exists, then another task that does an insert is executed only if the record doesn't exist. That might be easier than using a programming language if you have a major reluctance to do programming. Rhino - Original Message - From: [EMAIL PROTECTED] To: Josh Howe [EMAIL PROTECTED] Cc: Leo [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 3:29 PM Subject: RE: what is wrong woth this statement? Nearly all of the T-SQL style procedural statements (IF... BEGIN... END, WHILE...WEND, cursors, etc.) are not currently available in MySQL. Procedural scripts , like the one you propose, will be available in Stored Procedures (new to MySQL 5.0+). I haven't tested that version yet, so I can't tell you if it will support a statement like yours outside of a stored procedure (as a stand-alone statement). As of right now, you still need to make control-of-flow decisions in your programming language not your SQL statements. Sorry. Depending on what you are trying to do, there may be valid MySQL SQL statement or sequence of statements that will duplicate the behavior of the decision you are trying to make. Can you be very specific about what action(s) you want your statement to make? Shawn Green Database Administrator Unimin Corporation - Spruce Pine Josh Howe [EMAIL PROTECTED] wrote on 10/27/2004 03:15:11 PM: Sorry, I don't think I was very clear. I'm asking a more generic question about control flow expressions. I want to run a sql statement but only if a certain condition is met, namely if a particular record exists in a table. I want to do it all in a single mysql statement, like so: If ([record exists]) then Do some sql End If How can I do this? Thanks. -Original Message- From: Leo [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 11:38 PM To: Josh Howe Cc: [EMAIL PROTECTED] Subject: Re: what is wrong woth this statement? i didnt fully catch you... is this the kind of query statement you want? INSERT INTO some_other_table SELECT some_field_list FROM z_mail_systems HAVING COUNT(any_field)0 On Tue, 19 Oct 2004 12:45:30 -0400, Josh Howe [EMAIL PROTECTED] wrote: if (select count(*) from z_mail_systems 0) then [insert statement] endif; How do I do this kind of conditional insert? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump error
At 15:47 -0400 10/27/04, Michael Ragsdale wrote: Running MySQL 4.0.12-NT on a Windows 2k Pro Server. When I attempt to execute mysqldump.exe, I get the following error: mysqldump: ERROR: unknown variable 'local-infile=1' I tried using --force and it didn't help. Showing the variables, I get local-infile to be TRUE. I looked in my.ini and found 3 instances of local-infile=1, for [mysqld], [mysql], and [client]. I Remove it from [client]. thought perhaps if I put spaces around the = sign, that may help, but after editing the file, stopping and starting the service, the same error. This mysql server has been running for well over a year with no problems, but I've never had to do a dump before. Any suggestions welcome. -Mike -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Select with an IF statements
Hi, I'm trying to do the following: SELECT IF((ProductStatus IS NOT NULL), Available, Not Available) as ProductStatus FROM tb_Product WHERE ProductName = MyProduct; It works fine if the ProductName MyProduct works, and returns Available. However, if the product name doesn't work the query doesn't return any rows. I would like it to return Not Available if the product isn't found. Is there a better way to do this? Thanks, Luke Venediger. -- Get Firefox Browser! Reclaim the web. http://getfirefox.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Select with an IF statements
At 22:58 +0200 10/27/04, Luke Venediger wrote: Hi, I'm trying to do the following: SELECT IF((ProductStatus IS NOT NULL), Available, Not Available) as ProductStatus FROM tb_Product WHERE ProductName = MyProduct; It works fine if the ProductName MyProduct works, and returns Available. However, if the product name doesn't work the query doesn't return any rows. I would like it to return Not Available if the product isn't found. Is there a better way to do this? SELECT IF(COUNT(*),Available,Not Available) As ProductStatus FROM tb_Product WHERE ProductName = MyProduct; -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Corrupted relay log
One of my slaves stopped running due to a corrupted relay log. The error file shows: Error writing file 'dbs2.log' (errno: 28) Error in Log_event::read_log_event(): 'read error', data_len: 160, event_type: 2 Error reading relay log event: slave SQL thread aborted because of I/O error Slave: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave. Error_code: 0 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START. We stopped at log 'dbm-bin.004' position 22254778 I ran mysqlbinlog on the relay log file as suggested in the error message, and when it stopped running it displayed: ERROR: Error in Log_event::read_log_event(): 'Event too big', data_len: 1696607332, event_type: 105 Could not read entry at offset 9068607:Error in log format or read error None of the other slaves had this problem, so I ruled out a corrupted master binary log. What are my options, if any? I tried SQL_SLAVE_SKIP_COUNTER but the slave still wouldn't start. Can I instruct the slave to skip this particular relay log file? Thanks, Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Select with an IF statements
- Original Message - From: Luke Venediger [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 4:58 PM Subject: Select with an IF statements Hi, I'm trying to do the following: SELECT IF((ProductStatus IS NOT NULL), Available, Not Available) as ProductStatus FROM tb_Product WHERE ProductName = MyProduct; It works fine if the ProductName MyProduct works, and returns Available. However, if the product name doesn't work the query doesn't return any rows. I would like it to return Not Available if the product isn't found. Is there a better way to do this? Yes; use a programming language like Java, Perl or PHP. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 3.23 store large data
Hi. Use LONGBLOB. Jerry Swanson [EMAIL PROTECTED] wrote: What type I should use in MySQL 3.23.58 to store large data file? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump error
Hi. See http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html and upgrade to the latest stable release. Michael Ragsdale [EMAIL PROTECTED] wrote: Running MySQL 4.0.12-NT on a Windows 2k Pro Server. When I attempt to execute mysqldump.exe, I get the following error: mysqldump: ERROR: unknown variable 'local-infile=1' I tried using --force and it didn't help. Showing the variables, I get local-infile to be TRUE. I looked in my.ini and found 3 instances of local-infile=1, for [mysqld], [mysql], and [client]. I thought perhaps if I put spaces around the = sign, that may help, but after editing the file, stopping and starting the service, the same error. This mysql server has been running for well over a year with no problems, but I've never had to do a dump before. Any suggestions welcome. -Mike -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 4.1.5 source
Hi. Look at http://downloads.mysql.com/archives.php?p=mysql-4.1v=4.1.5 Aman Raheja [EMAIL PROTECTED] wrote: Latest realease is 4.1.7 in 4.1.x but I am looking for 4.1.5 source download. Pointers will be helpful. Thanks Aman -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Select with an IF statements
Thanks Paul! Luke Venediger. On Wed, 27 Oct 2004 16:17:51 -0500, Paul DuBois [EMAIL PROTECTED] wrote: At 22:58 +0200 10/27/04, Luke Venediger wrote: Hi, I'm trying to do the following: SELECT IF((ProductStatus IS NOT NULL), Available, Not Available) as ProductStatus FROM tb_Product WHERE ProductName = MyProduct; It works fine if the ProductName MyProduct works, and returns Available. However, if the product name doesn't work the query doesn't return any rows. I would like it to return Not Available if the product isn't found. Is there a better way to do this? SELECT IF(COUNT(*),Available,Not Available) As ProductStatus FROM tb_Product WHERE ProductName = MyProduct; -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Get Firefox Browser! Reclaim the web. http://getfirefox.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Select with an IF statements
Hi Rhino, I don't think that answer solves the problem. I do use a programming language, and doing a query like this means I can make use of the database engine and not add overhead to my application. Cheers, Luke Venediger. On Wed, 27 Oct 2004 17:26:56 -0400, Rhino [EMAIL PROTECTED] wrote: - Original Message - From: Luke Venediger [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 4:58 PM Subject: Select with an IF statements Hi, I'm trying to do the following: SELECT IF((ProductStatus IS NOT NULL), Available, Not Available) as ProductStatus FROM tb_Product WHERE ProductName = MyProduct; It works fine if the ProductName MyProduct works, and returns Available. However, if the product name doesn't work the query doesn't return any rows. I would like it to return Not Available if the product isn't found. Is there a better way to do this? Yes; use a programming language like Java, Perl or PHP. Rhino -- Get Firefox Browser! Reclaim the web. http://getfirefox.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
query stopped working
Hi, I have this query which used to work really fast but now it just seems to lock up the tables. I tried running it with EXPLAIN but it just hangs at the command prompt. I also tried adding the USE INDEX directives but still no luck. I've run myisamchk -m on both tables involved and no errors were reported so I'm really at a loss to why this has gone wrong. Can anybody help me out please? Thanks, JS. mysql SELECT DISTINCT uv.urlid FROM url_visit uv USE INDEX(url_server_ID), url_servers us - use index(ID) WHERE us.server LIKE %java% AND uv.url_server_ID=us.ID; mysql desc url_servers; ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | ID | int(10) unsigned | | MUL | NULL| auto_increment | | server | varchar(255) | | PRI | || ++--+--+-+-++ 2 rows in set (0.00 sec) mysql show indexes from url_servers; +-++--+--+-+---+-+--++--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +-++--+--+-+---+-+--++--++-+ | url_servers | 0 | PRIMARY |1 | server | A | 279599 | NULL | NULL | | BTREE | | | url_servers | 1 | ID |1 | ID | A | 279599 | NULL | NULL | | BTREE | | +-++--+--+-+---+-+--++--++-+ 2 rows in set (0.00 sec) mysql desc url_visit; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | urlid | int(10) unsigned | | PRI | NULL| auto_increment | | url_scheme_ID | tinyint(3) unsigned | | | 0 | | | url_server_ID | int(10) unsigned | | MUL | 0 | | | url_path_ID | int(10) unsigned | | | 0 | | | url_query_ID| int(10) unsigned | | | 0 | | | url_category_ID | smallint(5) unsigned | | | 0 | | +-+--+--+-+-++ 6 rows in set (0.01 sec) mysql show indexes from url_visit; +---++---+--+---+---+-+--++--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +---++---+--+---+---+-+--++--++-+ | url_visit | 0 | PRIMARY |1 | urlid | A |25881342 | NULL | NULL | | BTREE | | | url_visit | 0 | url_server_ID |1 | url_server_ID | A | 278294 | NULL | NULL | | BTREE | | | url_visit | 0 | url_server_ID |2 | url_path_ID | A |12940671 | NULL | NULL | | BTREE | | | url_visit | 0 | url_server_ID |3 | url_query_ID | A |25881342 | NULL | NULL | | BTREE | | | url_visit | 0 | url_server_ID |4 | url_scheme_ID | A |25881342 | NULL | NULL | | BTREE | | +---++---+--+---+---+-+--++--++-+ 5 rows in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Best way to access field name in C
Hey have you checked thi shttp://www.geocities.com/jahan.geo/mysql_c_by_example.html? Matthew Boehm wrote: What is the best way to access a specific field in C? Its really easy in PHP... PHP --- $res = mysql_real_query($mysql,SELECT col1, col2 FROM table); while($row = mysql_fetch_row($res)) { print $row['col1']; print $row['col2']; } Is the only way/best way to do the above in C by using a nested for-loop? Ex: fields = mysql_fetch_fields(res); while((row=mysql_fetch_row(res)) { for(x=0;xnumFields;x++) { sprintf(output, Column name: %s Column Value: %s\n, fields[x].name, row[x]); } } Seems painful and extra-loopy to do it in C. Is there a better way? Thanks, Matthew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Perfomance: UNION vs. # of SELECT
Hello Listpeople, I need to output headline and link information from an 'articles' table. Each article belongs to one and only one 'section'. I will probably need a different number of articles from each section. I'm wondering about performance, in very general terms, of a few different strategies outlined below. I imagined using a single SELECT like: 1.) SELECT * FROM articles WHERE section IN ('music','art','books'...) LIMIT ?? but couldn't figure out how to get 4 records from 'music' and 6 records from 'art'. I imagined using 6 different queries, then patching the results together in my application: 2.) a.) SELECT * FROM articles WHERE section='music' LIMIT 4 b.) SELECT * FROM articles WHERE section='art' LIMIT 6 etc. but thought this might be a lot of queries to throw at the database for each page request. Then I thought that I could send in one big old query using a UNION: 3.) SELECT * FROM articles WHERE section='music' LIMIT 4 UNION SELECT * FROM articles WHERE section='art' LIMIT 6 UNION SELECT * FROM articles WHERE section='books' LIMIT 6 etc. Could anyone comment on these 3 strategies and any 'gotchas', limitations, other considerations that I haven't, uhh, considered? -- Wellington -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Select with an IF statements
That's up to you of course. Personally, I think some things are better handled by the database and some are better handled by the programming language. Things like conditional logic tend to be best handled by the programming language in my view. Your mileage may vary ;-) After all, just because something might possibly be done by MySQL doesn't mean it is the *best* place to do it. For example, a database can store BLOBs like photographs or wave files; does that mean databases should be used to *create* those files? In my view, the answer is no: you use graphics programs to create pictures and music programs to create music. Rhino - Original Message - From: Luke Venediger [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 5:47 PM Subject: Re: Select with an IF statements Hi Rhino, I don't think that answer solves the problem. I do use a programming language, and doing a query like this means I can make use of the database engine and not add overhead to my application. Cheers, Luke Venediger. On Wed, 27 Oct 2004 17:26:56 -0400, Rhino [EMAIL PROTECTED] wrote: - Original Message - From: Luke Venediger [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 4:58 PM Subject: Select with an IF statements Hi, I'm trying to do the following: SELECT IF((ProductStatus IS NOT NULL), Available, Not Available) as ProductStatus FROM tb_Product WHERE ProductName = MyProduct; It works fine if the ProductName MyProduct works, and returns Available. However, if the product name doesn't work the query doesn't return any rows. I would like it to return Not Available if the product isn't found. Is there a better way to do this? Yes; use a programming language like Java, Perl or PHP. Rhino -- Get Firefox Browser! Reclaim the web. http://getfirefox.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Subqueries and JOIN
Can I execute this query in a single JOIN statement? select * from hist where date_h = '20041027' and tel not in (select distinct tel from hist where date_h '20041027') I know I could do it using a temporary table, but I wonder if there's a way to do it directly. Thanks! Hector -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Determining if query will work
Like so many other people.. No one puts any collective thought into what they are doing.. Instead of moving on and trying to finish the rest yourself, you rely on someone else to finish it for you. -Original Message- From: Eve Atley [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 9:49 AM To: [EMAIL PROTECTED] Cc: Mysql Subject: RE: Determining if query will work I can't tell you how *glad* I am to get this running! Big hugs to you, Shawn! It's running beautifully. My only question is, after I run the queries, I notice it won't let me create the temporary table again (saying 'tmpCandidates' already exists). Do I just need to then log out of my client (MySQL Control Center) and back in to get rid of that temp table? As I'll need to change what it searches for (ie baan, peoplesoft, etc.). Or is there a query I can put in at the end of the queries to destroy the temporary table once through with it? Final query setup posted below. Thanks, Eve CREATE TEMPORARY TABLE wow.tmpCandidates SELECT DISTINCT r.Candidate_ID FROM wow.resume r WHERE r.Section_ID = '1' AND MATCH (r.Section_Value) AGAINST ('+peoplesoft' IN BOOLEAN MODE); INSERT IGNORE INTO wow.resume_erp (Candidate_ID, Section_ID, Section_Value) SELECT SQL_CALC_FOUND_ROWS r.Candidate_ID, r.Section_ID, r.Section_Value FROM wow.tmpCandidates tc INNER JOIN wow.resume r on r.Candidate_ID = tc.Candidate_ID; INSERT IGNORE INTO wow.candidate_erp (Candidate_ID, Vendor_ID, Last_Name, First_Name, Middle_Initial, Condition_Type, Employer, Country_ID, Visa_Status, Dt_Visa, MMDD_Birth, SSN, CSG_Comments, Working, Available, Start_Date, Location, HoldOnPeriod, Relocation, Tech_Ranking, Comm_Ranking, Availability, Cert_Comments, Dt_Submitted, Def_Rate, Def_Rate_Unit, Other_Country, Currency_id, Interview_Availability, Interview_Contact, US_Experience, Location_Country) SELECT SQL_CALC_FOUND_ROWS c.Candidate_ID, c.Vendor_ID, c.Last_Name, c.First_Name, c.Middle_Initial, c.Condition_Type, c.Employer, c.Country_ID, c.Visa_Status, c.Dt_Visa, c.MMDD_Birth, c.SSN, c.CSG_Comments, c.Working, c.Available, c.Start_Date, c.Location, c.HoldOnPeriod, c.Relocation, c.Tech_Ranking, c.Comm_Ranking, c.Availability, c.Cert_Comments, c.Dt_Submitted, c.Def_Rate, c.Def_Rate_Unit, c.Other_Country, c.Currency_id, c.Interview_Availability, c.Interview_Contact, c.US_Experience, c.Location_Country FROM wow.tmpCandidates tc INNER JOIN wow.candidate c ON c.Candidate_ID = tc.Candidate_ID; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LOAD DATA LOCAL INFILE
Hi! Can someone point me in the right direction? I have this that works in v.4x: $sql = LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE `members` FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '' LINES TERMINATED BY '\\r\\n'; When I try it using 3.23.55 I get the following error: #1148 - The used command is not allowed with this MySQL version Is there any way I can make this work using 3.23.55? TIA! R. Whitney Transcend Development Producing the next phase of your internet presence http://xend.net Premium Quality Web Hosting http://hosting.xend.net [EMAIL PROTECTED] 310-943-6498 602-288-5340 The day this country abandons God is the day God will abandon this country Linux is like a wigwam, no windows, no gates, apache inside. - borrowed from Sharon Kimble off of the Fedora mailing list -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Determining if query will work
Well that wasn't a very nice thing to say. On Mon, 2004-10-25 at 11:56, none none wrote: Like so many other people.. No one puts any collective thought into what they are doing.. Instead of moving on and trying to finish the rest yourself, you rely on someone else to finish it for you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: LOAD DATA LOCAL INFILE
Hi Richard, Try looking at mysqlimport instead. I'm only taking a punt that it works with that version but the manual doesn't say anything about it being since a certain version. It works as at 3.23.58 so hopefully it may do for .55 Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Richard Whitney [mailto:[EMAIL PROTECTED] Sent: Thursday, 28 October 2004 10:37 AM To: [EMAIL PROTECTED] Subject: LOAD DATA LOCAL INFILE Hi! Can someone point me in the right direction? I have this that works in v.4x: $sql = LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE `members` FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '' LINES TERMINATED BY '\\r\\n'; When I try it using 3.23.55 I get the following error: #1148 - The used command is not allowed with this MySQL version Is there any way I can make this work using 3.23.55? TIA! R. Whitney Transcend Development Producing the next phase of your internet presence http://xend.net Premium Quality Web Hosting http://hosting.xend.net [EMAIL PROTECTED] 310-943-6498 602-288-5340 The day this country abandons God is the day God will abandon this country Linux is like a wigwam, no windows, no gates, apache inside. - borrowed from Sharon Kimble off of the Fedora mailing list -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A DB Design issue
Hi all, I'm designing a small database, it's essentially a tree-structure. I'm probably going to use a Modified Preorder Tree Traversal (On a side note, how is it different than an Unmodified Preorder Tree Traversal?). Each node will have children etc, and those will have children, etc. But I want to apply data to groups of nodes. So each child will either be an actual entity, or a group of entities, which brings me to my problem. If I have groups in one table, and entities in another, and a child can be either a group or an entity I can't store that 'ID' in the same column. What are my options at approaching this? I've thought about writing so each child is a group, and every child is in a group (even if it's a group of one). That would solve my problem, but it seems like there could be a better solution. Thanks, Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
run mysql service in Linux
dear All Master of Mysql, I'm new in Mysql, and I'd just move to mysql Linux version..!and i have problem to activate the service. I have installed Mysql linux ver. with this Command tar-zxvf mysql-standard-4.0.21-pc-linux-i686.tar when i try to Configure ./configure ,there is a note that i don't have to configure because the mysql file type is Binary..! after that I create a usr (groupadd mysql and usradd -g mysql mysql) then, i change of owner of data directory chown -R root /var/liv/mysql chown -R mysql /var/liv/mysql chgrp -R mysql /var/liv/mysql then, I try to start the service with this command mysqld_safe \ --user=mysql [EMAIL PROTECTED] bin]# Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/lib/mysql/server6.cma-cgm.com.pid 041028 09:10:27 mysqld ended [EMAIL PROTECTED] bin]# ./mysqld start 041028 9:42:55 Warning: Asked for 196608 thread stack, but got 126976 041028 9:42:55 Can't find messagefile '/usr/local/mysql/share/mysql/english/errmsg.sys' 041028 9:42:55 Aborting -- ___ Find what you are looking for with the Lycos Yellow Pages http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: LOAD DATA LOCAL INFILE
Richard Whitney wrote: Hi! Can someone point me in the right direction? I have this that works in v.4x: $sql = LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE `members` FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '' LINES TERMINATED BY '\\r\\n'; When I try it using 3.23.55 I get the following error: #1148 - The used command is not allowed with this MySQL version Is there any way I can make this work using 3.23.55? TIA! R. Whitney Transcend Development Producing the next phase of your internet presence http://xend.net Premium Quality Web Hosting http://hosting.xend.net [EMAIL PROTECTED] 310-943-6498 602-288-5340 The day this country abandons God is the day God will abandon this country Linux is like a wigwam, no windows, no gates, apache inside. - borrowed from Sharon Kimble off of the Fedora mailing list Someone else had asked about the LOAD DATA syntax earlier this morning and getting the same error message that you're getting and one of the Ensita guys responded with this link: http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html It looks like you might fall into the MySQL version discussed in the link. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Should I change the MySQL client library
Hello, MySQL has released 4.1.7 http://lists.mysql.com/announce/226 As you can see there have been some bugfixes in libmysqlclient. I am using libmysql.dll provided with 4.1.1 in my app. Do I need to upgrade it to the one provided with 4.1.7? Regards, Karam __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]