Re: SPAM: please remove gregario.es from the list

2011-04-03 Thread Rafael Valenzuela
hi The message sid this : Dear, inform you that your email _ * has not been delivered to the recipient * _ because there is no mailbox in the domain A greeting. I have many problems sending mail , any problem or any ideas? 2011/4/2 Reindl Harald h.rei...@thelounge.net Can anybody remove

RE: [SPAM] RE: mySql versus Sql Server performance

2010-10-25 Thread Patrick Thompson
Thanks Martin, though I'm somewhat confused by your message - there are no joins in the query (unless the longtext s thought of that way) and the Explain seems to indicate the query is using the ItemsById primary index (which is what I would expect). Patrick myListhttp://www.mylist.com/ -

Re: [Spam][78.6%] Re: Differences between 2 MySQL instances

2010-06-24 Thread Octavian Rasnita
From: Joerg Bruehe joerg.bru...@sun.com Hi! Octavian Rasnita wrote: I have tried, but with no difference. I have changed some indexes and made the queries run faster, but I still found a problem: I use a module that does paging and it makes a select(*) and this query takes a very long

Re: ***SPAM*** RE: Problem - Host 'abc.def.com' is not allowed to connect to this MySQL server, Please advice..

2008-07-14 Thread Curtis Maurand
grant all on *.* to root@'%.def.com'; /* The percent sign is your wildcard character. */ flush privileges; I don't think you need to flush privileges as of 5.0. I still do just to be sure. Curtis [EMAIL PROTECTED] wrote: Hi Parikh, Yes.. It worked with IP i.e when I granted privileges

RE: [SPAM] - MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint... - Email found in subject

2008-02-13 Thread jmacaranas
http://blogs.ittoolbox.com/km/sharepoint/archives/sharepoint-and-mysql-2 2051 hmm.. but I think you might have problems getting support from sharepoint's vendor... IIRC they always push to use SQL server for this.. (we know the reason why.. :) ) -Original Message- From: Jacob,

RE: [SPAM] - Re: Sun and mysql - Email found in subject

2008-01-17 Thread jmacaranas
-Original Message- From: Olaf Stein [mailto:[EMAIL PROTECTED] Sent: Thursday, January 17, 2008 12:13 PM To: Peter (MySQL List); MySql Subject: [SPAM] - Re: Sun and mysql - Email found in subject You have a point. But, facebook makes NO money at this

RE: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject

2008-01-16 Thread jmacaranas
Big fish eats the small fish.. :) Will this bring good things to MySQL? -Original Message- From: John Meyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 8:58 AM To: Brett Harvey; mysql@lists.mysql.com Subject: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject

Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject

2008-01-16 Thread Richard Heyes
Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) -- Richard Heyes http://www.websupportsolutions.co.uk Mailing list management service allowing you to reach your Customers and increase your sales. ** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND

Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject

2008-01-16 Thread Sebastian Mendel
Richard Heyes schrieb: Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) ??? why, this payment goes to current owners and investors, not to MySQL itself ... but anyway, using Suns structures and power will help of course ... -- Sebastian --

RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject

2008-01-16 Thread jmacaranas
] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Richard Heyes schrieb: Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) ??? why, this payment goes to current owners and investors, not to MySQL itself

RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject

2008-01-16 Thread jmacaranas
Subject: RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Oracle and Sun has a tight relationship right? Wouldn't there be a conflict of interest? -Original Message- From: Sebastian Mendel [mailto:[EMAIL PROTECTED] Sent: Wednesday, January

RE: {Spam?} Re: mysqldump problem with large innodb tables...

2007-06-19 Thread John Mancuso
Have you considered using the archive storage engine? I have gotten 30:1 compression using it. Create table archive_multimedia engine=Archive as select * from multimedia table John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475

Re: SPAM ?

2007-03-25 Thread Stephen Cook
http://lists.mysql.com/[EMAIL PROTECTED] that link ought to help you. Jacques Brignon wrote: 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

Re: SPAM ?

