e the change more permanent you can add a line to /etc/my.cnf in
> the [mysqld] section of that config file and restart the server.
>
> Regards
> Mark.
>
> -Original Message-
> From: Mike At Spy [mailto:[EMAIL PROTECTED]
> Sent: 31 October 2003 15:04
> To: [EMAIL PR
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 OS
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:h
move the word
> LOCAL and it should work fine.
>
> -Original Message-
> From: 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
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 Maili
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
> T
d you try and remove it?
>
> To do that in PHPMyAdmin you will need to run the import so you get 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-
on
> another machine. Just copy and paste that into the SQL window on the main
> server 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:[E
over 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
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 Mai
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
passwo
gt; Sent: Wednesday, December 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 ch
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]
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/
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,
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
-
> 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.
>
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.
Anyon
,
etc.
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 M
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.
Any
20 matches
Mail list logo
