Hi,
Can anyone help me that i want to view all the record from a table, but in mysql
control centre, i only can view the first 1000 records, can anybody teach me how to
make it can view for all the rest of the records?
Thank u.
regards,
florence
Thank you very much.
regards,
MySQL CC is a beta version, I can't find an option to set this max value.
Maybe its an option for you to use the command line functions? There is no
maximum of the viewed records.
Hans
At 09:02 10-2-2004, you wrote:
Hi,
Can anyone help me that i want to view all the record from a table,
Date: Tue, 10 Feb 2004 09:13:02 +0100
To: florence florence [EMAIL PROTECTED]
From: Hans van Dalen [EMAIL PROTECTED]
Subject: Re: Sql control centre - How to view all the records for a table?
If you right click the table then you can choose: Return limit. At that
moment you can give your own
Hello,
Using MySQL 4.017 on Win2k sp3:
using MySQL built-ins:
how can I convert a
value stored as a hexadecimal string back to
a binary string while logged into the shell?
set @t1=616263;
select 0x616263;
how can I turn @t1 back into 0x616263? What is
the syntax? I tried
Scott Taylor [EMAIL PROTECTED] wrote:
I've been getting this error in myPhpAdmin.
Database /mydb/ - table /testing_table/ running on /localhost/
*Error*
SQL-query :
FLUSH TABLE `testing_table`
MySQL said:
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Hi
i am using mysql 4.0.16 for my applications and it has around 10
records .if i move the data from mysql 4.0.16 to 4.0.17 will that create any
inconsistancy .
in my database.
does mysql provide anytool to migrate data from mysql4.0.16 to 4.0.17
- Original Message -
From: [EMAIL
Rick Robinson [EMAIL PROTECTED] wrote:
Is the myisampack utility supposed to be included in the 4.1.1 binaries for
Windows? It's not there - I couldn't find any explicit reference in the doc
about whether this is deliberate or maybe it was just missed?
You are right, myisampack is missing
Liying Huang [EMAIL PROTECTED] wrote:
I tried to create replication. I have edited my.cnf on master and slave side.
Grant necessary privileges on master side, then start both servers, when I update
the database in master side, I could see the query showed up in ***-bin.001,
and it is
Hello
I would like to create a user that can create databases and do all the
necessary changes to it(select, insert, update, delete...), view all
database that he has been granted to see by other users except the
mysql.* I have created 1 user with the grant method but he can see all
the tables
naveen [EMAIL PROTECTED] wrote:
Hi
i am using mysql 4.0.16 for my applications and it has around 10
records .if i move the data from mysql 4.0.16 to 4.0.17 will that create any
inconsistancy .
in my database.
does mysql provide anytool to migrate data from mysql4.0.16 to 4.0.17
To be
Hi,
I could not find the binary for SCO Unixware (Intel based) in download
section. I suppose mysql supports this environment too. May I know as to
where can I find this binary. Do I need to build this myself?
TIA
Regards,
Anup Mahansaria
--
MySQL General Mailing List
For list archives:
Thanks for the info. I think the easiest thing is to re-design the
underlying forms. I use a database independent development platform, which
generates sql for me from the form. This application has to run on various
DB's (Access, MS SQL Server, MySQL, Oracle, etc)
It's a good learning
Sven,
are you using the UTF8 charset? Then a single character may use up to 3
bytes. Since MySQL cannot work with index columns longer than 255 bytes, for
columns CHAR(86) or longer, MySQL must define a 'column prefix' index, if
you define an index on the column. That is, MySQL internally creates
Heikki,
yes, actually I use the UTF8 character set. Thanks for your
clarification and the workaround!
A few comments:
- For e-mail-addresses it's ok to set the column's character set to
latin1. And in case I need UTF8 support in a referenced VARCHAR, I'll
limit it to 85 characters. But about
Hello,
I am running a DB on a machine in which I am developing on. Then I have been copying
the contents of ~mysql/data/databasename to another box where I am running my code.
All the data I modify copies well, and I can run on my production box with no
problems. Except for binary blob data.
Does anyone know any FREE tool to migrate Oracle databases and schema to MySQL 5.0? I
know one such tool, Oracle-to-mysql which is not free though.
Thanks
Raza
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Sven,
yes, the error message is misleading. And we must get longer CHARs and
VARCHARs to MySQL. It is not good to silently change internal index
definitions!
I guess that 4-byte UTF8 characters are not needed. You can code 16 million
characters with 3 bytes. That should be enough for all
Hmmfor practical purposes:
1. MySQL is going to cost you a lot less, no matter which way you do things.
2. MySQL is going to perform better for the vast majority of workloads.
The only place where MS SQL Server *might* have an advantage is in
situations where it's additional language
Hi!
If memory serves me correctly, MySQL AB have stopped issuing SCO
OpenServer and SCO UnixWare binaries publicly and will only be providing
them to customers who take out commercial licences. This is probably due
to the fact that OpenServer and UnixWare cost a lot compared ot other
OSes,
Are you just copying the files? I'd suggest using mysqldump if you are
not already..
On Tue, 10 Feb 2004, Scott Purcell wrote:
Hello,
I am running a DB on a machine in which I am developing on. Then I have been copying
the contents of ~mysql/data/databasename to another box where I am
I have a table where I need to group the content on a timestamp. Any
record that is less than say 5 minutes from any other record needs to
be grouped with that other record.
ID timestamp
1 2004-02-02 12:00:00
2 2004-02-02 12:00:05
3 2004-02-02 12:05:20
4 2004-02-02 12:15:00
5
I only replicate the simplest, master-slave.
I used MySQL 4.0.11 version in both PCs.
Liying
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 5:32 AM
Subject: Re: question about replication
Liying Huang [EMAIL
Hi all!
I remember reading a number of articles on Jeremy Zawodny's website
regarding FreeBSD and Linux performance as it relates to MySQL. At the
time of publication, it seemed that Linux's native thread library had
quite an advantage over FreeBSD's (but FreeBSD included LinuxThreads
Hi,
I have used MySQL 4.0.17-max-debug for windows in win 2K SP-4
I would like to know Is there any impacts we may have to
met using Alpha release before the release of production version.
why we have different types of mysqld?
mysqld
mysqld-opt
mysqld-nt
mysqld-max
Heikki Tuuri wrote:
I guess that 4-byte UTF8 characters are not needed. You can code 16 million
characters with 3 bytes.
Yes. But is that also the case if you use the UTF-8 encoding
scheme, or can that scheme code less characters with 3 bytes?
http://ln.hixie.ch/?start=1064324988order=-1count=1
Hi Chris,
I understand that you like MySQL but ...
Hmmfor practical purposes:
1. MySQL is going to cost you a lot less, no matter which way you do
things.
This is a pretty bold statement. Can you back this argument with
some references regarding TCO and development time for a particular
I'm pretty new to mySQL so there might be an easy way of solving this
(hopefully)
Is there a way to create something akin to an Oracle Sequence in mySQL ?
I know of the autonumber feature. The problem is that the table that will be
using the key won't actually be using it as a unique pk. The pk
Well, I gave it a shot, but for some reason, the dump caused my command window to die,
while screaming.
The database is owned by a user with a password, so I typed the following:
mysqldump databasename --user=xx --password=
It started doing something, but like I mentioned, the
By default mysqldump just dumps to stdout.. so you need to (pipe) it to
a textfile.. the correct syntax, you need to put the database name after
the username/password (after the mysql options)
.. give that a shot.. most likely all the garbage/output wacked out your
session..
On Tue, 10 Feb
You're right - you can only code 65,536 characters with 3 UTF-bytes.
U- - U-007F: 0xxx
U-0080 - U-07FF: 110x 10xx
U-0800 - U-: 1110 10xx 10xx
Once you want to go higher than U-, you need up to 6 bytes:
U-0001 -
Sure, try this. I'm using 4.1.2 in case it matters.
set @n=0;
UPDATE Ranks_table
SET Rank= (select @n:[EMAIL PROTECTED])
ORDER BY Score DESC;
Ed
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, February 09, 2004 6:37 PM
To: [EMAIL PROTECTED]
Subject:
What is the maximum number of tables allowed in a join for MySQL 4.0.x?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ah that's sheer genius!
Thanks muchly, I never figured in to being able to use SQL with it's own
variables so to speak - I'm sure I'll find more than one use for this new
ability!
Much appreciated Ed :)
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL
In the last episode (Feb 10), Andrew Loughe said:
What is the maximum number of tables allowed in a join for MySQL
4.0.x?
It's not in the docs as far as I can see, but the feature comparison
page says 31: http://www.mysql.com/information/crash-me.php?res_id=49 ,
search for tables in join.
--
On 2004-02-10, at 16.21, Brian Power wrote:
I'm not sure if it is possible to do with a group by
Say you had
1 2004-02-02 12:00:00
2 2004-02-02 12:00:05
3 2004-02-02 12:00:09
4 2004-02-02 12:00:12
this would require 1,2 and 3 in one group and
2,3,4 in another. My understanding is that
At 05:38 PM 2/6/2004, you wrote:
In MySql is it possible to repeat through a month, for example I would like
to
Select count(user) from table where date = x
However, I want x to be a range from the first of the month to the last day
in the month, I of course would need to pass in a month and year
Gordon [EMAIL PROTECTED] wrote:
Sorry for the repost, but I just realized that the index information for
key 3 did not get copied into the 1st email.
This sounds very similar to the bug:
http://bugs.mysql.com/bug.php?id=2446
-Original Message-
From: Gordon [mailto:[EMAIL
Hello,
I tried to migrate a database from a MySQL-4.0.14 to another
one hardware with MySQL-4.0.17 installed.
The database has InnoDB tables and I just executed a:
# mysqldump -A --user root --password=my_password dump_db.txt
in the old server (MySQL-4.0.14) and
# mysql -u root -p
hi all,
I have a question about the block size of the file system for mysql and
this on a UFS file system.
What is infact the best block size for the database i am using myisam and
innodbase as table types.
Could you please help me on this
Filip
--
MySQL General Mailing List
For list
Hi Chris,
It seems that whenever we both comment in a thread, you enlighten me
greatly!
;-) ... I'm learning more about MySQL with every post. Ok, maybe
not every post, but still ... *g*
I tend to be a critic sometimes, but I'm a really nice guy. Believe me on
this one ;-)
1. MySQL is going
Hi,
Hi,
Can anyone help me that i want to view all the record from a table,
but in mysql control centre, i only can view the first 1000 records, can
anybody teach me how to make it can view for all the rest of the records?
Click with the right button in the table´s name - Open table -
I have tried to upgrade mysql to 4.0.17 version, still
have the same problem. All queries shown in relay-bin
file at slave, but slave database is not updating. I
read documentation, but can't find helpful information
on this.
Liying
--
MySQL General Mailing List
For list archives:
Greetings,
I've been looking at the backup/recover related discussions in the list
archives for a while. Seems to me most people use either mysqldump or
mysqlhotcopy. We don't have a good MySQL backup scheme in place yet. Now
I have some questions based on my reading.
How do I know how each
Ok. I think I am close to getting this. Here is what I have.
MYSQL=/usr/local/mysql/bin/mysql --user=$username --password=$password
--host=$server cetechnology
RESULT=$(echo select count(*) from hardware_assets where
ethernet_address='$ethernet_address' | $MYSQL)
if [ $RESULT = 0 ] ; then
Hi,
I'm a relative newbie at MySQL (Oracle DBA implementing MySQL in a
production environment). There does seem to be a lack of 'Best
Practice' documentation for MySQL in a production environment.
I opted for using both mysqldump and mysqlhotcopy. Disk is cheap and
everything is automated so
Good morning:
What is the proper method of creating ibdata files with mysqld_multi?
Using mysqld_multi the second server started, but just created one
ibdata file instead of four, which I have indicated in the second servers'
my.cnf file located in its data dir.
Also, I was unable to log
SQLyog - www.webyog.com is NOT FREE but has a very
good ODBC import tool for $49 and it includes lot of
other poerful tools. You might check it out.
You can try it out for 30days before purchasing it.
karam
--- Ansari, Raza (GEI, GEFA) [EMAIL PROTECTED]
wrote:
Does anyone know any FREE tool to
Why do you keep changing the script?
Mike Tuller wrote:
Ok. I think I am close to getting this. Here is what I have.
MYSQL=/usr/local/mysql/bin/mysql --user=$username --password=$password
--host=$server cetechnology
RESULT=$(echo select count(*) from hardware_assets where
RESULT=`echo se;ect
You would use a concept called auto-increment, and you can create it when
you create your tables:
CREATE TABLE animals (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id)
);
More information here:
On 10-Feb-2004 [EMAIL PROTECTED] wrote:
Hi all, I'll just get straight to the problem (simplified):
Say I have the following table/columns:
ID, Score, Rank
1, 20, 0
2, 50, 0
3, 10, 0
4, 5, 0
5, 97, 0
Is it possible, in a single query (using sub-queries if necessary),
to give
all of
Hi,
I want to create a table with composite Primary key.How to do that?
create table ipdet
(IPaddress varchar (14) not null ,
hostid varchar (20) not null primary key (ipaddress,hostid),
IP_DESC text ,
MAC text,
interface text);
thx-seena
-
Do
Create a unique index of the two fields. Primary key is one column only.
That should take care of it.
P
-Seena Blace [EMAIL PROTECTED] wrote: -
To: [EMAIL PROTECTED]
From: Seena Blace [EMAIL PROTECTED]
Date: 02/10/2004 01:25PM
Subject: COMPOSITE PRIMARY KEY?
Hi,
I want to create a
Okay, the lack of locking was driving me crazy. Here's my
version:
#!/usr/bin/sh
MYSQL=mysql -v test
ethernet_address=$1
cat EOF | $MYSQL
LOCK TABLES hardware_assets WRITE;
SELECT @asset_id := asset_id
FROM hardware_assets WHERE ethernet_address = '$ethernet_address';
REPLACE INTO
Seena Blace wrote:
Hi,
I want to create a table with composite Primary key.How to do that?
create table ipdet
(IPaddress varchar (14) not null ,
hostid varchar (20) not null primary key (ipaddress,hostid),
IP_DESC text ,
MAC text,
interface text);
Try this:
create table ipdet
Bing Du wrote:
Greetings,
I've been looking at the backup/recover related discussions in the list
archives for a while. Seems to me most people use either mysqldump or
mysqlhotcopy. We don't have a good MySQL backup scheme in place yet. Now
I have some questions based on my reading.
We use
On Tue, 2004-02-10 at 08:38, Martijn Tonies wrote:
* Assuming that my points below regarding performance are correct (I'm
sure that Heikki will stand by InnoDB and back up anyone preaching it's
performance benefits), the lower hardware costs are an important factor
(as in lower for a
On 10-Feb-2004 Seena Blace wrote:
Hi,
I want to create a table with composite Primary key.How to do that?
create table ipdet
(IPaddress varchar (14) not null ,
hostid varchar (20) not null primary key (ipaddress,hostid),
IP_DESC text ,
MAC text,
interface text);
At 10:25 -0800 2/10/04, Seena Blace wrote:
Hi,
I want to create a table with composite Primary key.How to do that?
create table ipdet
(IPaddress varchar (14) not null ,
hostid varchar (20) not null primary key (ipaddress,hostid),
IP_DESC text ,
MAC text,
interface text);
On Tue, 2004-02-10 at 07:47, Dan Nelson wrote:
In the last episode (Feb 10), Andrew Loughe said:
What is the maximum number of tables allowed in a join for MySQL
4.0.x?
It's not in the docs as far as I can see, but the feature comparison
page says 31:
Hi,
I have 10 tables which I want to migrate from windows mysql(V4.0.17) to red hat
mysql(V3.23.54).How to do that pl? Some tables are having real data also.
thx -seena
-
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online
mysqldump is for dumping the file.
you can load it with specifing FILE yourfilehere
Read the manuals for more information,
Also, try to search on the website www.mysql.com a little more before asking
things here.
I got the feeling that when you feel a itch, you ask what it is, that is not
bad,
Hello,
I posted about this probably a year ago or so... We run a replication
slave on each of our frontend web servers (4.0.17 RPM). When a large
number of updates happen on the master, it kills the performance of the
web servers while getting caught up. With our application, it doesn't
matter
I'm trying to get a fixed entry date using two
DATETIME fields (dt_update, dt_create).
The first DATETIME field (dt_update)
automatically updates each time the record is
modified, the second DATETIME field (dt_create)
doesn't.
I've been able to get it using this:
INSERT INTO `test` SET
Hello Mysql listers,
I have a mysql db running on a Slackware Linux box. I have an Apache
webserver running on a Red Hat Enterprise box. (Mysql 4.0.15a, apached
2.0, php 4.3.2). I think (!!?) I have php on the Red hat box, version
4.3.2.
I have been trying without success to use php on
You need to install the client side of mysql on the linux box (libmysql.*)
then compile php with the mysql modules (I think they exist in RPMs)
P
-Eric W. Holzapfel [EMAIL PROTECTED] wrote: -
To: [EMAIL PROTECTED]
From: Eric W. Holzapfel [EMAIL PROTECTED]
Date: 02/10/2004 02:55PM
Hi,
I'm trying to compile MySQL 4.0.17 on SCO OpenServer 5.0.6, gcc version 2.95.3
20030406 (SCO/p4).
I always get the following error :
Undefined first referenced
symbol in file
pthread_key_delete libmysys.a(my_thr_init.o)
I'm using mySQL 4.1.1a-alpha on XP Professional. When I execute a
create table script containing a COLLATE clause, all LONGBLOB fields are
silently changed to LONGTEXT in the resulting table. This behavior does
not occur on version 4.1.0-alpha.
Is this field type change intentional? It can
Is there a rough estimate as to when it will be available? The screenshots
look awesome.
Thx,
R
Yes, you can download the package or install from RH CD:
php-mysql
http://rpmfind.net/linux/rpm2html/search.php?query=php_mysqlsubmit=Search+...system=arch=
This is required so PHP will have support for mysql functions. You
apache should be ok without changes.
Sincerely,
Szymon
Bengt Lindholm wrote:
In your example they would all be in the same group. You could say the
group delimiter is any gap between records that is 5 minutes or more. So
records would be in the same group even if the total timespan for the
group is more than 5 minutes, but all gaps between
At 01:55 PM 2/10/2004, you wrote:
I'm trying to get a fixed entry date using two
DATETIME fields (dt_update, dt_create).
The first DATETIME field (dt_update)
automatically updates each time the record is
modified, the second DATETIME field (dt_create)
doesn't.
I've been able to get it using this:
Howdy,
I'm something of a newbie, so (1)bear with me, and (2) my advice is nowhere near
authoritative...
...but I did some googling, and I managed to track down someone with a vaguely similar
problem. It would seem that that version of FSU pthreads hasn't implemented that
symbol. Solution:
Just for good measure...
...if you were wondering, Linux [okay, okay, yeah, the version with the option
compiled in, but still...] does read fat/vfat/fat32/ntfs partitions. So, if you have
the opportunity to dual boot and transfer your database to the new filesystem by
copying, that then works
I don't have much experience with MySQL server, but I am working on a
project which consists of a Java application accessing MySQL databases. The
program is packaged with the mysqld binary for Windows, and the Java program
simply executes the binary with a few options (specifically --basedir,
Hi all,
I am getting the following error. I'm pretty sure that I've set the dsn up ok but I
still cannot get the test connection to work properly.
[MySQL][ODBC 3.51 Driver] Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
The database name, host, password, username etc should
I have a DateTime data type for one of my fields. If an entry is being
INSERTed then I want the DateTime to be NOW(). I want this done
automatically and not have to set me SQL str to do this. I have tried
to set the default as NOW() but it will insert
-00-00 ... I don't want this, I want
Hello Listers,
I have a problem with my PHP/redhat setup, and possible problem with my
Mysql setup.
I have Apache (2.0) and PHP (4.3.2) installed on a Red Hat 3.0 ES system.
I have MySql installed on a Slackware linux box.
I want to be able to use Apache/PHP to connect to the mysql database on
I have never done this but...
Go to your php.ini file and see if changing the [MySQL] mysql.default_host =
is set to the database.
Respectfully,
Ligaya Turmelle
-Original Message-
From: Eric W. Holzapfel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 12:00 PM
To: [EMAIL
Never mind!
I figured it out :-)
Thanks,
-Bob
__
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Martijn Tonies wrote:
Hi Chris,
It seems that whenever we both comment in a thread, you enlighten me
greatly!
;-) ... I'm learning more about MySQL with every post. Ok, maybe
not every post, but still ... *g*
I tend to be a critic sometimes, but I'm a really nice guy. Believe me on
this
* First check if Mysql is supported by PHP
Create a file test.php with
?php
phpinfo();
?
When opening it on your web server, look for a Mysql section (should have a
Mysql Section in the PHP configuration)
* If you don't have the Mysql support, you need to recompile PHP with Mysql:
(INSTALL
Hello Guys (gals?) and the list,
Thank you very much for the tips. Your help put me on the correct path,
and I was able to install the products you suggested, and it seems
that my dummy database demo is now working. Thank you for the help.
I am a smarter newbie now!
eric
[EMAIL
On 11-Feb-2004 Eric W. Holzapfel wrote:
Hello Listers,
I have a problem with my PHP/redhat setup, and possible problem with
my
Mysql setup.
I have Apache (2.0) and PHP (4.3.2) installed on a Red Hat 3.0 ES
system.
Apache 2.0 + PHP is a known buggy combination.
I have MySql installed
I have a DateTime data type for one of my fields. If an entry is being
INSERTed then I want the DateTime to be NOW(). I want this done
automatically and not have to set me SQL str to do this. I have tried
to set the default as NOW() but it will insert
-00-00 ... I don't want this, I want
Basically, the stability of the build is dependant on the following factors:
* Suitable functions in your C library for threaded applications.
UnixWare is apparently fine in this category and doesn't require any
workarounds. Installing the latest patches and things would be in your
best
Thanks Chris. Will get back to you if I get some problem.
Regards,
Anup Mahansaria
Chris Nolan
[EMAIL PROTECTED]
I want to be able to track how many times any particular record is
returned from a search, and I have two ideas about how to do this. But
because I have little experience with MySQL, I may be totally off base.
This database is served on the web via Lasso.
Idea 1. Create an integer field in the
On Wednesday, February 11, 2004, at 03:29 PM, Keith Warren wrote:
I want to be able to track how many times any particular record is
returned from a search, and I have two ideas about how to do this. But
because I have little experience with MySQL, I may be totally off base.
This database is
Hello,
I have this table which stores an ever changing price of items.
CREATE TABLE shop (
article INT(4) UNSIGNED ZEROFILL NOT NULL default '',
date DATE NOT NULL default '-00-00',
price DOUBLE(16,2) NOT NULL default '0.00',
KEY article (article,date)
);
And I
On Mon, Feb 02, 2004 at 02:00:46AM -0500, Nick wrote:
Alas, when I tried the binary version, it gave me an error that google
helped link me to the following:
Fatal error 'Can't create gc thread' at line ? in file
/usr/src/lib/libc_r/uthread/uthread_create.c (errno = ?)
mysqld got signal 6;
Got any indexes?
--ja
On Wed, 11 Feb 2004, nyem wrote:
Hello,
I have this table which stores an ever changing price of items.
CREATE TABLE shop (
articleINT(4) UNSIGNED ZEROFILL NOT NULL default '',
date DATE NOT NULL default '-00-00',
price
Hello list,
What is the best way to store and search formatted text?
Thanks in advance.
__
New! Unlimited Netscape Internet Service.
Only $9.95 a month -- Sign up today at http://isp.netscape.com/register
Act now to get a
92 matches
Mail list logo
