max. value from select statement

I have a table as such where mid is my auto increment primary key: TABLE: mboard mid 2 3 4 5 I'm doing this in combination with PHP4. What I want to do is build a query that will allow me to get the largest mid from the table (mboard) above. The query I have is: select max(mid) from mboard; BUT

Problem with complex query

Hi, i'm trying to make a simple message board and I need a bit of help to finish up. Here's my database structure first with some example data: TABLE: mboard mid | topic | name| date 1 New site John Doe 2 Re: New site S

ERROR rotating logs problem in MySQL(Linux)

I'm pretty new to the Linux world and i'm getting the following error: errors occured while rotating /var/log/mysqld.log mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' erorr running prerotate script -- leaving old in place Does anyone know ho

Query help

I'm trying to build a query for a calendar program for a web site. Basically, I want a query that will print a word if there is an event booked on that day. Here's how the relevant tables are laid out and what they mean: TABLE: activities AID - Primary Key ALocation AEmail AName ADay AMonth A

external access to mysql

I and 2 others are working on a web site an occasionally. Each of us are in different locations and exchange info email. Some of them need to query the database to compare results with what is on the site with the MySQL database. My question is, is there a way to allow access to my database by

Exporting data

How do I dump all the contents of a table called "clients" into a .txt file (or anyother kind of file for that matter). Thanks for your help. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manua

PHP and MySQL combo

Is there anyway to tell how many connections are currently being served by MySQL. I'm using this in combination with PHP. Also, does MySQL automatically shut down when you leave the page? I'm not using mysql_pconnect - just the regular mysql_connect. Thanks, Mike ---

Problem with creating default value

Hi. This is a really easy question: I have an existing table called clients. I have an existing field called CPicture. I'm trying to add a default value of "no". I've tried several times and can't seem to get it right. So, does anyone know how I can add a default value of "no" to an existing