limit of record in table Myisam

2005-06-30 Thread Arcangelo Casavola
Hi, i've MySQL 4.0.18 and 1 table type Myisam with many record (1.900.000) Is there a limit of number of record for this table? thank's Arcangelo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Replication only DB

2005-03-11 Thread Arcangelo Casavola
Hi, I've master with mysql 4.1.10 slave with mysql 4.0.18 On my two servers i have many database, can I do a replication of only 1 DB? thank Arcangelo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SELECT on string field

2005-02-01 Thread Arcangelo Casavola
Hi, I've a field with www.s.com/p.php?id=3 www.s.com/p.php?id=4 www.s.com/p.php?id=5 if a do a query with the atribute 'group by' i want that the system regroup all that is after the '?' is that possible? SELECT field WHERE all that is after the '?' GROUP BY all that is after the '?' the result