Why don't you try like this.
F:\\devkunde\\SENDTNER\\
'\' is escape character. so you must
use '\\' to insert '\'.
Homepage = http://www.nnr.or.kr/inos/
ICQ # = 123534385
Member of DSN(database.sarang.net), NNR(nnr.or.kr)
--MIME Multi-part separator--
--
Hi again,
>From what I can see, when the driver is unloaded (I guess when my
application is shut down) it releases all handles again. But the init
shouldn't take 800.000 handles over time right? :)
/ Jens
-Original Message-
From: Venu [mailto:[EMAIL PROTECTED]]
Sent: den 19 december 200
The following should work.
INSERT INTO akoview_info
(FALL_NR,PAT_NR,NAME,VORNAME,GEB_DAT,DIAG_ART,BEFUND_NAME,UNTERSUCH_DAT,WR_I
D,WR_YEAR,WRIDX_ID,WR_QUART,BEHAND_MED,P_UID,S_UID)VALUES('01213658','546456
897','X','Aaaa','1953-12-10','5','F:\\devkunde\\SENDTNER\\BD\\20013\\1\\010027
92.001','
Y send a mysql request :
INSERT INTO akoview_info
(FALL_NR,PAT_NR,NAME,VORNAME,GEB_DAT,DIAG_ART,BEFUND_NAME,UNTERSUCH_DAT,WR_I
D,WR_YEAR,WRIDX_ID,WR_QUART,BEHAND_MED,P_UID,S_UID)VALUES('01213658','546456
897','X','Aaaa','1953-12-10','5','F:\devkunde\SENDTNER\BD\20013\1\010027
92.001','2001-
I'm new to mysql/sql thing
thus mysql can efficiently handles a database even it has a hundred tables
thanks in advance
Arvin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
On Wed, 2 Jan 2002 21:00:59 -0800 (PST), help used a few recycled electrons to
form:
| database,sql,query,table
|
|
|
|
| I am new to phpmyadmin, I need to make a db for a
| online job resume service site. This site is like
| hotjobs but people can also attach photos. I need some
| direction o
database,sql,query,table
I am new to phpmyadmin, I need to make a db for a
online job resume service site. This site is like
hotjobs but people can also attach photos. I need some
direction on where to start on this project.
Thanks
__
Do You
Hi,
I have a mysql table with columns pts_t2, pts_ext and pts_other which hold
each player's point total for that category. I have it displaying player's
ranks by ordering by each of those points. However, I would like to have an
overall ranking (all categories combined), and I don't want to add
Hi Paul,
There is no direct way to make a string by concatinating strings of
different columns. But your problem can be solved in a different way.
select distinct p.symbol, i.name from portfolio p, portfolio pp, stockinfo i
where pp.type = '401k' AND pp.owner = 'jim'
and p.symbol = i.symbol a
My compile seems to have stuck itself in a loop - just wondering
if this is normal - it's been over 90 minutes on:
make[2]: Entering directory `/local/src/mysql-3.23.47/libmysql'
/bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF
-DHAVE_RWLOCK_T -o libmysqlclient.la -rpath /usr/local/lib/mysql
Hello,
I'm having some trouble constructing my first INSERT statement into
multiple tables. I'm using PHP4. I have written the following INSERT
statement with no problems:
$sql = "INSERT INTO main (name, ext, stor_pre, stor_base, width, height,
file_size, proj_id, date_cre, cre_by, division
I'd like to submit small a patch for mysql_hotcopy. I don't know where to
go with it. I'm assuming if it's worth anything, it'll get picked up from
here and stuffed in. I'm sure others have so many tables that would max
out cp's argument list :)
422a423,430
> # the array size block below he
I'm not sure where else to look to try and figure this out, I hope someone
can help. I'm running this mysql on a 4.3 freebsd box, dual cpu with two
mysql daemons (both 3.23.40). One of the daemons is specifically set up
for my highest volume database and the other runs 3 or 4 other db apps.
For
Hello,
I've searched both the documentation and the mailing list archives but
can't find the answer to this question (although several people seem to
have asked it). Here goes: What permission grants are required to allow
use of the "backup table to ''" command? I can
execute the command as root
A link from .a.2.10.0 to just '.a'?
so that e.g.
{root}blinky:~> ls -l /usr/local/lib/libstdc++.a
-rw-r--r-- 1 root root 2153936 Dec 30 16:57
/usr/local/lib/libstdc++.a -> libstdc++.a.2.10.0{root}blinky:~> ls -l
/usr/local/lib/libstdc++.a.2.10.0
-rw-r--r-- 1 root root 2153936
I checked the archives for this list and saw that in 2000 Sergei recommended changing
GWS_IN_USE to GWS_IDF to disable the 50% weighting mechanism.
The MySQL manual, however says to change it from GWS_PROB to GWS_FREQ.
I'm inclined to go with the developer instead of documentation ;), but I'm w
With InnoDB tables under 3.23.4x, if you perform an ALTER TABLE on
a table, any foreign key declarations that point to that table fail
to work (they always return a failure).
Is this a known bug? I don't see it on the InnoDB todo or bug
list, but I seem to remember hearing about it already.
* P
I have a mySQL table which has about 15 fields. Is it possible using a
standard SQL statement to do a full text search on all fields ??
Please advise
Thanks,
Neil
-
Before posting, please check:
http://www.mysql.com/manual.
Hi!
>On Thu, Dec 27, 2001 at 06:56:03PM +0200, Heikki Tuuri wrote:
>> * Recovery has been made more resilient to corruption of log files.
>
>Can I ask what you mean here? If the log files are corrupt, is
>recovery still possible then? Or are the log files themselves less
>likely to get corrup
I just downloaded the 3.23.47 source for mysql, and I tried to compile
it using Sun's Forte Compiler (6.2) however when trying to build
libmysql/hash.c I got the following error.
/opt/SUNWspro/bin/cc "-DDEFAULT_CHARSET_HOME=\"/opt/mysql/3.23.44\""
"-DDATADIR=\"/opt/mysql/3.23.44/var\""
"-DSH
> configure:1592: checking whether the C++ compiler (c++ ) works
> configure:1608: c++ -o conftest conftest.C 1>&5
> ld: fatal: library -lstdc++: not found
> ld: fatal: File processing errors. No output written to conftest
{root}blinky:~> ls -l /usr/local/lib/libstdc++.a.2.10.0
-rw-r--r--
Phillip B. Bruce writes:
> Simple question. What is the largest hardware implementation
> that is know for mysql to run on? How well does mysql scale
> on large platform systems such as Sun E10k, HP Superdome as
> an example.
I would suppose that the number of possible file descriptors
I am developing a web-based mysql platform on Red Hat linux 7.2. The server
will host apache as well, but it is only for development purposes, and I am
the sole developer. Mysql and apache will be the only services running
besides minimum OS requirements. What can I get away with while not having
Hi,
Simple question. What is the largest hardware implementation
that is know for mysql to run on? How well does mysql scale
on large platform systems such as Sun E10k, HP Superdome as
an example.
--
*** Phillip B. Bruce
mysql database
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
mysql database
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
I'm currently in the preliminary planning phases of a content
delivery system. We will be generating pdfs on the fly containing our
member's statements. The system will be accessible both from our
internal systems and through our web-banking po
mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PR
I think this is more what you are looking for
UPDATE shpr_rcvr SET directions = REPLACE(directions,'#','No. ' where
directions = '#';
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 5:26 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Su
On 1/2/02 at 3:32 PM, Robert Alexander wrote:
> I'd suggest checking to see if you (or the user MySQL is running as)
> have the necessary permissions to alter or rename a file in that
> directory.
Some additional details. I can usually perform at least one ADD COLUMN
successfully before I start
On Thu, Dec 27, 2001 at 06:56:03PM +0200, Heikki Tuuri wrote:
> * Recovery has been made more resilient to corruption of log files.
Can I ask what you mean here? If the log files are corrupt, is
recovery still possible then? Or are the log files themselves less
likely to get corrupted? I'm a
On Wed, Dec 26, 2001 at 04:23:46PM -0600, Philip Molter wrote:
> Are there guides out there for configuring these things? What is
> a "big enough" log file? Honestly, on a lot of stuff, I'm just
> guessing, but it takes a lot of time to fiddle with values, clean
> out the database, and then shov
I have been getting this same error. I am not able to Alter or Drop Tables.
I am definately sure that I have the necessary permissions. This has
happened on all of my recent installs of MySQL on windows XP and 2000
advanced server. I would appreciate any knowlege on this matter. Getting
tired of s
I'd suggest checking to see if you (or the user MySQL is running as) have the
necessary permissions to alter or rename a file in that directory.
/Rob
At 12:16 -0800 2002/01/02, Fletcher Sandbeck wrote:
>This is with MySQL 3.23.42-nt on Windows 2000.
>
>I am issuing the following SQL statement a
[EMAIL PROTECTED] wrote:
>UPDATE shpr_rcvr SET directions = 'No. ' where directions = '#';
>
>That should do it :)
>
Thanks for the responce however it does not work. Nothing gets change
probably becasue no directions columns are ='#' there are just a lot of
them with '#' in the field among
Hi,
> -Original Message-
> From: Lew Schwartz [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 02, 2002 11:58 AM
> To: [EMAIL PROTECTED]
> Subject: ODBC for newbie
>
>
> Are there any odbc how-to's, tutorials, samples and/or resources I could
> look at? I'm new to mySQL.
> -Lew
>
MyO
Hey Hank, guess what?It worked.
Thanks for the nudge. Adding the symlink did exactly the expected things, and 4.0.1
is now launched. Now I wonder what the actual *cause* of the problem is...
Thanks, buddy, all the best,
/Rob
At 14:27 -0500 2002/01/02, Hank Leininger wrote:
>On 2002-0
This is with MySQL 3.23.42-nt on Windows 2000.
I am issuing the following SQL statement and getting back an error message.
ALTER TABLE Database.Table ADD COLUMN Field VARCHAR(255)
error: 7, Error on rename of '.\Database\Table.MYI' to
'.\Database\#sql2-538-1.MYI' (Errcode: 13)
A CHECK TABLE of
There are a couple of potential things you could change.
Dan,
1. On the MySQL end, there is a configuration value or two for timing
out sleeping MySQL queries - by default the timeouts are set to be 8
hours. You can make the timeouts less in my.cnf - However, be careful.
You may have connecti
It helps if you restart the mysql service after you make a change!
Sorry for the spam.
Kevin Ailes
Administrator
OTTO Engineering
> -Original Message-
> From: Ailes, Kevin
> Sent: Wednesday, January 02, 2002 11:02 AM
> To: '[EMAIL PROTECTED]'
> Subject: bind-address argument
>
Are there any odbc how-to's, tutorials, samples and/or resources I could
look at? I'm new to mySQL.
-Lew
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (th
You could just do this:
$result = ($sql3);
echo "$result";
- Original Message -
From: "Michael Brunson" <[EMAIL PROTECTED]>
To: "Matt Rudderham" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 02, 2002 1:35 PM
Subject: Re: Could you look at this PHP/MySQL Code?
> On
This sounds like it could be a caching issue. Are you running a Windows or
UNIX-based machine? Each should have methods to track what processes are
using memory and how much memory they are using.
- Jonathan
-Original Message-
From: Dan Liu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, Ja
It's mysql_query($sql3) not mysql_result($sql3)
- Jonathan
-Original Message-
From: Matt Rudderham [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 11:31 AM
To: [EMAIL PROTECTED]
Subject: Could you look at this PHP/MySQL Code?
Hi,
This is generating an error:
Warning: Wro
Anyone have any ideas as to how I should handle a case
of the following error?
020102 13:27:28 Slave: Failed reading log event, reconnecting to retry, log
'db1-bin.008' position 1064155638
020102 13:27:28 Slave: connected to master '[EMAIL PROTECTED]:3306',replication
resumed in log 'db1-bin
D'oh. Meant to call mysql_query! Thanks!
- Matt
"Bonum volens duceris in Tartarum"
> -Original Message-
> From: Michael Brunson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 02, 2002 3:36 PM
> To: Matt Rudderham
> Cc: [EMAIL PROTECTED]
> Subject: Re: Could you look at this PH
On Wed, 2 Jan 2002 15:30:51 -0400, "Matt Rudderham" <[EMAIL PROTECTED]> wrote:
| Hi,
| This is generating an error:
|
| Warning: Wrong parameter count for mysql_result() in
| /usr/local/www/html/matt/add.php on line 27
|
| I can't figure out what the problem is, here is the code in question, i
Hi everyone,
when we execute queries through MySQL using PHP, a significant amount of memory is
being used in the process. We have noticed that the memory is not being released
again for several hours. Despite attempts to force it to release memory in the code,
the problem is still occuring.
Hi,
This is generating an error:
Warning: Wrong parameter count for mysql_result() in
/usr/local/www/html/matt/add.php on line 27
I can't figure out what the problem is, here is the code in question, it
is part of an HTML form:
<--Snip connect etc.. -->
// process form
$sql = "INSERT INTO m
On 2002-01-02, Robert Alexander <[EMAIL PROTECTED]> wrote:
> When I go to launch, it gives me the "Starting mysqld daemon with
> databases..." etc. message. It then fails immediately with the message
> "mysqld ended."
> Here's the content of the error file in the data directory:
> /usr/local/my
Goran Krajacic writes:
> In my program i first make a lot of REPLACEs (1 and even more) and
> immediately after that i make a SELECT on the same table.
> Is it posible that MySQL messes up and makes the SELECT before the last
> REPLACE is done?
>
> Thanks
> Goran
>
No , it is not possible,
In my program i first make a lot of REPLACEs (1 and even more) and
immediately after that i make a SELECT on the same table.
Is it posible that MySQL messes up and makes the SELECT before the last
REPLACE is done?
Thanks
Goran
---
"Ailes, Kevin" a écrit :
>
> I have two NIC's with two different IP addresses on the machine that has the
> mysql server running on it.
>
> When I set up the bind-address argument(using winmysqladmin ver.1.1) under
> the my.ini tab to bind to specifically one of the NIC's, it appears to have
> r
non data driven menus not an option? I have buit java-script menus that are
pretty cool
- Original Message -
From: "Jonathan Hilgeman" <[EMAIL PROTECTED]>
To: "'Victor Spång Arthursson'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, January 02, 2002 11:02 AM
Subject: RE: Imple
Hi:
Do you have any documentation for the required files, registry changes, etc.
for deploying MySQL with an executable developed in Delphi?
Thanks,
Mike Frederick
-
Before posting, please check:
http://www.mysql.com/manual
This might help:
http://php.sitecreative.com/faq.php#3
- Jonathan
-Original Message-
From: Victor Spång Arthursson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 8:59 AM
To: [EMAIL PROTECTED]
Subject: Implement a menu structure using an relative database
Hi!
I'm currentl
I have two NIC's with two different IP addresses on the machine that has the
mysql server running on it.
When I set up the bind-address argument(using winmysqladmin ver.1.1) under
the my.ini tab to bind to specifically one of the NIC's, it appears to have
registered that it is a valid argument.
Hi!
I'm currently working on a menu system for web pages, but I've run into
some problems...
What I'ld like to create is a menu which can "host" an infinite number
of submenus. Further more, every menu should also be able to link to a
specific file, though not always used.
I would like to be
I'm trying to use mysqlshow to display the tables of a database on a
remote host. I enter the command:
localhost:/usr/local/mysql$ ./bin/mysqlshow -h 555.55.5.5 -p samp_db
Enter password:
Wildcard: samp_db
+-+
| Databases |
+-+
| samp_db |
+-+
localhost
Should be something like
Select Status, Date from Table where Status <> "closed" or Date > now()
- 14
(This is from memory so please dont rely on the syntax ;-)
HTH,
Chris
--
Christian Pfeiffer
Smart-Link Gesellschaft für EDV-Systemlösungen mbH
Herforder Str. 5-7 www.smart-lin
use a REGEXP:
http://www.mysql.com/doc/R/e/Regexp.html
- Jonathan
-Original Message-
From: julian haffegee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 01, 2002 2:11 PM
To: [EMAIL PROTECTED]
Subject: where
Hi,
I have recently gained access to mysql (new isp), and am converting my
SELECT * FROM table WHERE (Status != "closed") OR ((Status = "closed") AND
(Date > Now - # of seconds in 2 weeks))
That should work if your Date field is just a regular timestamp. It all
depends on how you're storing the date...
- Jonathan
-Original Message-
From: Chris Boget [mailto:[E
Mike Frederick writes:
> Hello:
>
> I am testing a new product with MySQL, and so far have been very pleased,
> especially with the performance. One enhancement that I was looking forward
> to in 4.0 is described below:
>
>
> Updates that run over multiple tables is harder to do in MySQL. This
Hello:
I am testing a new product with MySQL, and so far have been very pleased,
especially with the performance. One enhancement that I was looking forward
to in 4.0 is described below:
Updates that run over multiple tables is harder to do in MySQL. This will,
however, be fixed in MySQL 4.0 wi
question,
i am using perl DBI and have a query from a table called usernames. here is
the query...
$sth2 = $dbh->prepare("select * from usernames where state =
$quoted_the_state order by $the_sort_criteria limit $point, 25") ;
i then execute the query, pulling off various columns...
$array_r
Hi all,
Downloaded the binary distribution of 4.0.1 for Linux, and am attempting to launch on
an HP laptop with RedHat 7.0. This will replace my already functional installation of
3.23.46.
When I go to launch, it gives me the "Starting mysqld daemon with databases..." etc.
message. It then f
Peter Zaitsev writes:
> Hello mysql,
>
>
>
> I've found the following problem often happens to me:
> Then mysqld restarted unclear (sigsegv or server reset) the mysql
> client library may hang during the automatic reconnect. The backtrace
> is similar to this and does not changes other time (at
I've looked through the docs and I couldn't find out how
to do this. If you can point me to the right place in the
documentation so I can read how, that would be great. If
you could give me a little sample query to start from, that
would be great as well.
I've 2 columns in a table. "Status" and
Is this too simple?
select distinct p.symbol, i.name from portfolio p, stockinfo i
where p.symbol = i.symbol
and p.type = '401k'
and p.owner='jim'
order by p.symbol
-
Tom Haapanen -- Software Metrics/Equitrac Corp.
Advanced Printing Solutions -- http://www.metrics.com/
-Original Me
How would one load the results of the following query into a one line comma
separated list so that it could be then included with an IN expr to get
around the lack of subselect in MySQL
select distinct symbol from portfolio where type='401k' AND owner='jim'
select distinct p.symbol, i.name f
I noticed that STD() returns the sample standard deviation,
which is the sensible thing for it to do. However, when
working with data points sampled from a larger population
(or a distribution), it's a bit of a hassle to type
STD(x)*COUNT(x)/(COUNT(x)-1), and I noticed that Oracle has
a function
Hello,
anybody tryed %subj% ???
I have problem - module doesn't work.
I must recompile mysql with some directive like --lpam or --enable-pam
??
Michal
table, query, sql
-
Before posting, please check:
http://www.mysql.c
Hi,
I have the following error while excuting a sql INSERT query:
"Commands out of sync; you can't run this command now".
What king of error is this?
--
Ir Pascal Francq
Researcher
Université Libre de Bruxelles
CAD/CAM Department
Avenue F.D. Roosevelt, 50
CP 165/14
B-1050 Brussels
BELGIUM
T
[EMAIL PROTECTED] writes:
> >Description:
> See earlier emails from me. Same problem.
> >How-To-Repeat:
> >Fix:
> >Submitter-Id: [EMAIL PROTECTED]
> >Originator: [EMAIL PROTECTED]
> >Organization: Auctionwatch.com
> >MySQL support: login
> >Synopsis:Mysql crashing.
> >Severity:cri
### CHANGES ###
--- version 15.4 ---
The sensors module for hardware monitoring (requires lm_sensors) and
interrupts Linux module were added.
Thresholds are now internally ordered when checked to allow color
gradient effects.
The modules management dialog boxes were redesigned for easier u
Thanks for all the help with counting up numer. values.
Thanks also to Richard, and Eskom for providing us the power to drive not
only our PC's but also powering solutions to our DB problems ! ;-)
Regards
Anton (JHB, RSA)
Richard Ellerbrock writes:
> select sum(colnam) as x from table w
>> I am trying to add floating point numbers, and also plain
>> numerical values,
>> - I have looked on mysql.com but I only seem to find stuff that
>> relate to
>> counting rows of a certain defined value - like count where something =
>> something, but I want to say "give me a numerical total v
I am trying to add floating point numbers, and also plain numerical values,
- I have looked on mysql.com but I only seem to find stuff that relate to
counting rows of a certain defined value - like count where something =
something, but I want to say "give me a numerical total value" for a col
How about something like this ?
SELECT * FROM log_data_sig AS l1 LEFT JOIN log_data_sig AS l2 ON l1.user =
l2.user WHERE l1.type="join" AND l1.user=EXTERNAL_USER_ID AND
l2.type = "sign" AND l1.timestamp < l2.timestamp ORDER BY l1.timestamp DESC
LIMIT 1;
Terje K
> -Original Message-
> Fr
Hi Cindy,
SELECT Inventory.*, Customer.Name from Inventory Left Join Customer on
Inventory.PurchasedBy = Customer.ID
where Inventory.PurchasedBy = Custormer.ID;
Your query is an equi-join query, which means that there should be data
for only those rows for which the equality in
the w
>Description:
<# ./scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
./scripts/mysql_install_db[292]: 16797 Memory fault(coredump)
Installati
Dear Luke and all,
Thanks Luke... my problem was solved !
Also, I would like to say thanks for all of you who try to help me before !
THANKS A LOT ! Thanks again!
Best regards,
Kevin Chan
< Luke Wrote>
> Sounds like you don't have permission to execute the file mysql in
> /usr/local/mysql/bin.
Dear Steve and all,
Thanks Steve !
Yes Steve, I have no problem to run MySQL with user - 'kevin' when I use
root telnet to server and the example as below:
# pwd
/usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin
#
# ./mysql -h192.10.0.113 -ukevin -p
Enter password:
Welcome to the MySQL monitor.
Hi,
I faced the same problem, but the solution to this is you is you add as many
qualifiers as you can (i'm sure there are more elegant ways to do it but it
works for me:-))specfiy the qualifiers FOR BOTH the tables you are picking
data from in the where clause :
For Example :
as you said lets co
When I try to run mysql_real_connect my program crashes. If anyone
could help me understand why I would be eternally grateful. I've
tried looking at all the documentation regarding this situation and
tried many different things, but I am still stumped with the same
crash. I've tried this on cu
> Thanks Jaime to reply me message so fast !
> I would like to set 2 different user to maintance MySQL machine.
> 1st user can maintance the Unix box and MYSQL program
> 2nd user ONLY can maintance the MySQL program
Kevin, this should be solved at the MySQL user permissions level,
not at the UNI
86 matches
Mail list logo