RE: MYSQL RECORDS AND ALPHABETICAL ORDER

2004-08-14 Thread Sunmaia
Hi replace alphabetical_field with the name of the field you are ordering by. If you are not sure, post your table structure and I will add it for you :) bfn Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 14 August 2004 19:06 To: [EMAIL

RE: AM software (access dump) and GUI

2004-08-09 Thread Sunmaia
phpMyAdmin will display a create database box on the initial page, if you have the rights to create databases. If you don't have the right, then it wont. Often hosting plans have their own programming for creating databases because of the problems of making sure you cannot mess with other peoples

RE: Mailing Address Deduplication

2004-07-21 Thread Sunmaia
You might also find SOUNDEX useful. http://dev.mysql.com/doc/mysql/en/String_functions.html Peter -Original Message- From: Duncan Hill [mailto:[EMAIL PROTECTED] Sent: 21 July 2004 15:10 To: [EMAIL PROTECTED] Subject: Re: Mailing Address Deduplication On Wednesday 21 July 2004

RE: A query that groups information by month

2004-06-10 Thread Sunmaia
select month(booking_date) bookings_month, count(bookings) as bookings GROUP BY month(booking_date) Peter -Original Message- From: shaun thornburgh [mailto:[EMAIL PROTECTED] Sent: 10 June 2004 11:12 To: [EMAIL PROTECTED] Subject: A query that groups information by month Hi,

RE: Slow querys When ADSL is down on W2K

2004-06-03 Thread Sunmaia
sound like windows is looking for something.. is there any kind of DNS lookup or a machine in the Network Neighbourhood/Domain that might be unavailable when the adsl goes down? Not a network expert, so just a guess 8-) Peter -Original Message- From: Mauricio Pellegrini

RE: Root users permissions not working

2004-05-31 Thread Sunmaia
hi this may be the problem or it may just be a typo! you are showing #mysql -u root -psomepassword which should be #mysql -u root -p somepassword (note the space after -p) the first will not pass the password, which would explain the lack of privileges. Otherwise start with