2007-03-25 Thread Banyan He
What's kind of the message you guys mentioned? - Original Message - From: LP [EMAIL PROTECTED] To: 'MySQL List' mysql@lists.mysql.com Sent: Saturday, March 24, 2007 10:13 PM Subject: Re: SPAM ? Hi, I also get the problem of keep receiving the email from the email list Regards

RE : SPAM ?

2007-03-25 Thread Jacques Brignon
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 ?

2007-03-25 Thread Banyan He
: Sunday, March 25, 2007 6:07 PM Subject: 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

RE : SPAM ?

2007-03-25 Thread Jacques Brignon
Hi, http://lists.mysql.com/[EMAIL PROTECTED] that link ought to help you Looks a bit extreme, as long as I feel there is some value to be part of this list :-). I suspect all members of the list experience the same problem; I feel it would be more valuable to solve the problem than to

RE : RE : SPAM ? SOLVED

2007-03-25 Thread Jacques Brignon
Schwartz'; 'MySQL List' Objet : RE : SPAM ? Hi, http://lists.mysql.com/[EMAIL PROTECTED] that link ought to help you Looks a bit extreme, as long as I feel there is some value to be part of this list :-). I suspect all members of the list experience the same problem; I feel

Re: SPAM ?

2007-03-24 Thread Martijn Tonies
Hi, I also get the problem of keep receiving the email from the email list Yeah, same here. I keep getting e-mail from a list that I subscribed to and confirmed my subscription for ... Dang, how do I solve that. ;) -- Martijn -- MySQL General Mailing List For list archives:

Re: *****SPAM***** Re: Aborted clients status variable seems increasing -how to tune the server to reduce the same

2006-06-16 Thread Lakshmi
Thanks Brent. I increased my wait_timeout.But now also my aborted clients seems increasing than connections.As u said most of my front end code use mysql persistent connect only.Can u clarify my one more doubt that when to use persistent connect and when to use mysql_connect and their

Re: {Spam?} Limiting results from joins

