"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 ter
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/2
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 wro
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
___
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
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 stab
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 --bi
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 good
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 li
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
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:http://lists.mysq
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
=
--
M
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 offic
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 condition
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.
SUM(IF(AdGroups.Status
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
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
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 4.0.18
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 recor
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,
>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)
S
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 fir
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
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 f
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
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)
Proc
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'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 'ltm
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 Conf
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: h
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 single-
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 PRO
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
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 j
On 24-Mar-2004 Henrik Schröder wrote:
> 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 --
ELT(memb
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, m
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 m
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 ea
"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 ***
>
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 Desig
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
Pas
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 fou
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=50
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
w
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 wro
"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
> db
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: http://lists.mys
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
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 [
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 def
> [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/supe
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 line
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
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
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 t
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 than
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
---
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
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 a
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
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! F
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 -
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
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 int
You need to set a user in MySQL with privileges to that database. From the
mysql console:
mysql> GRANT ON .* TO @'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 unsubscribe:http://lists.mys
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 produ
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 PROTECT
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 primary
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 tha
69 matches
Mail list logo