Access denied; you need the RELOAD privilege for this operation

Hi everyone -- I'm pretty new to MySql, but not many years ago I was an ISAM guy so I understand the issues with indexes and on-the-fly inserts. I've seen many questions around this error message, "Access denied; you need the RELOAD privilege for this operation." But I'm not grokking the answe

Re: What should it be in MySql? In C, it's an array of integers.

> Pete wrote: > > Hi folks -- > > > > What would be the right approach in MySql 5.0? > > > > My table, USERS, has columns NAME and IP. Associated > with each user is also a collection of from 0 to 50 INTs. > What's a reasonable way to put these 50 INTs in the table > without using 50 separate colum

What should it be in MySql? In C, it's an array of integers.

Hi folks -- What would be the right approach in MySql 5.0? My table, USERS, has columns NAME and IP. Associated with each user is also a collection of from 0 to 50 INTs. What's a reasonable way to put these 50 INTs in the table without using 50 separate columns, INT01...INT50? Is BLOB an OK ap

Can a MyISAM DB hold /everything/?

Hi folks -- I am new to MySQL and just laying out what I hope will be just one db that holds all the info for a list of forged or machined metal parts. Let's say there are 10,000 such parts, each with a unique part number. That part number is the primary index. Each part has at least one, an

Re: MAC address as primary key - BIGINT or CHAR(12)

r indexing) and also the readable representation (just for debugging/problem-solving)? (Well, of course I know what the cost is: it's 12 bytes, plus overhead, per row.) It all depends, but in general, would you call that too costly, given the benefit? -- Pete Wilson http://www.pwilso

Re: MAC address as primary key - BIGINT or CHAR(12)

be interested in the answer, though, from someone with experience. -- Pete Wilson http://www.pwilson.net/ --- On Thu, 5/14/09, Jim Lyons wrote: > From: Jim Lyons > Subject: Re: MAC address as primary key - BIGINT or CHAR(12) > To: "Ilia KATZ" > Cc: mysql@lists.mysql.

Re: A good US Hosting Site?

http://www.kionic.com I've been a very active and heavy customer for years and very satisfied. -- Pete Wilson http://www.pwilson.net/ --- On Sun, 4/19/09, Cameron Rogers wrote: > From: Cameron Rogers > Subject: A good US Hosting Site? > To: mysql@lists.mysql.com

Error msg: MySQL server has gone away

to usrs(usr,email) values(\"pete\", \"p...@pwilson.net\");" ); I can imagine this happening when the connector is running in real life. So: What is the correct and reasonable way for a running connector to deal with this error intelligently? Thanks! -- Pete Wilson h

success return from mysql_query() when error return was expected

all to mysql_query(select ...) must always in these circumstances return success. Thanks! -- Pete Wilson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org