Keith,
I agree that would be a good option to change the table.
Unfortunately, that's not an option at this point. I don't control
the schema. Thanks for the suggestion anyway.
Albert Padley
On Jun 14, 2006, at 3:59 PM, Keith Roberts wrote:
Hi Chris.
I cannot see how it can be done
*Disclaimer - this will be kind of vague mainly because I only vaguely
recall the material.
I am trying to create a stored procedure. Now I vaguely recall reading
something that says I have to match a column type if I am messing with
one. Something like I want to match a table column
Hi,
The aborted clients seems to be increasing than the connections made.
Any solution
Aborted_clients 67529 where as the connection made is 60462 .
Here is my server details,
Server : Red Hat Enterprise Linux AS
release 4 (Nahant)
Mysql Server
At 23:00 +0100 14/6/06, Graham Reeds wrote:
1) You may have a bogus hidden character in your SQL file. If you
look at it with a text editor (BBEdit, TextWrangler, etc), with the
show invivisbles feature on, do you see unusual stuff? Sounds
strange but I've seen stranger.
Took a brief look
*Disclaimer - this will be kind of vague mainly because I only vaguely
recall the material.
I am trying to create a stored procedure. Now I vaguely recall reading
something that says I have to match a column type if I am messing with
one. Something like I want to match a table
Hello
I'm looking for mysql 4.1 for Aix 5.3.
I found mysql for aix 5.2 but no where 5.3 package. Is there anyway to
provide this version ?
Other things : the final user use 4.1.10a with Linux and want the same
version for Aix. Why this version of Mysql doesn't exists anymore ?
Thanks,
--
Hi
I' m a newbie and I'm sure this question has been answered many times, but
I can't find the appropriate thread.
Example:
I have a table of people's data including a field called say importance
like:
NAME; AGE; FUNCTION; IMPORTANCE
Peter; 24years, some job, 0
Anna; 22years, better job, 1
theo schrieb:
Hi
I' m a newbie and I'm sure this question has been answered many times, but
I can't find the appropriate thread.
Example:
I have a table of people's data including a field called say importance
like:
NAME; AGE; FUNCTION; IMPORTANCE
Peter; 24years, some job, 0
Anna; 22years,
On 6/15/06, theo [EMAIL PROTECTED] wrote:
Now, there is a new employee John with a job better than Peter's
His importance is one more than peter's, and all other move up +1;
So the list should look like this after inserting John:
Peter; 24years, some job, 0
John; 28years, somewhat better job,
Hi All,
I'm still kind of new to this, so I'm looking for suggestions on how
to do this one. I need to recode this site that was designed using
the old WebCatalog program which we will be phasing out soon. Here's
the link to a page I need help
on: http://die-broke.com/books.tpl What's
I'm still kind of new to this, so I'm looking for suggestions on how
to do this one. I need to recode this site that was designed using
the old WebCatalog program which we will be phasing out soon. Here's
the link to a page I need help
on: http://die-broke.com/books.tpl What's the
You have your wait_timeout set to 5 seconds. Which means a client connection will be aborted after 5 seconds of inactivity. Since
your aborted connects is 0, you don't seem to having a problem connecting, just staying connected. 5 seconds is kind of low (default
is 28800 I think), but is fine if
At 02:16 PM 6/15/2006 Thursday, Rob Desbois wrote:
I'm still kind of new to this, so I'm looking for suggestions on how
to do this one. I need to recode this site that was designed using
the old WebCatalog program which we will be phasing out soon. Here's
the link to a page I need help
I'm still kind of new to this, so I'm looking for suggestions on how
to do this one. I need to recode this site that was designed using
the old WebCatalog program which we will be phasing out soon. Here's
the link to a page I need help
on: http://die-broke.com/books.tpl What's the
I think it's listed by the corresponding SKU numbers - 17 digits. Is
this what you're asking?
Err...no, I meant pretty much what Martijn said in his reply - the question is
very vague.
There are many ways of achieving...whatever it is you want to achieve.
If you need help with it you need to
On 6/15/06, Lakshmi [EMAIL PROTECTED] wrote:
Hi,
The aborted clients seems to be increasing than the connections made.
Any solution
Aborted_clients 67529 where as the connection made is 60462 .
A client is aborted after wait_timeout seconds of inactivity, but as
your app seem to be working
On Friday 16 June 2006 00:28, [EMAIL PROTECTED] wrote:
To confirm that you would like
[EMAIL PROTECTED]
added to the mysql mailing list, please click on
the following link:
http://lists.mysql.com/s/mysql/44916ea4caaa5c4f/markc=renta.net
This confirmation serves two purposes.
Howdy. For years I have manually altered mysql.user.User to
64 chars to accommodate email length user IDs but now, after
upgrading to v5.0.21, the normal alter table routine I use
seems to ruin the table altogether. I can't use mysqlcheck to
fix it because the root user can't log in. On a fresh
Thank you very much for the tips and for the links. I think I have it
working now with a subquery.
cheers,
Andrew Zahn
Peter Brawley wrote:
Andrew Zahn wrote:
I am using MS Access to read from a MySQL database. The query
generated through access listed below returns incorrect data when
Not natively in 5.0, but MySQL 5.1 has introduced an event schedule feature
embedded into it, but i am not really sure if even that can do what you have
described, but the best way to do this is in Perl with the DBI or the
DBIx::DWIW or the DBD::MySQL modules, if you want some reference then look
Здравствуйте, .
Hi all. I try to increaseinnodb_buffer_pool_size
There is log file:
mysqld_safe[23845]: started
mysqld[23848]: 060615 19:14:52 InnoDB: Error: cannot allocate 2147500032 bytes
of
mysqld[23848]: InnoDB: memory with malloc! Total allocated memory
mysqld[23848]: InnoDB: by
Look at this previous thread
http://forums.mysql.com/read.php?22,42721,42721
Kishore Jalleda
http://kjalleda.googlepages.com
On 6/15/06, Vitaliy Okulov [EMAIL PROTECTED] wrote:
Здравствуйте, .
Hi all. I try to increaseinnodb_buffer_pool_size
There is log file:
mysqld_safe[23845]:
I'm trying to restore a MySQL database in v5.0 (that minor number is in
the teens, I don't have it at hand). I get a bunch of warnings like:
Warning: Do not know how to handle this statement at line 28:
CREATE TEMPORARY TABLE `CHARACTER_SETS` (
`CHARACTER_SET_NAME` varchar(64) NOT NULL default
The same limitation is also in 4.1.x versions.
You have to edit the source of the client library and recompile.
Mark Constable wrote:
Howdy. For years I have manually altered mysql.user.User to
64 chars to accommodate email length user IDs but now, after
upgrading to v5.0.21, the normal alter
On Friday 16 June 2006 02:40, Ghaffar wrote:
The same limitation is also in 4.1.x versions.
You have to edit the source of the client library and recompile.
I thought so too but fortunately for me we are both wrong...
version: 4.1.15-Debian_1ubuntu5-log
mysql SHOW FULL FIELDS FROM `user`;
Hello,
I'm trying to compile mysql-5.0.22 on Solaris 10 using the Forte Compiler
(cc: Sun C 5.8 2005/10/13). I'm doing this so I can build
the DBI driver for mysql (DBD::mysql). The .pkg versions
are missing libmysqlclient.so required to build DBD::mysql
Hi,
I have a table that stores geometry information in one column in
point type. After freshly uploading the table,
myisamcheck --sort-index reports an error:
- Sorting index for MyISAM-table 'TEST_I14_GEOM'
myisamchk: Unknown error 126
myisamchk: error: Can't read key block from filepos:
27 matches
Mail list logo