newbie SELECT question

only the portion between the // and /. Sort of a //*/ thing so I can use COUNT with this to allow me to build a table in PHP of the most popular root domains which go to my site. I hope this all makes sense ;-) kind regards, Graham Nichols.

SQL syntax question

ease? I've tried several other syntax combinations without success. kind regards, Graham Nichols. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Syntax query

ease? I've tried several other syntax combinations without success. kind regards, Graham Nichols. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the li

Newbie table question

Hi, I have a newbie question, to which my mysql books didn't have an answer! It is: I have two tables with identical structures. I wish to copy the data from table B into (append) table A. What sql statement will achieve this please? kind regards, Graham Ni

Newbie question

f I wish to select all records which contain 'christmas', what is the correct sql syntax please? (This should return records 1 and 3 from the example shown above) I've tried several approaches, but have failed so far. Thanks for

How to modify safe_mysqld to email when mysql server missing?

NatureHi, How can I modify safe_mysqld to make it email me if the mysql server fails/shuts down for some reason please? regards, Graham Nichols. - Before posting, please check: http://www.mysql.com/manual.php (the

mysql timing out? HELP!!!!

Hi, I have a customer who has a html page containing two frames on server A. The content files for these frames are on server B. He wants to keep his URL which is directed to server A, but server B has mysql and php support so we have to do this to accomodate him. It is working (kind of) but th

Re: DISTINCT problem

Already done my friend - works like a dream. best, Graham -Original Message- From: Jeremy Zawodny <[EMAIL PROTECTED]> To: Graham Nichols <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: 29 July 2001 10:39 Subject: Re: DISTINCT problem >On Th

DISTINCT problem

Hi, Distinct can only be used with count count(distinct field_name) --- OK for 3.23 NOT for 3.22 from MYSQL version 3.23. I have only version 3.22. How can I get around this please? kind regards, Graham Nichols

Re: Correct DISTINCT syntax

d this please? kind regards, Graham Nichols. - 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 PRO

Correct DISTINCT syntax for MYSQL version 3.22.32

ount the unique IP addresses for each date. How can I work around this please? kind regards, Graham Nichols. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Copy table structure to another database?

Hi, Can I copy a table (structure only) to another database? I've searched though my manuals without success so far. kind regards, Graham - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

Newbie group/count query question

I have a table which contains a date column and an order_number column. I need to formulate a query syntax to return the total number of orders for each day in a given month (if any). Can someone help me with the syntax please as I've been stumbling around with it all day without success. Many th

web application integration

Hi, Can anyone please point me toward any tutorials /. books regarding integrating web mysql data with ,say, a LAN-based accounting system? I'm not sure how to interface with dynamic files continually upgraded by surfers. Any comments welcome. regards, Graham ---

Correct syntax?

Thanks for help from this group I'm using "select word, count(word) as total from search_words group by word order by total desc limit 20" to locate the top 20 words in a database of website search engine words. The database had been altered to include an extra column, other than the 'word' col

Newbie frequency question

Hi, I have a list of words entered into a search engine held in a database. I wish to be able to select the top 10 words held in the database. I've fiddled around with ORDER DESC, DISTINCT and LIMIT etc but I can't hit upon the SQL syntax to obtain the correct result. Can someone please shine a l

Newbie frequency question

Hi, I have a list of words entered into a search engine held in a database. I wish to be able to select the top 10 words held in the database. I've fiddled around with ORDER DESC, DISTINCT and LIMIT etc but I can't hit upon the SQL syntax to obtain the correct result. Can someone please shine a l

Moving MySQL database(s)

Hi, I've developed my mysql databases/tables on a local intranet server. What's involved in correctly copying them to an online linux machine please? regards, Graham Nichols

Newbie question

Hi, I've installed mysql 3.22.32 and created a test table via mysql. now, when I try to run safe_mysqld --log & I get the error message [[EMAIL PROTECTED]]$ Starting mysqld daemon with databases from /usr/local/var ./scripts/safe_mysqld: /usr/local/var/www.server-1.com.err: Permission denied r

Mysql dies

Hi, When trying to run mysql I get the message 'found old style password for user 'graham' . Restart using --old-protocol' How can I cure this problem please? I tried running mysql --old-protocol without success. Many thanks, Graham

mysqld daemon ended

Hi, I have installed mysql 3.22.32 on our local intranet for testing and it runs ok. Then, I transferred the same .tar file to a linux server of the 'net and installed as before. When I run ./scripts/safe_mysqld & from the mysql-3.22.32 directory I get a message telling me that the daemon has