Thanks a lot!
- Original Message -
From: paul rivers [EMAIL PROTECTED]
To: '古雷' [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Monday, July 10, 2006 11:41 AM
Subject: RE: May I create more than 200 databases for one mysqld?
Yes, you can.
Whether there are disadvantages depends
Hi Mike, all!
mos wrote:
I have a complicated SQL statement with around a dozen
if(this,val1,val2) embedded in it and there are even nested If
clauses. I'm getting syntax errors because I'm not balancing the ( )
properly. Is there any free software out there for Windows that I can
copy and
cumulative total index
...
SELECT SUM(amount) , DATE_FORMAT( `paymentDate` , '%Y-%m' ) FROM
`payments` GROUP BY DATE_FORMAT( payments . date , '%Y-%m' )
.
Is there any way to get a running cumulative total directly from mysql?
Something like:
amount | paymentDate
200|
Is there somewhere I can find the exact differences between the contents of
the
'essential' and 'complete' Windows MySQL distributions?
I've tried the source code and searched all over the website but can't find
it anywhere.
Ping!
The package you sent me was infected, so send me one by mail.Thank you:James
B.Runaku, P.O.Box 190-50100, Kakamega, Kenya.
mysql@lists.mysql.com wrote: The message contains Unicode characters and has
been sent as a binary attachment.
-
How
Hi,
We had an outage on our Mysql DB yesterday. Basically the Db was unusable
and we couldn't get a shell onto the host ('could not fork process').
OS: Red Hat Linux Advanced Server release 2.1AS/\m (Pensacola)/2.4.9-
e.3enterprise
Mysq: Ver 4.0.16-standard for pc-linux on i686
All Db's on
Is there a standard MySQL structure to represent vCards?
If so, are there programs to install vCard address lists
in a MySQL database?
I'm running Fedora-5 Linux, with KDE,
and am interested in translating the KAddressBook/kabc format
(used with kmail) to and from MySQL,
as automagically as
If I have a file that is in a spreadsheet format, how can I dump that into a
MySQL database, using PHP MyAdmin?
Thanks,
Nick
[snip]
If I have a file that is in a spreadsheet format, how can I dump that
into a MySQL database, using PHP MyAdmin?
[/snip]
Using a LOAD DATA INFILE query.
http://www.google.com/search?hl=enlr=q=csv+to+mysql+phpmyadmin
--
MySQL General Mailing List
For list archives:
I've had to delete large amounts of records from tables with over 200 millions records. You are correct in that you want to do it in
chunks. How you divide the deletes is up to you to decide. You would want to do it based on a indexed column, like a date, and
specify a range.
DELETE data
FROM
Database Migration Error:
My database is stored in MSSQL Server 2000 in a standalone system in windows
authentication mode means without any username and password. I am writing my
whole process problem if you people could solve my problem.
In Source Connection Parameter
Stored Connection :
Hello,
i've two tables and they have the same field.
I'd like to make a select which take records in a table and after it
shows record in the other table
in the same field...
I try to explain:
Table1
FieldA - FieldB
AAA123 - Cellular
BBB111 - PostIt
Table2
FieldA - FieldH
AAB111 - Dido
BGF145 -
From: Vittorio Zuccalà Sent: 10 July 2006 14:26
Hello,
i've two tables and they have the same field.
I'd like to make a select which take records in a table and after it
shows record in the other table
in the same field...
I try to explain:
Table1
FieldA - FieldB
AAA123 - Cellular
Hi!
Vittorio Zuccalà wrote:
Hello,
i've two tables and they have the same field.
I'd like to make a select which take records in a table and after it
shows record in the other table
Read here: http://dev.mysql.com/doc/refman/5.0/en/union.html
in the same field...
It cannot be the same,
Best group member,
I did this query on a very small database. And it gave error with some
MAX_JOIN_SIZE error. I have never seen this, and how can I avoid this to
happen? Do I have too many joins in one query? Should I write the joins
differently?
++
SQL query:
The documentation shows MySQL 5.0.23 as released on July 4 - but I do not see
it on any mirror anywhere? Does anyone know where MySQL
5.0.23 is? Is it released, as the doc says? Is it being held until release
5.0.24?
Thanks for any update.
Regards,
R
--
MySQL General Mailing List
For
On 7/10/06, Kishore Kumar Barik [EMAIL PROTECTED] wrote:
snip
Please send me solution immediately.
anything else, your highness?
--
-jp
Chuck Norris got in touch with his feminine side, and promptly got her
pregnant.
- Original Message -
From: Miles Thompson [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, July 09, 2006 8:10 PM
Subject: Re: How to look for balanced parenthesis?
At 03:48 PM 7/9/2006, Rhino wrote:
- Original Message - From: mos [EMAIL PROTECTED]
To:
Could the problem the Locked data table in this case?
mysql show processlist;
+-+---+---+---+-+---
-+--+---
---+
| Id | User | Host
On 7/10/06, Kishore Kumar Barik [EMAIL PROTECTED] wrote:
Database Migration Error:
My database is stored in MSSQL Server 2000 in a standalone system in windows
authentication mode means without any username and password. I am writing my
whole process problem if you people could solve my
Hi folks,
I've recently tried to do a database backup on a database server that
has a fairly high concurrency rate (1000+ queries/sec) and have noticed
that the backup process seemed to deadlock the machine and I had to
resort to extreme measures to get the database back up (killed the
process
Mark, that's the expected behavior of mysqldump with --opt and
--single-transaction; it locks all databases and all tables for the
duration of the dump, ensuring a consistent snapshot.
With a database this size (100 GB), it's an area where throwing
hardware at the problem may be your best bet.
Hi Rick, all!
Rick Robinson wrote:
The documentation shows MySQL 5.0.23 as released on July 4 - but I do not see it on any mirror anywhere? Does anyone know where MySQL
5.0.23 is? Is it released, as the doc says? Is it being held until release 5.0.24?
The release date in the documentation
Sorry Mark - I thought your question was more of a does this seem
right and how do I than a something's wrong here post.
I think your problem is coming in with the use of --opt. The article
you reference, where it says This is an online, non-blocking backup,
makes no mention of --opt, which as
Dan: The options I specified are correct (according to the
documentation) to get a consistent non-blocking snapshot.
(--single-transaction disables --lock-tables, --opt is the default
behavior for mysqldump).
My question was more in the nature of will these options work in high
concurrency
It appears that every time I start query the event or the data table
gets Locked.
Could this have any affect on why it takes so long to delete records.
Grasping at straws,
Thank you,
Raymond
mysql show processlist;
+-+---+---+---+-
Hi all.
I have a long and complicated chain of queries in MS Access that I want
to port to using stored procedures views.
What I'd like to do is something like:
1) stored procedures grabs original data set, and dumps into temporary
tables
2) I open a view, which is in turn based on other
Hi ,
I'm just behind a mulimedia database , that wanted to be online with WAP
contents. So , i decided to go ahead with mysql , and i installed mysql latest
5.0 in fedora core 5 with innoDB .upto now every thing success.
But , my worries is , how can i created huge mulimedia database
I used to use UltraEdit, but then switched to EditPlus because it can edit
remote files almost transparently. (Opening a file FTP's it down, you edit
local copy, Saving FTP's it back.)
FYI - UltraEdit can do this - It uses SFTP over SSH to edit remote files.
Works like a charm.
-Hank
mysql,
Hi,
I would like to log the execution time for each query in my MySQL server
.Is there any possible way?
Please not that, the - log-slow-queries option will not suffice for my
requirement.
Thanks Regards
Mukul Saha
___
Cognizant Technology
30 matches
Mail list logo