RE: Max Packet for MySQL?

the server. Regards Mark. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: 31 October 2003 15:04 To: [EMAIL PROTECTED] Subject: Max Packet for MySQL? I'm getting the error: When uploading a file in my PHP code to a mysql table. From what I've read

Max Packet for MySQL?

I'm getting the error: When uploading a file in my PHP code to a mysql table. From what I've read, this has to do with the max_allowed_packet variable in mysql. How can I tell what that packet variable is set to? Do I have to re-compile mysql to change it? Or is there a config file (linux

OR in MySQL statement?

How could I write a statement that uses something like 'OR' as a case. Like this: SELECT * FROM list WHERE name = '$this1' OR name = '$this2' OR name = '$that1' ? Thanks for any help, -Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: mysql LOAD DATA INFILE

uhhh.there are only two fields in the table, but I'll give it a whirl. :) As for Donald's advice: it gave me access denied for user. :\ -Mike -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 4:08 PM To: Mike At Spy; Donald Tyler

mysql LOAD DATA INFILE

When I come across this error: The used command is not allowed with this MySQL version Does this mean that I need a whole different verison of MySQL, or just a different compile? The command was 'LOAD DATA INFILE' and I was doing it through phpMyAdmin. Thanks, -Mike -- MySQL General

RE: mysql LOAD DATA INFILE

: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:35 PM To: [EMAIL PROTECTED] Subject: mysql LOAD DATA INFILE When I come across this error: The used command is not allowed with this MySQL version Does this mean that I need a whole different verison of MySQL, or just

RE: mysql LOAD DATA INFILE

the error message and then copy and paste it into the SQL section of the PHPMyadmin tool. Delete the world LOCAL and then run the query. It should work. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:59 PM To: Donald Tyler; [EMAIL

RE: mysql LOAD DATA INFILE

15,000 of them. :) -Mike -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:58 PM To: Mike At Spy; Donald Tyler; [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE [snip] Sorry, that is the error - my mistake. I am getting

RE: mysql LOAD DATA INFILE

and that will insert it. It's a little messy but that's the only other way I can think of doing it. Sorry. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:24 PM To: Donald Tyler; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE

ORDER BY with Date Format

I am trying to create an order by in a select statement that takes a standard 'date' column in a table and sorts the returned data by the month of that date. Off hand, I tried ORDER BY start_date(m) And I know that is wrong. Anyone have any suggestions? Thanks, -Mike -- MySQL General

Revoking Privs

I am trying to clear up our msyql by revoking privileges for users who no longer exist on a particular server. If I delete the users in the appropriate tables in the mysql database, will that revoke their privileges? I found in the user table in the mysql a few 'users' with no username or

RE: mysql port number

Actually, I do google searches first before asking on any list - and it didn't turn up a darn thing. -Mike -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 6:19 PM To: Mike At Spy Cc: [EMAIL PROTECTED] Subject: Re: mysql port

RE: mysql port number

04, 2002 6:19 PM To: Mike At Spy Cc: [EMAIL PROTECTED] Subject: Re: mysql port number On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote: How can I tell what port number mysql is running on? I need it for a chat program. :) 3306 A google search would have found

mysql port number

How can I tell what port number mysql is running on? I need it for a chat program. :) Thanks, -Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

LIMIT in MySQL

I must not be awake yet. Why is this query sending me back 60 records? Shouldn't it only send back records 30 through 60 (i.e. 30 records)? SELECT * FROM table ORDER BY somefield LIMIT 30,60 Thanks, -Mike - Before posting,

MySQL - version to install?

I've got to do a fresh install of mysql on a webserver (a new server, so it isn't overwriting anything). Does anyone have any info as whether I should use just MySQL or MySQL-MAX? What is the difference? Thanks! :) -Mike -

RE: MySQL statement problem

Hi. On Mon, May 20, 2002 at 01:58:25PM -0400, [EMAIL PROTECTED] wrote: Shouldn't this come up with a list of names from each table that matches? SELECT * FROM table1,table2 WHERE table1.name = table2.name; Does anyone see anything wrong with this query? No. It keeps giving

MySQL Problem

am having some trouble with MySQL. Seems I cannot add users. Well, I can add them (through phpMyAdmin, but they are still not able to get into the datasbases. I flushed the tables, too. Current users are not affected. This started, rather suddenly, the day after I was able to do this.

Weird MySQL thing

I am having some trouble with MySQL. Seems I cannot add users. Well, I can add them (through phpMyAdmin, but they are still not able to get into the datasbases. I flushed the tables, too. Current users are not affected. This started, rather suddenly, the day after I was able to do this.

RE: Weird MySQL thing

. Since I didn't mention this earlier, I should also mention that I am on a linux box (Cobalt RAQ4). Thanks, -Mike -Original Message- From: Petre Agenbag [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 2:48 PM To: Mike At Spy Subject: Re: Weird MySQL thing Yes, I'd also