2006-06-12 Thread ddevaudreuil
How about: select * from products p inner join manufactors m on p.manufactor_id=m.manufactor_id inner join items i on p.product_id=i.product_id and i.item_updated=1 Donna Kim Christensen [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/12/2006 06:15 AM Please respond to [EMAIL PROTECTED] To

Re: [SPAM] Re: bug in simple select, what is going on?

2006-04-21 Thread kmh496
2006-04-22 (토), 00:49 +0100, Philippe Poelvoorde 쓰시길: Hi, mysql select * from user_todo_german_english where wordid = '86851' and posn = '1' and pos = 'm' AND mb_id='curious'; +-++--+--+-+ | mb_id | wordid | posn | pos | date_col

Re: [SPAM] Re: describe table : improvement

2006-04-20 Thread mysql
Thankyou Gabriel. So how does one set a column comment then? Regards Keith In theory, theory and practice are the same; in practice they are not. On Thu, 20 Apr 2006, Gabriel PREDA wrote: To: [EMAIL PROTECTED] [EMAIL PROTECTED] From: Gabriel PREDA [EMAIL PROTECTED] Subject: [SPAM] Re:

RE: [SPAM] - Re: Inner join with left join - Bayesian Filter detected spam

2006-02-22 Thread Gordon Bruce
If you want to see all of the products {even those that have never been ordered} then you need to SELECT ... FROM products ... LEFT JOIN orders I think you also have to do a LEFT JOIN on order_items And pull prod_name from products {don't know what the column name in products is}. SELECT o.id,

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

2006-01-31 Thread Jacques Brignon
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

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

2006-01-30 Thread Gordon Bruce
You can use a user variable [EMAIL PROTECTED] in the sample below} to number the rows in the result set. mysql set @row:=0; Query OK, 0 rows affected (0.00 sec) mysql select @row:[EMAIL PROTECTED], city_Name from citiesw limit 10; +--+-+ | @row:[EMAIL PROTECTED] |

RE: [SPAM] - convert help - Bayesian Filter detected spam

2006-01-19 Thread Gordon Bruce
I just added a user variable @fdata to get visabilility outside of the procedure and this is what I get. mysql delimiter // mysql create procedure test20 () -BEGIN - DECLARE fdata BLOB; - DECLARE foffset INT UNSIGNED; - DECLARE flength INT UNSIGNED; -

Re: [SPAM] - convert help - Bayesian Filter detected spam

2006-01-19 Thread Peter Brawley
Gordon, ... SELECT CONVERT(fdata,BIGINT) INTO tmp_int; SELECT HEX(tmp_int); ... Are you looking for... SELECT CAST(0xABCDEF0123456789 AS UNSIGNED); +--+ | CAST(0xABCDEF0123456789 AS UNSIGNED) | +--+ |

Re: [SPAM] - convert help - Bayesian Filter detected spam

2006-01-19 Thread David Godsey
I forgot to do reply all, sorry peter for the duplicate: Thank you for the responses to my question, however with a little poking around after the suggestions, I still am unable to do the conversion. mysql select 0xABCDEF0123456789 into @fdata; Query OK, 1 row affected (0.00 sec) mysql select

RE: [SPAM] - Re: mysql 5 - disk bound - fixed - Email found in subject

2006-01-11 Thread Gordon Bruce
One huge problem with this approach. The new table doesn't have any of the indexes that were present in the previous table. You may be better off to build a script that renames the current tables followed with the full CREATE TABLE statement(s). Do a SHOW CREATE TABLE current table; Then take

RE: [SPAM] - Adding data from one table to another - Bayesian Filter detected spam

2006-01-11 Thread Gordon Bruce
You probably want a multi table update assuming you are running at least 4.0.x. Add the column(s) to A with an ALTER TABLE UPDATE A INNER JOIN B ON (... SETA.col_name = B.col_name, A.col_name_2 = B.col WHERE .. You can copy the join structure from the

RE: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

2006-01-10 Thread Gordon Bruce
Actually CONV converts from any base to any base so if it is base 10 then just replace the 16's with 10's. Too much time looking at dump's. -Original Message- From: Bill Dodson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 3:09 PM To: Gordon Bruce Cc: Ed Reed;

RE: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

2006-01-10 Thread Ed Reed
Thanks Gordon and Bill but this has one big problem If my decimal number is 8 the result ends up, Results: +---+---+---+---+---+---+---+---+ | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 | +---+---+---+---+---+---+---+---+ | 1 | 0 | 0 | 0 | | | | | +---+---+---+---+---+---+---+---+ when what i

RE: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

2006-01-10 Thread Ed Reed
Well I solved the problem by using LPAD but it would be nice if there was a more elegant way of handling this problem. Thanks for the help. Ed Reed [EMAIL PROTECTED] 1/10/06 2:52 PM Thanks Gordon and Bill but this has one big problem If my decimal number is 8 the result ends up, Results:

Re: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

2006-01-10 Thread Francesco Riosa
And another one is (in inverse order for laziness): select (8 1) AS `0` , (8 2 1) AS `1` , (8 4 1) AS `2` , (8 8 1) AS `3` , (8 16 1) AS `4` , (8 32 1) AS `5` , (8 64 1) AS `6` , (8 128 1) AS `7` ; Ed Reed wrote: Well I solved the problem by using LPAD but it would be nice if

Re: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

2006-01-10 Thread Francesco Riosa
Francesco Riosa wrote: And another one is (in inverse order for laziness): select (8 1) AS `0` , (8 2 1) AS `1` , (8 4 1) AS `2` , (8 8 1) AS `3` , (8 16 1) AS `4` , (8 32 1) AS `5` , (8 64 1) AS `6` , (8 128 1) AS `7` ; but this one looks better: select (8 1)

RE: [SPAM] - concat string and update question - Found word(s) remove list in the Text body

2006-01-09 Thread Gordon Bruce
Try this UPDATE people SETphone = CASE WHEN LEFT(phone,4) = '405_' THEN MID(phone,5,20) WHEN LEFT(phone,3) = '405' THEN MID(phone,4,20) ELSE phone END FROM people WHERE LEFT(phone,3) = '405' AND LENGTH(phone)

RE: [SPAM] - Re: SQL Question - Bayesian Filter detected spam

2006-01-06 Thread Gordon Bruce
Why not just use the ABS Function update ev98nv_tm set mome=ABS(b) where tm.tr=tr and tm.ra=ra and tm.ke=ke and tm.moti=moti ; 12.4.2. Mathematical Functions All mathematical functions return NULL in the event of an error. ABS(X) Returns the absolute value of X.

RE: [SPAM] - Re: locating ibdata1 and *.ibd files in different directories. - Bayesian Filter detected spam

2005-12-20 Thread Gordon Bruce
The following takes a little effort, but it should get you close to dump file size. On 5.0.x you can use Information_schema.columns to get average row length for MyISAM tables. Take that plus the punctutation {~35 + 3* # cols for insert per row if you enclose your columns in 's} in the insert

Re: {Spam?} MySQL and dates puzzle

2005-10-27 Thread ddevaudreuil
I think there are four cases to consider (hopefully the picture will come through okay). starttime|--|endtime The time span in consideration *-* Case 1: ta has mtg that starts before starttime, mtg ends between starttime and endtime

RE: [SPAM] - Query help - Bayesian Filter detected spam

2005-10-11 Thread Gordon Bruce
You might try UNION with the 1st statement pulling all products with groupid = 0 and the 2nd pulling 1 product with groupid 1. -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Monday, October 10, 2005 3:31 PM To: MySQL List Subject: [SPAM] - Query help - Bayesian

RE: [SPAM?]: Case issue in Information_schema

2005-08-10 Thread Karam Chand
Thx. That answered my question. karam --- Mark Leith [EMAIL PROTECTED] wrote: Hi Karam, I'm not sure what you mean by All the tables, columns and values are given in CAPS lock... Certainly, all of the INFORMATION_SCHEMA tables and their columns are defined in upper case. This

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-26 Thread Mathias
: [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Since you can connect as yannick without password, just set it after login : mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('newpass'); see http

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-26 Thread Yannick
@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi, you should have a list in the user table of mysql database : mysql use mysql Database changed mysql show tables; +---+ | Tables_in_mysql

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-26 Thread Mathias
' to database 'mysql' mysql -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 8:35 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-26 Thread Yannick
: [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi, Sorry but you are not the administrator else you have the root password. So why search midday at 14 ? Just connect with root pass and see if mysql is here. Else mysql is like the other databases

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-26 Thread Mathias
issue. Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 4:03 PM À : [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi, Sorry but you are not the administrator else you have

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-26 Thread Yannick
; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam hi Yannick, This is my ultimate help. See this url, you have all in it : http://dev.mysql.com/doc/mysql/en/unix-post-installation.html And all you want is here : http://www.mysql.com/search/?q

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-26 Thread Mathias
account. Best regards. Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 6:25 PM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-25 Thread Yannick
] Envoyé : Saturday, June 18, 2005 2:57 PM À : mysql@lists.mysql.com; [EMAIL PROTECTED] Cc : [EMAIL PROTECTED] Objet : Re: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi yannick, Not sure if you have found the problem yet, any way there are many tutorials online which explain

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-25 Thread Mathias
, I can not create any new database That is the problem. -Message d'origine- De : Nils Valentin [mailto:[EMAIL PROTECTED] Envoyé : Saturday, June 18, 2005 2:57 PM À : mysql@lists.mysql.com; [EMAIL PROTECTED] Cc : [EMAIL PROTECTED] Objet : Re: [SPAM] - Unable to install mysql

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-25 Thread Mathias
, I can not create any new database That is the problem. -Message d'origine- De : Nils Valentin [mailto:[EMAIL PROTECTED] Envoyé : Saturday, June 18, 2005 2:57 PM À : mysql@lists.mysql.com; [EMAIL PROTECTED] Cc : [EMAIL PROTECTED] Objet : Re: [SPAM] - Unable to install

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-25 Thread Yannick
? Thanks Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 12:01 AM À : Mathias Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-25 Thread Mathias
the root password ? How can I flush the privilidges ? Thanks Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 12:01 AM À : Mathias Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-25 Thread Yannick
] Envoyé : Sunday, June 26, 2005 12:36 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Since you can connect as yannick without password, just set it after login : mysql SET

Re: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-18 Thread Nils Valentin
- De : Yannick [mailto:[EMAIL PROTECTED] Envoy : Monday, June 13, 2005 11:54 PM : [EMAIL PROTECTED] Cc : mysql@lists.mysql.com Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Kevin, Thanks for your answer. See below the results : * I' really wondering

RE: [SPAM] - discuss: user management - Bayesian Filter detected spam

2005-06-14 Thread Kevin Struckhoff
Danny, Although my experience with MySQL user management is limited to just maintaining a handful of users, I find it rather overly-complex because of the need to maintain a table of users and 'from where' they can have access, and to what databases they can have access to. For example, I just

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-13 Thread Yannick
@lists.mysql.com Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Yannick, MySQL is very picky in how it handles security, or at least different. It has an extra layer of complexity, compared to say, the Informix RDBMS, which uses the OS user/password and grant statements

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-13 Thread Yannick
having it working ut I still have this priviledge issue. BEst regards Yannick -Message d'origine- De : Yannick [mailto:[EMAIL PROTECTED] Envoyé : Monday, June 13, 2005 11:54 PM À : [EMAIL PROTECTED] Cc : mysql@lists.mysql.com Objet : RE: [SPAM] - Unable to install mysql - Bayesian

RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

2005-06-13 Thread Kevin Struckhoff
Yannick, MySQL is very picky in how it handles security, or at least different. It has an extra layer of complexity, compared to say, the Informix RDBMS, which uses the OS user/password and grant statements. With that being said, have you run the post-install steps to add users to the mysql

Re: {Spam?} Cannot start replication - can someone help?

2005-03-16 Thread gerald_clark
Chris Mason wrote: I have two servers, server5.mydomain.com and server8.mydomain.com. I want to replicate one database on server5 to server 8. I did the whole proceedure as recommended in http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set Up Replication I setup the GRANT

RE: **[SPAM]** Re: efficient query for: it's your birthday today

2004-11-18 Thread Jay Blanchard
[snip] From: Jay Blanchard [EMAIL PROTECTED] So if I index a date field (given -mm-dd) and then SELECT `userNames` FROM `userTable` WHERE SUBSTRING(`userBirthDate`, 6, 5) = SUBSTRING(NOW(), 6, 5) it is still very fast. I have a table with several thousand records in it and I get back

RE: **[SPAM]** Conditional statement: IF

2004-10-22 Thread Jay Blanchard
[snip] I'm trying to write a conditional statement in my query. Is the following possible in MySQL? IF(@SomeValue = 1) THEN SELECT The value is 1; ELSE SELECT The value is not 1; END IF I've tried different variations and nothing seems to be working (I'm getting syntax errors). I'm using MySQL

Re: **[SPAM]** Conditional statement: IF

2004-10-22 Thread Luke Venediger
Hi, Apologies, yes I have RTFM, and should've clarified my question. I actually need to do something more like this: IF(@SomeValue = 1) BEGIN THEN SELECT Data as Column1, MoreData as Column2 ELSE SELECT SomeValue is not = 1 as Error END IF Thanks, Luke Venediger. On Fri,

Re: **[SPAM]** Conditional statement: IF

2004-10-22 Thread SGreen
T-SQL style procedural scripting will not be initially available outside of stored procedures. Stored procedures are new to 5.0 (still under development) so what you want to code is not available, yet. You will have to make program branch choices in a programming language as the SQL engine

RE: **[SPAM]** Date as Primary ID

2004-10-18 Thread Jay Blanchard
[snip] How do I create table that uses timestamp in -dd-mm format as primary id (no duplicates)? [/snip] CREATE TABLE `tblFoo` ( `timeID` timestamp(14) NOT NULL, PRIMARY KEY (`timeID`), ) TYPE=MyISAM; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

RE: **[SPAM]** Backslash \ in query

2004-10-04 Thread Jay Blanchard
[snip] What's the deal w/ backslash? [/snip] It is an escape character. In order to get things with backslashes, as you have deduced, you SELECT \\ Do you have a column '\'? If so, why? Backslashes are often used in this way... SELECT businessName FROM table WHERE businessName = 'Doc\'s';

Re: **[SPAM]** Backslash \ in query

2004-10-04 Thread Jeff Burgoon
I'm populating a new table from excel sheets and for some silly reason several column values are populated with \ (not my doing!). I can easily fix the problem but I was just wondering. Thanks Everyone. Jay Blanchard [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] [snip] What's the

RE: **[SPAM]** matching people with projects via resources

2004-10-01 Thread Jay Blanchard
[snip] I'm pretty sure this is a good starting point, but that's just matching resource to resource without excluding Lincoln from building an Ark (no canvas). mysql SELECT project.proj,project.rsrc,people.name FROM project LEFT JOIN people ON project.rsrc=people.rsrc;

RE: **[SPAM]** RE: **[SPAM]** matching people with projects via resources

2004-10-01 Thread Jay Blanchard
[snip] You haven't stated the resources required for the project in the query. Try this ... SELECT project.proj, project.rsrc, people.name FROM project LEFT JOIN people ON project.rsrc=people.rsrc WHERE project.rsrc = 'wood' AND project.rsrc = 'canvas' Not tested, but limits people to thos who

RE: **[SPAM]** Help with PHP to MySQL db connection

2004-09-29 Thread Jay Blanchard
[snip] $dbhost = 'localhost'; [/snip] Try changing this to 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [SPAM]Re: e: Select distinct year from unix timestamp

2004-05-17 Thread John Fawcett
From: Paul DuBois At 17:50 -0500 5/16/04, Paul DuBois wrote: Not a huge difference, I guess. But I suppose if a query that uses one or the other of these expressions processes a large number of rows, it might pay to run some comparative testing. Another interesting point is whether one

Re: [SPAM]Re: Select distinct year from unix timestamp

2004-05-16 Thread John Fawcett
From: Paul DuBois At 22:27 +0200 5/16/04, John Fawcett wrote: Year does not operate on a unix timestamp. Sure it does: mysql select t, year(t) from tsdemo1; ++-+ | t | year(t) | ++-+ | 20010822133241 |2001 | |

Re: [SPAM]Re: Select distinct year from unix timestamp

2004-05-16 Thread Paul DuBois
At 0:25 +0200 5/17/04, John Fawcett wrote: From: Paul DuBois At 22:27 +0200 5/16/04, John Fawcett wrote: Year does not operate on a unix timestamp. Sure it does: mysql select t, year(t) from tsdemo1; ++-+ | t | year(t) | ++-+ |

Re: [OT] Autoresponders (is Re: Spam from this list)

2003-08-24 Thread Jakob Dölling
Ok, let's collect the spamming addresses: [EMAIL PROTECTED] [EMAIL PROTECTED] (The Oracle) [EMAIL PROTECTED] [EMAIL PROTECTED] -- To Unix or not to Unix. That is the question whether 'tis nobler in the mind to suffer slings and arrows of vast documentation or to take arms against a sea of

Re: Spam from this list

2003-08-23 Thread Joe Baptista
are you getting spam or an autoresponder. i rarely post to this list so lets see what happens. Joe Baptista - only at www.baptista.god Whenever we attack, they retreat. When we pound them with missiles and heavy artillery, they retreat even deeper. But when we stopped pounding, they pushed to

Re: Spam from this list

2003-08-23 Thread Thomas Andersson
Joe Baptista wrote: are you getting spam or an autoresponder. i rarely post to this list so lets see what happens. Both, when I get a 'requested' salespitch I call it spam, no matter if it was auto or not. Seems I get it for every mail I post here. Best Wishes Thomas -- MySQL General

Re: Spam from this list

2003-08-23 Thread Marc Storck
Strange, I never get those!! Marc - Original Message - From: Thomas Andersson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 23, 2003 3:41 PM Subject: Re: Spam from this list Joe Baptista wrote: are you getting spam or an autoresponder. i rarely post to this list

Re: Spam from this list

2003-08-23 Thread Yves Goergen
one doesn't even need to be subscribed to a list to get all the mail addresses. since all mails are archived and accessible from the web, a simple mail spider is sufficient. for this reason, i never use my private mail address for public postings of this kind. and as soon as i have my own mail

Re: Spam from this list

2003-08-23 Thread Nils Valentin
Hi Thomas, I report this stuff always to [EMAIL PROTECTED] and 20 minutes later its gone ;-) Best regards Nils Valentin Tokyo/Japan 2003 8 23 22:25Thomas Andersson : Hmm This is not nice.. I posted on this list, and within seconds I got spam from some phone company which was a reply to

Re: Spam from this list

2003-08-23 Thread Thomas Andersson
Marc Storck wrote: Strange, I never get those!! I've gotten 3 after 3 posts so far, bet I'll soon get my 4:th... Best Wishes Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ITS NOT SPAM - ITS AN AUTORESPONDER - WAS Re: Re: Spam from this list (fwd)

2003-08-23 Thread Joe Baptista
: Telemobile Inc. [EMAIL PROTECTED] Reply-To: Autoresponder [EMAIL PROTECTED] To: Joe Baptista [EMAIL PROTECTED] Subject: Re: Re: Spam from this list Telemobile Inc - Wireless Communication Solutions Thank you for your request. Please go to http://www.telemobile.com/ruraltelephony/ to download your

Re: Spam from this list

2003-08-23 Thread Joe Baptista
you should not bother the list with this nonsense - your concept of spam is another persons concept of managing information. Just send them an email to block autoreponder messages to this lists participants. If they can;'t comply then complain to the list manager. And this by definition is not

Re: Spam from this list

2003-08-23 Thread Joe Baptista
On Sat, 23 Aug 2003, Thomas Andersson wrote: Marc Storck wrote: Strange, I never get those!! I've gotten 3 after 3 posts so far, bet I'll soon get my 4:th... Best Wishes Thomas Now you have good reason to complain - because thats not right. An autoresponder should only send out email

[OT] Autoresponders (is Re: Spam from this list)

2003-08-23 Thread Jakob Dölling
Joe Baptista wrote: Now you have good reason to complain - because thats not right. An autoresponder should only send out email once per email address. Repeated sends is the sign of some twit not knowing how to operate an autoresponder. Yea - and very well set up autoresponders should

Re: [OT] Autoresponders (is Re: Spam from this list)

2003-08-23 Thread Joe Baptista
On Sat, 23 Aug 2003, Jakob [iso-8859-1] Dölling wrote: BTW, did anyone around here get mail from CServe containing important email addresses such as support? I got from them these mails twice to three times or so. Just wondering... i've been getting email from something called the oracle.

Re: [OT] Autoresponders (is Re: Spam from this list)

2003-08-23 Thread Tony Thomas
I've been getting autoresponders from [EMAIL PROTECTED] [EMAIL PROTECTED] (The Oracle) [EMAIL PROTECTED] On Saturday, August 23, 2003, at 12:41 PM, Joe Baptista wrote: BTW, did anyone around here get mail from CServe containing important email addresses such as support? I got from them these

Re: Spam ?

2003-03-08 Thread Gabriel TATARANU
Hi, I'm not sure what list this should go to, so I'm sending it to the general list. It's not about sql or queries it's more of a webmaster problem. Apologies to the offended. After sending several messages to the list I started receiving strange messages. It may be spam, it may be just a

Re: SPAM

2003-02-26 Thread Zak Greant
Dear Daniel, Thanks for taking an interest in spam fighting. I have passed this information on to our list manager. He will do what he can to deal with this problem. In the future, please keep several things in mind: - we do not tolerate name calling based on religeon, race, sexual

Re: *****SPAM***** confirm subscribe to mysql@lists.mysql.com

2002-11-23 Thread David Lloyd
On 23 Nov 2002 12:49:33 - [EMAIL PROTECTED] wrote: SPAM: Start SpamAssassin results -- SPAM: This mail is probably spam. The original message has been altered SPAM: so you can recognise or block similar unwanted mail in future. SPAM: See

Re: *****SPAM***** confirm subscribe to mysql@lists.mysql.com

2002-11-23 Thread David Lloyd
On 23 Nov 2002 12:54:52 - [EMAIL PROTECTED] wrote: SPAM: Start SpamAssassin results -- SPAM: This mail is probably spam. The original message has been altered SPAM: so you can recognise or block similar unwanted mail in future. SPAM: See

Re: Spam

2002-09-25 Thread Bill Easton
It seems they are using SPEWS (www.spews.org). A rude way to find out that our ISP has a problem with the IP address they gave us :-{ -- From: MySQL [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Spam Reply-To: [EMAIL PROTECTED] Message-Id: [EMAIL PROTECTED] Date: Tue, 24 Sep

Re: Spam

2002-09-24 Thread Michael T. Babcock
Gabriele Carioli wrote: -- mysql, query I wonder if you're using any RBL to avoid spam. They're quite effective, since most of spam comes from open relays or misconfigured proxies. On this note, may I beg for a meta-list for the discussing of the management of mysql.com's lists in

Re: Spam

2002-09-24 Thread MySQL
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) Date: Tue, 24 Sep 2002 12:07:14 +0200 (CEST) From: Gabriele Carioli [EMAIL PROTECTED] -- mysql, query I wonder if you're using any RBL to avoid spam. They're quite effective, since most of spam

RE: SPAM *** Audit feature in MySQL ***

2002-09-23 Thread Sqlcoders.com Programming Dept
Try http://www.mysql.com/doc/en/Query_log.html -Original Message- From: Imro Benito STROK [mailto:[EMAIL PROTECTED]] Sent: 23 September 2002 20:04 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]'; Imro Benito STROK Subject: SPAM *** Audit feature in MySQL *** Hi All, Due to

Re: *****SPAM***** Query problem

2002-08-17 Thread David Lloyd
Amit, I am trying to run the following query:- select red,green,blue from colorchanger where colorcode = select value from jobattributekit where attributekit = Color and jobnumber = 28200124RB4-001 and scenario=JN75K; It doesn't support subselects. It's having a problem with the second

Re: *****SPAM***** when I installed mysql 3.23.43

2002-08-17 Thread David Lloyd
Dave [ mysql query] when I installed mysql 3.23.43 it instructed me to be sure to add a password with the following results- : seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password' Enter password: /usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed

RE: Spam Filtered - Re: Making Unique Pairs ??

2002-02-05 Thread BICHOT Guilhem 172613
alter table your_table add unique index (path_id,word) ; -Message d'origine- De : Jon Shoberg [mailto:[EMAIL PROTECTED]] Envoyé : mardi 5 février 2002 16:40 À : [EMAIL PROTECTED] Objet : Spam Filtered - Re: Making Unique Pairs ?? HUH ? Oh well lets try again, please read below ...

Re: Spam - a possible cause ?

2002-01-13 Thread Tony Buckley
- Original Message - From: Marjolein Katsma [EMAIL PROTECTED] To: [EMAIL PROTECTED] [RegSoft/mysql] [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 12:44 PM Subject: RE: Spam - a possible cause ? Matthew, snip Spam is people not interested in MySQL at all

Re: Spam - a possible cause ?

2002-01-13 Thread DL Neil
snip Spam is people not interested in MySQL at all posting a Business opportunity (Dear mysql, Join today for FREE and a chance to win a $100 Shopping Spree at The DHS Club Outlet Center!) or Golden Investment Opportunity or Great Growth Potential stock scams. Marjolein, They sound

  1   2   >