totaling count column where separate column's record values are alike

Can someone please help me with the following: code so far SELECT DISTINCT ip, COUNT(DISTINCT round_to_nearest_five_minutes(date)) as url_hit_count, request from logs_empty GROUP BY substring_index(request, '/', 3) ; I would like to add on to the the code an additional column that adds up the

SOLVED Re: totaling count column where separate column's record values are alike

I changed it around a bit to count distict requests and dates and group by ip. This did the trick! On 6/8/07, Ally Messi [EMAIL PROTECTED] wrote: Can someone please help me with the following: code so far SELECT DISTINCT ip, COUNT(DISTINCT round_to_nearest_five_minutes(date

select all fields plus total children

I have 2 tables, category product. product contains category_id which points back to category.id I'm trying to get all fields for each category plus the total no. of products in that category. A simple query for this: SELECT c.*, COUNT(p.id) AS total FROM category AS c, product AS p WHERE

Re: Strange Issues (UTF-8)

To me it should be a simple task. Insert 65k of text in Unicode or even simple ASCII format into a column of type 'text' by using a GUI client like SQLyog or MySQLCC and then extract it when needed by my web page without loosing everything I put in after a certain character or character

select columns in full text index

I have several tables which have some columns indexed for full text searching. table 1: FULLTEXT(foo,bar) table 2 FULLTEXT(pip,pop,pup) table 2: FULLTEXT(hip,hop) I'd like to be able to query the db to find which columns are indexed depending on the table to be searched so i can then create my

Using indexes on mysql.

hi all, this will sound very stupid, but i guess it will be helpful to mysql newbies like me. Here's my Qu : What's the use of using indexes in mysql ? Why do we create an index anyway ? thank you, regards ally - Before

Unable to connect to remote mysql server.

please advice. thank you very much, ally - 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

Re: Unable to connect to remote mysql server.

hi which port no are you referring to ? i even tried : mysql -h 202.157.188.2 -u root -port=3306 -p but it doesn't work. please advice. thx ally - Original Message - From: Sherzod B. Ruzmetov [EMAIL PROTECTED] To: Gerald Clark [EMAIL PROTECTED] Cc: ally [EMAIL PROTECTED]; [EMAIL

Using LDAP with mysql.

please enlighten and advice me? thank you vey much ally. - 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

please advice me.

did the magic of using viet char? thank you very much for your help and comprehension. regards, ally - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com