Re: Запрос
Hello Виктор, Из какого приложения?) -- With best regards from Ukraine, Andre Skype: Francophile My blog: http://oire.org/menelion (mostly in Russian) Twitter: http://twitter.com/m_elensule Facebook: http://facebook.com/menelion Original message From: Виктор Ефимович mr.victor-tutun...@yandex.ru To: mysql@lists.mysql.com Date created: , 12:01:41 PM Subject: Запрос Подскажите по чему не устанавливается или какие действия надо сделать чтобы выйти из этого приложения. -- Vitek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=an...@oire.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Запрос
Я предлагаю более отчетливо английски применения :-p - Original Message - From: Andre Polykanine an...@oire.org To: Виктор Ефимович mr.victor-tutun...@yandex.ru Cc: mysql@lists.mysql.com Sent: Thursday, 28 April, 2011 12:04:01 PM Subject: Re: Запрос Hello Виктор, Из какого приложения?) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: Запрос
On 04/28/2011 12:40 PM, Johan De Meersman wrote: Я предлагаю более отчетливо английски применения :-p could you guys stop talking alien language on the list, please? t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Запрос
Hello Johan, Sorry guys, that's just because I've seen familiar letters :-). the topic starter asked how he can quit from this application. and I asked, from which application he wants to quit. That's all :-). -- With best regards from Ukraine, Andre Skype: Francophile My blog: http://oire.org/menelion (mostly in Russian) Twitter: http://twitter.com/m_elensule Facebook: http://facebook.com/menelion Original message From: Johan De Meersman vegiv...@tuxera.be To: Виктор Ефимович Date created: , 1:40:35 PM Subject: Запрос Я предлагаю более отчетливо английски применения :-p - Original Message - From: Andre Polykanine an...@oire.org To: Виктор Ефимович mr.victor-tutun...@yandex.ru Cc: mysql@lists.mysql.com Sent: Thursday, 28 April, 2011 12:04:01 PM Subject: Re: Запрос Hello Виктор, Из какого приложения?) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Запрос
At which point I used google translate to ask the switch to english :-p - Original Message - From: Andre Polykanine an...@oire.org To: Johan De Meersman vegiv...@tuxera.be Cc: Виктор Ефимович mr.victor-tutun...@yandex.ru, mysql@lists.mysql.com Sent: Thursday, 28 April, 2011 12:58:18 PM Subject: Re: Запрос Hello Johan, Sorry guys, that's just because I've seen familiar letters :-). the topic starter asked how he can quit from this application. and I asked, from which application he wants to quit. That's all :-). -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Запрос
(ich spreche nicht Russen) Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. From: mr.victor-tutun...@yandex.ru To: mysql@lists.mysql.com Subject: Запрос Date: Thu, 28 Apr 2011 16:01:41 +0700 Подскажите по чему не устанавливается или какие действия надо сделать чтобы выйти из этого приложения. -- Vitek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com
Re: Запрос
It's an Earth language. But I know what you mean. :-) The Google translator works great btw. http://translate.google.com/ Cheers! ~~Fish~~ 2011/4/28 Pintér Tibor tib...@tibyke.hu On 04/28/2011 12:40 PM, Johan De Meersman wrote: Я предлагаю более отчетливо английски применения :-p could you guys stop talking alien language on the list, please? t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=fish.kun...@gmail.com
ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY'
Dear all, I have a login table in the database whose definition is as : CREATE TABLE `login` ( `log_id` int(4) NOT NULL AUTO_INCREMENT, `user_id` int(4) DEFAULT NULL, `log_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `log_status` int(4) DEFAULT NULL, PRIMARY KEY (`log_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=31592 DEFAULT CHARSET=latin1 Today don't know why below error occurs when i am going insert some data in it : mysql insert into login(user_id,log_status) values(2,1); ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY' I check the latest entries as : mysql select * from login order by log_id desc limit 10; ++-+-++ | log_id | user_id | log_time| log_status | ++-+-++ | 31591 | 2 | 2011-04-27 18:00:07 | 0 | | 31590 | 25 | 2011-04-27 17:55:25 | 0 | | 31589 | 40 | 2011-04-27 15:16:25 | 0 | | 31588 | 18 | 2011-04-27 14:40:47 | 0 | | 31587 | 30 | 2011-04-27 09:46:56 | 1 | | 31586 | 17 | 2011-04-27 09:25:29 | 1 | | 31585 | 8 | 2011-04-27 09:25:22 | 1 | | 31584 | 57 | 2011-04-27 09:16:09 | 1 | | 31583 | 40 | 2011-04-27 09:15:43 | 1 | | 31582 | 59 | 2011-04-27 09:14:01 | 1 | ++-+-++ 10 rows in set (0.00 sec) I don't know why it refuses to insert new row in that table yet it is auto-increment mentioned in schema definition I researched a lot but donot find any thing about it. Please guide me how to trouble shoot it. Here is some useful information that might help : mysql select count(*) from login; +--+ | count(*) | +--+ |31581 | +--+ 1 row in set (0.00 sec) mysql insert into login(user_id,log_status) values(2,1); ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY' mysql select max(log_id) from login; +-+ | max(log_id) | +-+ | 31591 | +-+ 1 row in set (0.00 sec) mysql select min(log_id) from login; +-+ | min(log_id) | +-+ | 1 | +-+ 1 row in set (0.00 sec) mysql mysql select * from login where log_id=31592; Empty set (0.00 sec) Don't know how things got wrong. Please guide Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY'
Thanks , but there is no trigger on tables. Even I solved the problem after googling a link but cannot understand below mentioned things :- Please have some comments on them misiaq wrote: Any triggers on this table..? Adarsh Sharma adarsh.sha...@orkash.com pisze: Dear all, I have a login table in the database whose definition is as : CREATE TABLE `login` ( `log_id` int(4) NOT NULL AUTO_INCREMENT, `user_id` int(4) DEFAULT NULL, `log_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `log_status` int(4) DEFAULT NULL, PRIMARY KEY (`log_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=31592 DEFAULT CHARSET=latin1 Today don't know why below error occurs when i am going insert some data in it : mysql insert into login(user_id,log_status) values(2,1); ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY' I check the latest entries as : mysql select * from login order by log_id desc limit 10; ++-+-++ | log_id | user_id | log_time| log_status | ++-+-++ | 31591 | 2 | 2011-04-27 18:00:07 | 0 | | 31590 | 25 | 2011-04-27 17:55:25 | 0 | | 31589 | 40 | 2011-04-27 15:16:25 | 0 | | 31588 | 18 | 2011-04-27 14:40:47 | 0 | | 31587 | 30 | 2011-04-27 09:46:56 | 1 | | 31586 | 17 | 2011-04-27 09:25:29 | 1 | | 31585 | 8 | 2011-04-27 09:25:22 | 1 | | 31584 | 57 | 2011-04-27 09:16:09 | 1 | | 31583 | 40 | 2011-04-27 09:15:43 | 1 | | 31582 | 59 | 2011-04-27 09:14:01 | 1 | ++-+-++ 10 rows in set (0.00 sec) I don't know why it refuses to insert new row in that table yet it is auto-increment mentioned in schema definition I researched a lot but donot find any thing about it. Please guide me how to trouble shoot it. Here is some useful information that might help : *** mysql select count(*) from login; +--+ | count(*) | +--+ |31581 | +--+ 1 row in set (0.00 sec) mysql insert into login(user_id,log_status) values(2,1); ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY' mysql select max(log_id) from login; +-+ | max(log_id) | +-+ | 31591 | +-+ 1 row in set (0.00 sec) It means there are 31581 rows but max(log_id suggests 10 more , how this could be possible, may be some rows deleted. I solved the error by repairing the table repair table login; mysql repair table login; +--++--++ | Table| Op | Msg_type | Msg_text | +--++--++ | attendance.login | repair | warning | Number of rows changed from 31581 to 31583 | | attendance.login | repair | status | OK | +--++--++ 2 rows in set (0.29 sec) Then all insert statements works . Can u please explain the root cause solution too. Thanks mysql select min(log_id) from login; +-+ | min(log_id) | +-+ | 1 | +-+ 1 row in set (0.00 sec) mysql mysql select * from login where log_id=31592; Empty set (0.00 sec) Don't know how things got wrong. Please guide Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mis...@poczta.fm
Re: ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY'
Corrupted table and / or index. A number of reasons could cause this issue: http://dev.mysql.com/doc/refman/5.1/en/corrupted-myisam-tables.html Regards, m Adarsh Sharma adarsh.sha...@orkash.com pisze: Thanks , but there is no trigger on tables. Even I solved the problem after googling a link but cannot understand below mentioned things :- Please have some comments on them (... cut ...) It means there are 31581 rows but max(log_id suggests 10 more , how this could be possible, may be some rows deleted. I solved the error by repairing the table repair table login; mysql repair table login; +--++--++ | Table| Op | Msg_type | Msg_text | +--++--++ | attendance.login | repair | warning | Number of rows changed from 31581 to 31583 | | attendance.login | repair | status | OK | +--++--++ 2 rows in set (0.29 sec) Then all insert statements works . Can u please explain the root cause solution too. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
left join two tables
Hi!! Is it possible to create a left join consult with 2 tables?? I mean: SELECT * FROM table1 LEFT JOIN (table2, table3) on table1.ID = table2.subID and table1.ID= table3.subID Thanks!!! Rocío Gómez Escribano mailto:r.sanc...@ingenia-soluciones.com r.go...@ingenia-soluciones.com Descripción: cid:image002.jpg@01CB8CB6.ADEBA830 Polígono Campollano C/F, nº21T 02007 Albacete (España) Tlf:967-504-513 Fax: 967-504-513 www.ingenia-soluciones.com
Re: left join two tables
Hey there, - Original Message - From: Rocio Gomez Escribano r.go...@ingenia-soluciones.com Hi!! Is it possible to create a left join consult with 2 tables?? I mean: SELECT * FROM table1 LEFT JOIN (table2, table3) on table1.ID = table2.subID and table1.ID= table3.subID Pretty close already. Might I suggest sampling the fine manual ? Have a look at http://dev.mysql.com/doc/refman/5.0/en/join.html -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: left join two tables
Hi Johan, I think you probably want something like this. Give the following a shot. SELECT * FROM table1 LEFT JOIN table2 ON table1.ID = table2.subID LEFT JOIN table3 ON table1.ID= table3.subID On Thu, Apr 28, 2011 at 9:41 AM, Johan De Meersman vegiv...@tuxera.be wrote: Hey there, - Original Message - From: Rocio Gomez Escribano r.go...@ingenia-soluciones.com Hi!! Is it possible to create a left join consult with 2 tables?? I mean: SELECT * FROM table1 LEFT JOIN (table2, table3) on table1.ID = table2.subID and table1.ID= table3.subID Pretty close already. Might I suggest sampling the fine manual ? Have a look at http://dev.mysql.com/doc/refman/5.0/en/join.html -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- -- May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
FW: Join based upon LIKE
No takers?
-Original Message-
From: Jerry Schwartz [mailto:je...@gii.co.jp]
Sent: Monday, April 25, 2011 2:34 PM
To: 'Mailing-List mysql'
Subject: Join based upon LIKE
I have to match lists of new publications against our database, so that I can
replace the existing publications in our catalog. For example,
The UK Market for Puppies in February 2011
would be a replacement for
The UK Market for Puppies in December 2010
Unfortunately, the publishers aren't particularly careful with their titles.
One might even say they are perverse. I am likely to get
UK Market: Puppies - Feb 2011
as replacement for
The UK Market for Puppies in December 2010
You can see that a straight match by title is not going to work.
Here's what I've been doing:
=
SET @PUBID = (SELECT pub.pub_id FROM pub WHERE pub.pub_code = 'GD');
CREATE TEMPORARY TABLE new_titles (
new_title VARCHAR(255), INDEX (new_title),
new_title_like VARCHAR(255), INDEX (new_title_like)
);
INSERT INTO new_titles
VALUES
('Alternative Energy Monthly Deal Analysis - MA and Investment Trends, April
2011', 'Alternative Energy Monthly Deal Analysis%MA%Investment Trends%'),
('Asia Pacific Propylene Industry Outlook to 2015 - Market Size, Company
Share, Price Trends, Capacity Forecasts of All Active and Planned Plants',
'Asia Pacific Propylene Industry Outlook to%Market Size%Company Share%Price
Trends%Capacity Forecasts of All Active%Planned Plants'),
...
('Underground Gas Storage Industry Outlook in North America, 2011 - Details of
All Operating and Planned Gas Storage Sites to 2014', 'Underground Gas Storage
Industry Outlook%North America%Details of All Operating%Planned Gas Storage
Sites to%'),
('Uveitis Therapeutics - Pipeline Assessment and Market Forecasts to 2017',
'Uveitis Therapeutics%Pipeline Assessment%Market Forecasts to%');
SELECT prod.prod_title AS `Title IN Database`,
new_titles.new_title AS `Title IN Feed`,
prod.prod_num AS `ID`
FROM new_titles JOIN prod ON prod.prod_title LIKE (new_titles.new_title_like)
AND prod.pub_id = @PUBID AND prod.prod_discont = 0
ORDER BY new_titles.new_title;
==
(I've written code that substitutes % for certain strings that I specify,
and there is some trial and error involved.)
Here's how MySQL handles that SELECT:
*** 1. row ***
id: 1
select_type: SIMPLE
table: new_titles
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
ref: NULL
rows: 47
Extra: Using filesort
*** 2. row ***
id: 1
select_type: SIMPLE
table: prod
type: ref
possible_keys: pub_id
key: pub_id
key_len: 48
ref: const
rows: 19607
Extra: Using where
=
Here's the important part of the table `prod`:
=
Table: prod
Create Table: CREATE TABLE `prod` (
`prod_id` varchar(15) NOT NULL DEFAULT '',
`prod_num` mediumint(6) unsigned DEFAULT NULL,
`prod_title` varchar(255) DEFAULT NULL,
`prod_type` varchar(2) DEFAULT NULL,
`prod_vat_pct` decimal(5,2) DEFAULT NULL,
`prod_discont` tinyint(1) DEFAULT NULL,
`prod_replacing` mediumint(6) unsigned DEFAULT NULL,
`prod_replaced_by` mediumint(6) unsigned DEFAULT NULL,
`prod_ready` tinyint(1) DEFAULT NULL,
`pub_id` varchar(15) DEFAULT NULL,
...
PRIMARY KEY (`prod_id`),
UNIQUE KEY `prod_num` (`prod_num`),
KEY `prod_pub_prod_id` (`prod_pub_prod_id`),
KEY `pub_id` (`pub_id`),
KEY `prod_title` (`prod_title`),
FULLTEXT KEY `prod_title_fulltext` (`prod_title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
=
This works reasonably well for a small number (perhaps 200-300) of new
products; but now I've been handed a list of over 15000 to stuff into the
table `new_titles`! This motivates me to wonder if there is a better way,
since I expect this to take a very long time.
Suggestions?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Join based upon LIKE
- Original Message - From: Jerry Schwartz je...@gii.co.jp No takers? Not willingly, no :-p This is a pretty complex problem, as SQL itself isn't particularly well-equipped to deal with fuzzy data. One approach that might work is using a fulltext indexing engine (MySQL's built-in ft indices, or an external one like Solr or something) and doing best-fit matches on the keywords of the title you're looking for. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Join based upon LIKE
-Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Thursday, April 28, 2011 4:18 PM To: Jerry Schwartz Cc: mysql mailing list Subject: Re: Join based upon LIKE - Original Message - From: Jerry Schwartz je...@gii.co.jp No takers? Not willingly, no :-p This is a pretty complex problem, as SQL itself isn't particularly well- equipped to deal with fuzzy data. One approach that might work is using a fulltext indexing engine (MySQL's built-in ft indices, or an external one like Solr or something) and doing best-fit matches on the keywords of the title you're looking for. [JS] This isn't the only place I have to deal with fuzzy data. :-( Discretion prohibits further comment. A full-text index would work if I were only looking for one title at a time, but I don't know if that would be a good idea if I have a list of 1 titles. That would pretty much require either 1 separate queries or a very, very long WHERE clause. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Запрос
no need to translate it on a separate page,if you use the googlemail and enabled the instant-translate function in labs,you can easy to do it with one click. Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2011/4/28 Fish Kungfu fish.kun...@gmail.com: It's an Earth language. But I know what you mean. :-) The Google translator works great btw. http://translate.google.com/ Cheers! ~~Fish~~ 2011/4/28 Pintér Tibor tib...@tibyke.hu On 04/28/2011 12:40 PM, Johan De Meersman wrote: Я предлагаю более отчетливо английски применения :-p could you guys stop talking alien language on the list, please? t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=fish.kun...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: PHP Generator for MySQL 11.4 released
One thing they don't bother to tell you until you complete a useless download and discover that you can't open the file: this tool is Windows-only. On 28 Apr 11, at 18:02, mysql-digest-h...@lists.mysql.com wrote: From: Sharl.Jimh.Tsin amoiz.sh...@gmail.com Date: 26 April 2011 18:33:04 PDT To: SQL Maestro Team sql.maes...@gmail.com Cc: mysql@lists.mysql.com Subject: Re: PHP Generator for MySQL 11.4 released very useful tool,is it free? Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) Almost all absurdity of conduct arises from the imitation of those whom we cannot resemble. -- Samuel Johnson Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
