hello list,
this is a MySQL realted question
I have a mySQL table with 15 columns. I query that table and group
(using GROUP_CONCAT) them based on one filed (say coloumn1). I get the
results. But, the result is truncated in some of the lines. It gets
truncated exactly after 1032th character of
On 25 Mar 2004, at 05:01, Sasha Pachev wrote:
Innodb to my knowledge does not allocate very much locally per thread,
and should not allocate anything at all if you are not doing any
queries.
That's what I thought.
Based on the test results you have reported, I would put your libc as
the
I have been using the mysqlbinlog to investigate the 'saturn2-bin.051'
binlog file.. I have come to pinpoint the problem position in the binlog,
but don't know how i can bypass the corrupted segment.
Please help.
Thanks
Arvind.
-Original Message-
From: Arvind Gangal [mailto:[EMAIL
On 25 Mar 2004, at 06:31, Heikki Tuuri wrote:
you can use the command
SHOW INNODB STATUS;
to check how much memory InnoDB has allocated in total. Please report
what
it says at the time of the memory explosion.
Well, that was informative, but in a negative sort of way. SHOW INNODB
STATUS
You need to set a user in MySQL with privileges to that database. From the
mysql console:
mysql GRANT options ON database_name.* TO user@'217.219.201.2'
IDENTIFIED BY 'password' USING GRANT OPTION;
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hello,
i write a front-end in vb.net and want to save data`s out of a text field
into a MySQL database.
But i have trouble
with
this.
-
a short example out of my source code to save data`s directley
Sasha Pachev writes:
Jigal van Hemert wrote:
It's a bug. I would recommend to patch libmysql.c for now until MySQL developers
fix it.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
Our client side uses select() but only when waiting for data, and not
on teh
Is it possible to fit an entire article (say, a newspaper article) into one cell of a
MySQL database? When I tried load data local infile the file was imported into
several rows! Perhaps I just don't understand the use of a fulltext index.
--bhcesl
Do you Yahoo!?
Yahoo! Finance Tax Center -
Brandon Carter wrote:
Is it possible to fit an entire article (say, a newspaper article) into one cell of a MySQL database? When I tried load data local infile the file was imported into several rows! Perhaps I just don't understand the use of a fulltext index.
--bhcesl
Do you Yahoo!?
Yahoo!
Was wondering if anybody knows if there are advantages to using
mysqladmin -pPassword shutdown compared to /etc/rc.d/init.d/mysqld
stop? I have a script that was using mysqladmin to shutdown the daemon
and then /etc/rc.d/init.d/mysqld start to restart it. Problem was, and I
am not sure if
Chip Wiegand wrote:
When running mysql from the command line (Putty terminal) and trying to do
some updates the updates fail. First the query I am running -
mysql update warranty_temp, warranty_old set
warranty_old.OwnerName=warranty_temp.OwnerName where
warranty_old.WarrantyID between 75
On 25 Mar 2004, at 10:10, Tim Cutts wrote:
No, indeed. I'm going to try building mysql myself, on the machine on
which it's going to be running, and see whether that still has the
issue...
The version compiled natively on the machine does the same thing
(although it uses a little less memory
Sorry if this is an obvious question but is version 3.23 still supported by
MySQL AB. And if it still is is there a date when it will not be.
One of our systems uses it but the users are not convinced about upgrading
to version 4
Thanks
Dave
Hi,
anyone know what happens if, while I am doing a database dump, someone logs
into the database and updates records, what records are trapped in the dump,
or can the dump proceed under this circumstance...in other words must I
knock all users off the database before the dump is done?
Many
On 25 Mar 2004, at 15:23, joe collins wrote:
Hi,
anyone know what happens if, while I am doing a database dump, someone
logs
into the database and updates records, what records are trapped in the
dump,
or can the dump proceed under this circumstance...in other words must I
knock all users off
Thorsten,
i write a front-end in vb.net and want to save data`s out of a text field
into a MySQL database.
But i have trouble with this.
On http://www.vbmysql.com/articles, you will find some great
VB/MySQL-related tutorials.
http://www.vbmysql.com/samplecode/simpleinsert.html is probably
Hi
I want to perform a mysqldump (with the --add-drop flag) of an entire
database that excludes 1 specific table only (named 'phpbb_config'). Can
anyone supply the mysql for this?
I know I can do this in reverse - that is specify all the tables i want
to mysqldump, but this is inefficeint, as
gowthaman ramasamy [EMAIL PROTECTED] wrote:
hello list,
this is a MySQL realted question
I have a mySQL table with 15 columns. I query that table and group
(using GROUP_CONCAT) them based on one filed (say coloumn1). I get the
results. But, the result is truncated in some of the lines. It
[EMAIL PROTECTED] wrote:
Not sure if this is the place to post this but...
I'm trying to build super-smack-1.2 on freebsd 4.9 w/ MySQL 4.0.18 and
am
running into the following problems. Below are configure, make and gmake
output:
[EMAIL PROTECTED] /usr/local/src/build/super-smack-1.2$
First, full text indices have nothing to do with importing the data,
it's just a special type of indexing for searching. The reason you got
several rows is that you probably did not specify delimiters. Thus,
every time a return was encountered, a new record was created because
return is the
yea, I thought it would be that easy too but it doesn't work.
Any other ideas?
Peter Lovatt [EMAIL PROTECTED] 3/24/04 3:53:03 PM
select
db1.table.field, db2.table.field
where
db1.table.someotherfield = db2.table.someotherfield
Peter
-Original Message-
From: Ed Reed
Thanks! I was hoping it was something that had already been found. I'll
upgrade as soon as I can.
Thanks,
Brian
-Original Message-
From: Sasha Pachev [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 10:47 PM
To: Stanton, Brian
Cc: '[EMAIL PROTECTED]'
Subject: Re: Replication
On Thu, 2004-03-25 at 21:23, Victoria Reznichenko wrote:
thank you dear victoria
it says 1024. How can i increase it?.
Check value of group_concat_max_len system variable:
SELECT @@session.group_concat_max_len;
--
MySQL General Mailing List
For list archives:
Ed Reed [EMAIL PROTECTED] wrote:
yea, I thought it would be that easy too but it doesn't work.
It should work.
Did you get error message?
Any other ideas?
Peter Lovatt [EMAIL PROTECTED] 3/24/04 3:53:03 PM
select
db1.table.field, db2.table.field
where
db1.table.someotherfield =
It really should be that easy, though Peter's example is missing the FROM
clause. I'm sure he just meant to show the syntax for db.table.column
rather than a complete query.
Why don't you tell us what version of mysql you have, the query you tried,
and the result you got.
Michael
Ed Reed
Ed Reed wrote:
yea, I thought it would be that easy too but it doesn't work.
Other than the fact that the given example needs a FROM clause,
sure it works. What exactly are you trying and what is the exact
incorrect result?
select
db1.table.field, db2.table.field
FROM db1.table, db2.table
gowthaman ramasamy [EMAIL PROTECTED] wrote:
On Thu, 2004-03-25 at 21:23, Victoria Reznichenko wrote:
thank you dear victoria
it says 1024. How can i increase it?.
Use SET command. For example:
SET @@global.group_concat_max_len=5000;
or
SET @@session.group_concat_max_len=5000;
Hi,
I would appreciate help on the following.
I have a column in a table. Each entry in the column can
have 0,1,2,3... maybe four entries in it.
I would like to parse the column and grab each of the entries and
feed it into another select statement. This entry that needs
to be parsed would be
Greetings,
I did:
mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret';
But
mysql select * from user where user='ltmuser'\G;
shows:
*** 1. row ***
Host: localhost
User: ltmuser
Bing Du wrote:
I did:
mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret';
But
mysql select * from user where user='ltmuser'\G;
shows:
:: that 'ltm' != 'ltmuser' :-)
Or is the example a typo?
--
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design
Bing Du [EMAIL PROTECTED] wrote:
Greetings,
I did:
mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret';
But
mysql select * from user where user='ltmuser'\G;
shows:
*** 1. row ***
Host: localhost
I found the problem. There was a hyphen in my database name. Re-created
the database and re-imported my data, now everything works fine.
Thanks to everyone.
Egor Egorov [EMAIL PROTECTED] 3/25/04 8:19:04 AM
Ed Reed [EMAIL PROTECTED] wrote:
yea, I thought it would be that easy too but it
Has anyone seen situations where innodb's deadlock detection fails
to detect a deadlock, and things remain deadlocked until the lock
wait timeout expires and the server returns a Lock wait timeout exceeded;
Try restarting transaction, or have any ideas for why it may be
happening?
There are no
Dear all,
My system specs are Sun Solaris 8. As I do not have root permission, is it
possible to install mysql locally in my home drive ? I checked the manuals
but there does not seem to answer my question.
If so, what is the expected total size on disk and recommended steps
(./configure, make,
On 24-Mar-2004 Henrik Schröder wrote:
snip
No, I did not choose the sort order. No, I can not change the values
used.
Yes, it has to be this sort order. :-)
Best would be to use ENUM( '1','2','0') ...
But otherwise --
(membershiptype % 2) DESC, membershiptype DESC
-- or --
Hmm.
Taking a stab in the dark here, but..
If it's purely a 'hit counter' type affair, and you're updating a single
row, perhaps performance could be gained by instead inserting into a table
(presumably this can be done with single-row level locking - at least in
InnoDB?), and running a regular
Yes, the clients (appearently) read to the end of the previous file, and
then sit there, while the server is writing to a new file.
I was thinking this had to do with the unclean shutdown of MySQL--
perhapps it's something else.
-Matt-
Matt Sturtz wrote:
Hello--
We're using Red Hat's
On 25-Mar-2004 [EMAIL PROTECTED] wrote:
Not using perl or php I came up with:
mysqlshow -u user --status db_name | awk -F| '{print $2,$5}' | grep
-i pattern
Is there a query to do the same thing?
SHOW TABLE STATUS
--
Don Read [EMAIL PROTECTED]
On Thu, Mar 25, 2004 at 07:21:04PM -, Matt Chatterley wrote:
Hmm.
Taking a stab in the dark here, but..
If it's purely a 'hit counter' type affair, and you're updating a single
row, perhaps performance could be gained by instead inserting into a table
(presumably this can be done with
Hi there,
I am running a website on a host who has blocked access to mysqldump.
Is there any way I can show all the sql commands for creating and
populating a table from within mysql? Again, I don't have access to
mysqldump.
Thanks!
-Erich-
--
MySQL General Mailing List
For list archives:
Marc,
please send the printouts to me.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Register now for the 2004 MySQL Users
I've verified there is no user called 'ltm' in the mysql.user table. So,
yeah, apparently that's a typo in my post. Sorry. So, to re-state my
problem:
I did:
mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret';
But mysql.user shows 'N' in all the *_priv columns for user
Thanks for the heads-up!
Bing Du [EMAIL PROTECTED] wrote:
Greetings,
I did:
mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret';
But
mysql select * from user where user='ltmuser'\G;
shows:
*** 1. row ***
I'm having trouble with a query that is supposed to grab a field from each of my
tables. and set up a Total line at the bottom of each set.
I have:
Insurance Company table (insco)
Patient table (patient)
Procedure table (procrec)
Charges table (feeProfiles)
Patient Coverage table (coverage)
Hi.
I'm having trouble with a query. I'm wondering if it is possible at all.
I'm making a poll for my webpage. I have two tables:
Poll and poll_votes
Table poll contains data about the poll
Poll_Votes contains all the votes. What I want is to pull out data about the
poll and if the user
Hi!
I assume most of you know that we will have our annual MySQL User
conference at April 14-15 in Orlando.
During the conference we will give a lot of information about new
MYSQL features that are already implemented in MySQL 4.1 and 5.0 and
also about the new features we plan to implement in
What do you have access to? SSH? ODBC? Port Access?
On Thu, 25 Mar 2004, Erich Beyrent wrote:
Hi there,
I am running a website on a host who has blocked access to mysqldump.
Is there any way I can show all the sql commands for creating and
populating a table from within mysql? Again, I
Is there any way to do the following? I get an error whenever I try this
(Invalid use of Group function).
Select Product, Sum(Qty)
From Inventory
Group By Product
Order By Sum(Qty) DESC;
I want the total quantities for all products but I want to see the
products with the highest quantities
Is there any way to do the following? I get an error whenever I try this
(Invalid use of Group function).
Select Product, Sum(Qty)
From Inventory
Group By Product
Order By Sum(Qty) DESC;
This should work if you assign it an alias...it does for me on 4.018(not
exact query)
Select
Hi mysql,
i have table 'a' with one field 'name',
which contains many dublicated records, like
SELECT * FROM a;
+---+
| name |
+---+
| Peter |
| Ivan |
| Peter |
| Peter |
| Dima |
| ... |
+---+
Now i want to see list of names (not repeated). How can i do it?
Tnx,
Use
Select * from a
Group by [your_field_name]
-Original Message-
From: nullevent [mailto:[EMAIL PROTECTED]
Sent: Friday, March 26, 2004 9:43 AM
To: [EMAIL PROTECTED]
Subject: select unique records
Hi mysql,
i have table 'a' with one field 'name',
which contains many dublicated
Hello,
I am long since using MySQL 3.23.58; and it works perfectly. In fact, it
works so well, that I have always been very hesitant to upgrade to the 4.x
series. Especially, since 4.x, a year ago or so, was still rather unstable.
But I like the new query-cache. So, I wonder, how stable is
sounds like you need a join.
Select * from Poll, poll_votes where (Poll.poll_id = poll_votes.poll_id) and
(poll_votes.user_ID = WHATEVER);
But I'm still a beginner so
Respectfully,
Ligaya Turmelle
Anders Gjermshus [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi.
I'm having
Check out DISTINCT.
Respectfully,
Ligaya Turmelle
Clive Luk [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Use
Select * from a
Group by [your_field_name]
-Original Message-
From: nullevent [mailto:[EMAIL PROTECTED]
Sent: Friday, March 26, 2004 9:43 AM
To: [EMAIL
Are nested IF statements valid? Doesn't say anything here:
http://www.mysql.com/doc/en/Control_flow_functions.html
Trying to get a conditional count using the following statement - but Im
receiving an error. I would use a CASE statement but my version
doesn't support it.
At 18:44 -0500 3/25/04, David Perron wrote:
Are nested IF statements valid? Doesn't say anything here:
http://www.mysql.com/doc/en/Control_flow_functions.html
Yes, you can nest them, but you must do so correctly. :-)
Your inner IF() below appears to have four arguments.
Trying to get a
hi, all!
i was wondering whether anybody has encountered the same situation i am
with, and how you deal with it:
i've got several mysql servers running in various locations (all
connected by [sigh!] on-demand ppp modem connections).
every now and then i connec to the servers from our main
I am trying to drop several InnoDB and am unable to do
so. I login to the command line client and enter drop
database [db_name]; and then get this error:
ERROR 1217: Cannot delete or update a parent row: a
foreign key constraint fails
Why am I unable to drop these databases?
Tom
=
--
hi again!
on a related note to my previous question:
how can i switch on the creation of a (binary) update log, but only for
ONE database of several being on my server?
cheers,
M.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Matt Sturtz wrote:
Yes, the clients (appearently) read to the end of the previous file, and
then sit there, while the server is writing to a new file.
I was thinking this had to do with the unclean shutdown of MySQL--
perhapps it's something else.
It might, but it is a bug anyway. The whole idea
Tim Cutts wrote:
On 25 Mar 2004, at 10:10, Tim Cutts wrote:
No, indeed. I'm going to try building mysql myself, on the machine on
which it's going to be running, and see whether that still has the
issue...
The version compiled natively on the machine does the same thing
(although it uses a
Arvind Gangal wrote:
I have been using the mysqlbinlog to investigate the 'saturn2-bin.051'
binlog file.. I have come to pinpoint the problem position in the binlog,
but don't know how i can bypass the corrupted segment.
This is a bit tricky. Open the binlog in a hex editor, and go to the last
At 18:55 -0600 3/25/04, Moritz von Schweinitz wrote:
hi again!
on a related note to my previous question:
how can i switch on the creation of a (binary) update log, but only
for ONE database of several being on my server?
You probably want to enable the binary log with --log-bin, and use
the
Mark wrote:
Hello,
I am long since using MySQL 3.23.58; and it works perfectly. In fact, it
works so well, that I have always been very hesitant to upgrade to the 4.x
series. Especially, since 4.x, a year ago or so, was still rather unstable.
But I like the new query-cache. So, I wonder, how
Your grant statement give ltm all privileges on LTM and not on user. By
default, ltm is granted usage on user.
To see the privileges the user ltm has, try any of these two:
select * from db where user='ltmuser'\G;
show privileges for [EMAIL PROTECTED]
Select from db should show ltm having all
Hello,
The size of libmysql.dll binary has increased from
188KB to 916KB from MySQL 4.0 to MySQL 4.1.1.
Researching around I came to know that the new
libmysql.dll was compiled linking the new character
stuff.
What do you mean by character stuff?
Just curious?
Karam
On Thursday 25 March 2004 03:11 pm, Erich Beyrent wrote:
Is there any way I can show all
the sql commands for creating and populating a table
from within mysql?
Here's the first half of your task:
SHOW CREATE TABLE MyTableName;
--John
On Thursday 25 March 2004 03:11 pm, Erich Beyrent
Thanks Jeff,
After a little more investigation it turns out that the problem only
exists when I run the query through a MS Access database attached to
MySQL via ODBC. If I run the query in MySQLCC or MySQL-Front it runs
just fine.
Any ideas for a work around?
- Ed
[EMAIL PROTECTED] 3/25/04
Bing Du [EMAIL PROTECTED] wrote:
Thanks for the heads-up!
Bing Du [EMAIL PROTECTED] wrote:
What I need to do is load data from a file into a table.
mysql load data infile
'/home/user/LTM/generate_report.pl.ltm_enroll_tmp'
into table ltm_enrollment fields terminated by '\t';
ERROR 1045:
69 matches
Mail list logo
