RE : MediumBlob / phpMyAdmin / hex dumps Questions

at the command line level -- Jacques Brignon -Message d'origine- De : mik...@qualityadvantages.com [mailto:mik...@qualityadvantages.com] Envoyé : samedi 13 décembre 2008 15:13 À : mysql@lists.mysql.com Objet : MediumBlob / phpMyAdmin / hex dumps Questions Hello and Greetings mysql list

RE : How could write this SQL

In case it is acceptable to have a1,b1.qty, b2.qty, b3.qty concatenated in one field GROUP_CONCAT might help http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_ group-concat -- Jacques Brignon -Message d'origine- De : Baron Schwartz [mailto:[EMAIL PROTECTED

RE : SPAM ?

Hi, What's kind of the message you guys mentioned? Its always the same message from the same author with the same content, same date same hour, it’s the one below: -Message d'origine- De : Jerry Schwartz [mailto:[EMAIL PROTECTED] Envoyé : jeudi 22 mars 2007 17:53 À : [EMAIL

RE : SPAM ?

post. As long as Jerry does not seem to receive the messages about the problem, if he cannot be contacted otherwise is there a way to block his messages or to unsubscribe this address until the problem is fixed? -- Jacques Brignon -- MySQL General Mailing List For list archives: http

RE : RE : SPAM ? SOLVED

to flag it as already sent, as a result it keeps being sent again and again to my client. Solution: delete the message on the server. -- Jaqcues Brignon -Message d'origine- De : Jacques Brignon [mailto:[EMAIL PROTECTED] Envoyé : dimanche 25 mars 2007 15:21 À : 'Stephen Cook' Cc : 'Jerry

SPAM ?

Hi, I keep receiving this message by several dozens each day, how can this be stopped? Regards Jacques -Message d'origine- De : Jerry Schwartz [mailto:[EMAIL PROTECTED] Envoyé : jeudi 22 mars 2007 17:53 À : [EMAIL PROTECTED]; 'James Tu' Cc : 'MySQL List' Objet : RE: Finding a

RE : error 28 from table handler

Thanks Yes the hoster fixed it by cleaning the temp files Jacques Brignon -Message d'origine- De : Sander Smeenk [mailto:[EMAIL PROTECTED] Envoyé : lundi 3 avril 2006 10:32 À : mysql@lists.mysql.com Objet : Re: error 28 from table handler Quoting Jacques Brignon ([EMAIL

Trans.: Re: error 28 from table handler

Oops forgot to include the list - Message transféré de Jacques Brignon [EMAIL PROTECTED] - Date : Mon, 03 Apr 2006 10:07:58 +0200 De : Jacques Brignon [EMAIL PROTECTED] Adresse de retour :Jacques Brignon [EMAIL PROTECTED] Sujet : Re: error 28 from table handler À : Jos

Re: error 28 from table handler

then the table would have been corrupted - Original Message - From: Jacques Brignon [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, April 03, 2006 1:58 AM Subject: error 28 from table handler Hi, I am getting the following error when executing a simple SELECT query which used

error 28 from table handler

Hi, I am getting the following error when executing a simple SELECT query which used to work: 1030 : Got error 28 from table handler I did not found that in the manual. When googleing it it seems it may be related to disk space ... The server hosting my application is running MySQL 4.0.23. My

Trans.: RE: [SPAM] - Trans.: Re: Finding the row number satisfying a conditon in a result set - Bayesian Filter detected spam

I keep forgeting to reply all. Sorry - Message transféré de Jacques Brignon [EMAIL PROTECTED] - Date : Tue, 31 Jan 2006 13:33:22 +0100 De : Jacques Brignon [EMAIL PROTECTED] Adresse de retour :Jacques Brignon [EMAIL PROTECTED] Sujet : RE: [SPAM] - Trans.: Re: Finding the row

Trans.: Re: Trans.: Re: Finding the row number satisfying a conditon in a result set

- Message transféré de Jacques Brignon [EMAIL PROTECTED] - Date : Tue, 31 Jan 2006 13:52:16 +0100 De : Jacques Brignon [EMAIL PROTECTED] Adresse de retour :Jacques Brignon [EMAIL PROTECTED] Sujet : Re: Trans.: Re: Finding the row number satisfying a conditon in a result set

Finding the row number satisfying a conditon in a result set

. That does not seem very clever and it can be very time consuming if the set has a lot of rows. -- Jacques Brignon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Trans.: Re: Finding the row number satisfying a conditon in a result set

Oops! forgoten to include the list in the relply -- Jacques Brignon - Message transféré de Jacques Brignon [EMAIL PROTECTED] - Date : Mon, 30 Jan 2006 16:16:53 +0100 De : Jacques Brignon [EMAIL PROTECTED] Adresse de retour :Jacques Brignon [EMAIL PROTECTED] Sujet : Re: Finding

Re: Problems with back up and restore mysql 5.0

When under 5.0 you need to export your data doing a character set translation to latin1 or iso-8859-1. You also need to adjust the export for compatibilty with older versions (some SQL verbs used in 5.0 are not understood by older versions) Jacques Brignon You can do that either with mysqldump

Re: Query producing default values

easily more logic and put the result in a temp table which I then use for the query. After trying the first I decided for the second one which can more easily cope with all the peculiarities found in the data. Jacques Brignon Selon Michael Stassen [EMAIL PROTECTED]: [EMAIL PROTECTED] wrote

Query producing default values

subscription exists I would like to get today's date as a result instead of nothing, example: id_ltrsn | subs_start - 0| 2005-11-09 Thanks for any help you can provide -- Jacques Brignon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Query producing default values

! -- Jacques Brignon Selon [EMAIL PROTECTED]: Jacques Brignon [EMAIL PROTECTED] wrote on 11/09/2005 09:58:07 AM: I have a query which scans a subscription databse to locte the most recent expiration date of the subscription to a given periodical or serviceto compute the start date of a renewal

Adding auto increment value in the dump file

I have not identified which options to use to have the current value of the AUTO_INCREMNT included in the dump file. Is this possible? -- Jacques Brignon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]