Re: PHP Generator for MySQL 11.4 released

2011-04-28 Thread Sharl.Jimh.Tsin
really? that's too bad :-( Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2011/4/29 Jan Steinman : > 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,

Re: PHP Generator for MySQL 11.4 released

2011-04-28 Thread Jan Steinman
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" > Date: 26 April 2011 18:33:04 PDT > To: SQL Maestro Tea

Re: Запрос

2011-04-28 Thread Sharl.Jimh.Tsin
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 : > It's an Earth language.  But I know wh

RE: Join based upon LIKE

2011-04-28 Thread Jerry Schwartz
>-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" >> >> No takers? > >Not willingly, no

Re: Join based upon LIKE

2011-04-28 Thread Johan De Meersman
- Original Message - > From: "Jerry Schwartz" > > 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,

FW: Join based upon LIKE

2011-04-28 Thread Jerry Schwartz
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 c

Re: left join two tables

2011-04-28 Thread Darryle Steplight
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 wrote: > Hey there, > > - Original Message -

Re: left join two tables

2011-04-28 Thread Johan De Meersman
Hey there, - Original Message - > From: "Rocio Gomez Escribano" > 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 sugg

left join two tables

2011-04-28 Thread Rocio Gomez Escribano
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 r.go...@ingenia-soluciones.co

Re: ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY'

2011-04-28 Thread misiaq
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" pisze: > Thanks , but there is no trigger on tables. > > Even I solved the problem after googling a link but cannot unders

Re: ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY'

2011-04-28 Thread Adarsh Sharma
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" pisze: Dear all, I have a login table in the databas

ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY'

2011-04-28 Thread Adarsh Sharma
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 `use

Re: Запрос

2011-04-28 Thread Fish Kungfu
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 > On 04/28/2011 12:40 PM, Johan De Meersman wrote: > >> Я предлагаю более отчетливо английски применения :-p >> > > could you guys

RE: Запрос

2011-04-28 Thread Martin Gainty
(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 e

Re: Запрос

2011-04-28 Thread Johan De Meersman
At which point I used google translate to ask the switch to english :-p - Original Message - > From: "Andre Polykanine" > To: "Johan De Meersman" > Cc: "Виктор Ефимович" , mysql@lists.mysql.com > Sent: Thursday, 28 April, 2011 12:58:18 PM > Subject: Re: Запрос > > Hello Johan, > > Sorry

Re: Запрос

2011-04-28 Thread Andre Polykanine
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

Re: Запрос

2011-04-28 Thread Pintér Tibor
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/mysq

Re: Запрос

2011-04-28 Thread Johan De Meersman
Я предлагаю более отчетливо английски применения :-p - Original Message - > From: "Andre Polykanine" > To: "Виктор Ефимович" > Cc: mysql@lists.mysql.com > Sent: Thursday, 28 April, 2011 12:04:01 PM > Subject: Re: Запрос > > Hello Виктор, > > Из какого приложения?) > -- Bier met gren

Re: Запрос

2011-04-28 Thread Andre Polykanine
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: Виктор Ефимович