Hi
We installed version 4.1.0-alpha-max-nt and try to run a query with a
subquery and get the message
[DB_BAS_LOCAL] ERROR 1235: This version of MySQL doesn't yet support 'LIMIT
IN/ALL/ANY/SOME subquery'
Are subqueries supporeted in 4.1 as is mentioned in the doc or not?
Thanks in advance.
Dear lists,
How do I assign user and password to a database that i just created ?
Thanks
Hi Ketvin,
after you created your database kelvin_db for example,
you can set a account to use this database in this manner :
GRANT ALL PRIVILEGES ON user_name.* TO @localhost identified by
'password_for_user';
GRANT ALL PRIVILEGES ON user_name.* TO @% identified by
'password_for_user';
Are
our database is about 20 Gb and growing daily. so far, I still see
nearly constant time query performance on tables with ~10M rows. I
don't think mysql is limited by file size per se.
I guess performance depends a lot on what your tables look like, and
your hardware, obviously. From my own
Try SQLyog at http://www.webyog.com. It has a very
good schedulable Data Sync Tool.
--- Roger Baklund [EMAIL PROTECTED] wrote:
* Andreas
[...]
On the other hand one could use intervals for key
assignment.
Every time a server runs out of keys it throws a
warning at the admin
and rejects
Ladies, gentlemen,
There's a new tool in town - Upscene Productions is
proud to announce:
Database Workbench for MySQL
Download a trial: http://www.upscene.com
Documentation: http://www.upscene.com/documentation/dbw
For years, the workbench series has been helping InterBase
and Firebird
Hi Martjin,
How do I install this tool on a Unix, Linux or BSD based machine ?
Why does it say on the page
1) Receiving upgrades is not time limited.
and 2)
The license itself isn't time limited - but there is a 20% yearly renewal fee
for maintenance and support (updates etc) on the driver
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thierno, et al --
...and then Thierno Cissé said...
%
% Hi Ketvin,
% after you created your database kelvin_db for example,
% you can set a account to use this database in this manner :
% GRANT ALL PRIVILEGES ON user_name.* TO @localhost identified
Wouter Coppieters [EMAIL PROTECTED] wrote:
We installed version 4.1.0-alpha-max-nt and try to run a query with a
subquery and get the message
[DB_BAS_LOCAL] ERROR 1235: This version of MySQL doesn't yet support 'LIMIT
IN/ALL/ANY/SOME subquery'
Are subqueries supporeted in 4.1 as is
Hi Nils,
How do I install this tool on a Unix, Linux or BSD based machine ?
The tool itself is Windows based - however, people are running
it under Wine and similar emulators. See
http://www.upscene.com/documentation/dbw_freebsd_wine.htm
for an example.
Why does it say on the page
1)
Vladik Zakhozhai [EMAIL PROTECTED] wrote:
My name is Vlad. I'm begginer with MySQL. And now I should like to know where can I
take good documentation, tutor or others about MySQL.
Check the following link:
http://www.mysql.com/documentation/index.html
--
For technical support
Hi All MySQL users
I am having a slight problem and getting inot a bit of a tizz.
I have two tables and I am trying to produce a dropdown select menu whilst
creating a join. The two tables are as follows...
CREATE TABLE itinerary (
i_id int(3) unsigned NOT NULL auto_increment,
i_title
Leo,
Thanks for the quick reply. There was a typo but I fixed it. Below is
what I used after correcting it :
select mgr.company, building.bldgname, tenant.id from customers mgr left
join customers building on building.pid=mgr.id left join customers tenant on
tenant.pid=building.id group by
Hi All MySQL users
I am having a slight problem and getting inot a bit of a tizz.
I have two tables and I am trying to produce a dropdown select menu whilst
creating a join. The two tables are as follows...
CREATE TABLE itinerary (
i_id int(3) unsigned NOT NULL auto_increment,
i_title
Joe Lewis [EMAIL PROTECTED] wrote:
I've got a question for you. I've got a MySQL db running in FreeBSD
4.8, and have encountered the following problem.
When I try to connect to a database by a specific user, I get the
following response :
#mysql -p -u comet
Enter password:
ERROR
Hi All MySQL users
I am having a slight problem and getting inot a bit of a tizz.
I have two tables and I am trying to produce a dropdown select menu whilst
creating a join. The two tables are as follows...
CREATE TABLE itinerary (
i_id int(3) unsigned NOT NULL auto_increment,
i_title
Hi List members,
I just forward this for completeness of the thread .
Best regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql
-
Hi Nils,
How do I install this tool on a Unix, Linux or BSD based machine ?
The tool itself is Windows based - however, people are
Hi All MySQL users
I am having a slight problem and getting inot a bit of a tizz.
I have two tables and I am trying to produce a dropdown select menu whilst
creating a join. The two tables are as follows...
CREATE TABLE itinerary (
i_id int(3) unsigned NOT NULL auto_increment,
i_title
Hi List members,
I just forward this for completeness of the thread .
Best regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql
-- Forwarded Message --
Subject: Re: ANN: Database Workbench 2.4 released
Date: Tuesday 11 November 2003 23:47
From: Nils
Hi List members,
I just forward this for completeness of the thread .
Best regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql
-- Forwarded Message --
Subject: Re: ANN: Database Workbench 2.4 released
Date: Monday 10 November 2003 21:08
From: Martijn
Hi List members,
I just forward this for completeness of the thread .
Best regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql
-- Forwarded Message --
Subject: Re: ANN: Database Workbench 2.4 released
Date: Wednesday 12 November 2003 01:00
From: Nils
Hi List members,
I just forward this for completeness of the thread .
Best regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql
-- Forwarded Message --
Subject: Re: ANN: Database Workbench 2.4 released
Date: Monday 10 November 2003 22:15
From: Martijn
Hi List members,
I just forward this for completeness of the thread .
Best regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql
-- Forwarded Message --
Subject: Re: ANN: Database Workbench 2.4 released
Date: Wednesday 12 November 2003 01:26
From: Nils
Dear Frineds,
I need to connect MySql through C. I am able to
connect when compile my ajit.c file with option
'-lmysqlclient'. But when I am compiling a bigger
module (sqwebmail) I dont know where to place this
option in the Makefile.
I am getting error
undefined reference to
Hello,
Where can I download the shared library libmysqlclient.so for Solaris, AIX
and HP-UX? I only see download links for Linux and Windows and the servers
don't appear to ship with these libraries.
Thank you in advance for your help!
Dave Ritter
--
MySQL General Mailing List
For list
Michael Satterwhite wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This has got to be a common question, but I'd really appreciate a little help.
I recently reinstalled my Linux (SuSE 8.2). I *KNOW* I don't have a cron run
that deletes this.
When I try to start mysql, I get the message
Andrey Kotrekhov [EMAIL PROTECTED] wrote:
Hi, All.
Other question is:
Can I create case sensitive field with right ordering of national
characters.
Take a look at collation name: ci at the end of the collation name means case
insensitive, cs - case sensitive, bin - binary:
Hi,
I was trying to use ORDER BY on a unicode field. I can use 2 types of
collation: binary and default. Both give wrong results. The binary puts
accented letters on the end of the list, the default puts all of them between
'A' and 'B'.
What I'd need is central-european collation support for the
Matt W wrote:
Hi Jeremy,
Sorry, it seems like I'm saying this a lot lately. Is it not true that
if the whole table will fit in [free] RAM, that the OS will cache the
file data and there is no need for a RAM disk. I don't really see how
performance would be any different than using a RAM disk.
Henrik Skotth wrote:
Hello all,
We recently upgraded to 4.0, it went
very well and the performance gains have been great.
But now the server has started to act strangely. Every few days, the
server starts to refuse connections, saying
that there is already more than max_user_connections, but
How do I lock rows in a union query so that I know they won't change during
the rest of my transaction?
I want to do the following query, using LOCK IN SHARE MODE:
(select id from table1 where id 1)
union
(select id from table2 where id 1);
If I try:
(select id from table1
Hello again...
I am transferring binlogs between two networks that are not connected as an offline
replication solution. I have two databases which I have configured the my.ini file to
create binlog entries for.
Do both databases get written to the same log or is there a separate log for
On Sat, 8 Nov 2003, Michael Satterwhite wrote:
This has got to be a common question, but I'd really appreciate a little help.
I recently reinstalled my Linux (SuSE 8.2). I *KNOW* I don't have a cron run
that deletes this.
When I try to start mysql, I get the message
Can't connect to local
Craig Cummings [EMAIL PROTECTED] wrote:
Description:
When inserting large strings into ISAM table in an UPDATE TABLE
command, my perl script generates an Out of memory error. I tracked
this down using an SQL script (below). It seems that a 32777225
character string is tolerated, but a
Hi!
What I meant was that even if there are currently only two user
connections being used, and the limit is 300, we still get the already
more than max_user_connections error...
-- Henrik
gerald_clark skrev:
Henrik Skotth wrote:
Hello all,
We recently upgraded to 4.0, it went
very well
Hi List,
I've recently started seeing quite a few errors with MySQL servers I admin, they are
all
requests to run:
mysqladmin flush-hosts
The only change I can identify is our upgrade to 3.23.58 (mysql.com provided RPM -
running on
redhat 7.3)
Is anyone aware of an issue with this version or
Can't seem to find this one in the manual or
archives - how do I control a db to maintain its
size to an arbitrary value, say 20 GB? I want to
just rotate records, deleting those that are
oldest.
Thanks!!
Scott
.
__
Do you Yahoo!?
Protect your identity with
select max(comments.commentid) as tagger, comments.commentref,
article.articlesubject, article.articlename, comments.commentfrom from
comments LEFT JOIN article ON comments.commentref=article.articleid GROUP
BY commentref ORDER by tagger DESC;
I have this query above.
I lists comments in
It depends a lot on the features that are needed. Right now we use mySQL for some
things and Orcale for others. The vibes I have seen from both Oracle and MySQL is
that for right now MySQL is a complementary product to Oracle. Soon I think MySQL
will be right up there with Oracle. Check the
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
gerald_clark [EMAIL PROTECTED] writes:
Matt W wrote:
Hi Jeremy,
Sorry, it seems like I'm saying this a lot lately. Is it not true that
if the whole table will fit in [free] RAM, that the OS will cache the
file data and there is no
Look in the support-files directory in the mysql directory. There are a
bunch of sample config files that you can look at that named pretty
obviously: small,medium,large,huge.
Each one has a description on what kind of system these should be used
on, based on RAM and usage. For instance, huge
MAX_CONNECTIONS_PER_HOUR ?
Now, I set the MAX_CONNECTIONS, but I didn't know about
MAX_CONNECTIONS_PER_HOUR. Still, the problem has persisted when left
for a day or two without restarting. In fact, the issues only go away
when the server is restarted (though I did NOT try the flush).
Thank
Are you sure you are net exceeding the setting for
maximum connections per hour for that user?
Henrik Skotth wrote:
Hi!
What I meant was that even if there are currently only two user
connections being used, and the limit is 300, we still get the already
more than max_user_connections error...
Mark,
I have not that many records but I can offer you ~29 million rows of
wordwide meteorological data. They can be bzip2'd to 300 MB and
are very tricky to summarize in a meaningful way. If you're interested pls
mail me off-line.
Regards,
Thomas Spahni
On Sat, 8 Nov 2003, Mark Horton wrote:
I am running MySQL 4.0.16 on a Red Hat 7.3 server. I am having problems
with tables periodically getting corrupted. The one it happens most often
on is a table I use for logging various status messages. This table
receives mostly inserts, and very few selects. It is about 400MB in size,
with
my experience with corrupted tables is usually followed by a failed harddrive
aka the disk may be diing ...
--
Quoting Jon Wagoner [EMAIL PROTECTED]:
I am running MySQL 4.0.16 on a Red Hat 7.3 server. I am having problems
with tables periodically getting corrupted. The one it happens
This is what I'm currently using on the dual 2GHz w/4GB of RAM:
set-variable = query_cache_type=1
set-variable = query_cache_size=1024M
set-variable = net_buffer_length=32760
set-variable = bulk_insert_buffer_size=32M
set-variable= key_buffer=1024M
set-variable= join_buffer_size=128M
That's new for 4.0? Hadn't noticed it... Anyway, it's set to 0 so there is
no limit to exceed.
Also, we aren't getting the error messages ALL the time, they start to
appear after a day or two and gets more and more frequent untill I restart
mysql. Any other ideas?
-- Henrik
gerald_clark skrev:
It's been going on for months, so that doesn't seem very likely. On the
other hand, we have had 2 or 3 other hard drives go bad with other servers
at this host, so I'm not ruling it out.
-Original Message-
From: Big Brother [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 12:04
Similarly, you can also use GROUP BY
SELECT WHAT FROM TRANSACTION WHERE REGDATE Now() -INTERVAL 15 DAY
GROUP BY WHAT
The benefit of using GROUP BY as opposed to DISTINCT is that you can use the
set of functions that work on groups like COUNT, SUM, MIN, MAX, etc...
SELECT WHAT,
However, you can use HAVING. HAVING is post-processed, in a brute force
method (no indexes can be used).
Select invno, invdate, invamt, left(invdate,2) as month from
salesfile HAVING month = '01'
But I would use Roger's example since it can take advantage of indexes.
Regards,
Erik
Hi,
Have you tried netstat -a on the box with the MySQL server? This command
(Linux) will show what is connected to where, and will help you double check
that there really aren't any open connections to the server.
Thanks,
Mike
-Original Message-
From: Henrik Skotth [mailto:[EMAIL
I had a similar problem with an Oracle database once. It turned out to be some memory
in the process of going bad.
John
-Original Message-
From: Jon Wagoner [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 2:24 PM
To: [EMAIL PROTECTED]
Subject: RE: periodic corruption problem
Hello MySQL pros worldwide,
~/www -cat seeLog.c
#define USE_OLD_FUNCTIONS
#include stdio.h
#include mysql/mysql.h
int main() {
MYSQL mysql;
MYSQL *mysqldb = NULL;
mysqldb = mysql_connect(mysql, geneofcube.net, USERID,
PASSWORD);
return 0;
}
~/www -gcc seeLog.c
I will switch to the secondary server tonight and see if the problems clear
up. Thanks for the response.
-Original Message-
From: John Griffin [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 1:49 PM
To: Jon Wagoner; [EMAIL PROTECTED]
Subject: RE: periodic corruption problem
I
I have an users table for a php application that I am programming. The
current users table has about 1500 records. I would like to create a test
table (i.e. users_test) with 10,000 records based on random data from the
first table (i.e. random first name combined with a random last name,
etc...).
What about making the table INNODB? If you make INNODB's buffer large
enough, the high activity data/index blocks are retained in memory.
INNODB's non blocking read and single statement transaction default
should make the transaction overhead minimal and INNODB doesn't have
any of the HEAP table
On Mon, Nov 10, 2003 at 05:03:35PM +0100, Harald Fuchs wrote:
In article [EMAIL PROTECTED],
gerald_clark [EMAIL PROTECTED] writes:
Matt W wrote:
Hi Jeremy,
Sorry, it seems like I'm saying this a lot lately. Is it not true that
if the whole table will fit in [free] RAM, that the OS
Hi,
I am sure I say someone asking a similar question on the list before but
I can't find anything in the archives, nor anything relevant in the
mysql docs.
Is it possible to have two versions of mysql running side-by-side on
linux and if so, are there any installation instructions anywhere? I
Hi Everyone,
I'm wondering is there any way we can make MySQL database directly
'talk' with Oracle database? For example, directly transfer data
between each other.
Thanks for any input.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: Chen, Mao [mailto:[EMAIL PROTECTED]
--Sent: Monday, November 10, 2003 2:25 PM
--To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
--Subject: MySQL
I'm using OpenOffice 1.1.0 as a front-end to MySQL 4.0.14 on Gentoo
Linux and can't compare a field to CURDATE(). The error is, The field
cannot be compared with a date. The column is formatted as a DATE, and
I can perform the compare fine using mysql.
I realize this is probably related only to
[EMAIL PROTECTED] wrote:
Hi
It gives me great pleasure to inform you that Rekall, the cross-platform
alternative to MS Access, is now totally GPL. So please visit
http://www.totalrekall.co.uk and download download a copy for yourself.
Is there source code available? I can only find binary
Anyone use Veritas FlashSnap to back up data or even better yet mySQL
databases over NFS?
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
hi Steffan,
i already email you about the null result,
it should be eliminated with a where statement (not including null value)
and about the long time it took,
maybe you shuld add some index to your table...
i suggest
alter table customer add index parents (pid);
alter table customer add
At 07:45 PM 11/7/2003, Jonathan Terhorst wrote:
snip
One way I have found to implement this is
SELECT Table1.id from Table1 JOIN Features USING(id) WHERE
Features.FeatureCode='A01' OR Features.FeatureCode='B02' GROUP BY Table1.id
HAVING COUNT(*)=2;
e.g. counting the duplications of id and
Hi Erik,
No, Roger's method can't use an index. :-) But yes, using WHERE is
better than HAVING.
To get the WHERE to use an index, don't use a function in the
comparison:
SELECT invno, invdate, invamt, LEFT(invdate, 2) AS month
FROM salesfile
WHERE invdate LIKE '01%';
And I would guess
I'm relatively new to MySQL, and I'm writing a PHP script that doesn't know
what kind of system the MySQL database is on. The script and database
don't have to be on the same system, so I need a way to determine what kind
of system (*nix, Win, etc.) MySQL is running on. Is there a fool proof
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 5:47 PM
To: Erik Osterman; [EMAIL PROTECTED]
No, Roger's method can't use an index. :-) But yes, using WHERE is
better than HAVING.
Ah... right indeed. In this case it wouldn't work. My mistake... :)
To get the
SELECT DISTINCT f.id FROM Table1 AS t, Features AS f
WHERE f.id = t.id AND f.FeatureCode IN ('A01', 'B02');
HTH
what if i have a record that have 'A01' in the features, but not 'B02'
wouldnt it still be displayed in the result?
as far as i know, IN keyword act simply as OR keyword
didnt
what if we use the function at the right side of the equation?
such as
select anything
from table1, table2
where table1.id=left(table2.id,somenumber)
having both id in table were indexed
dont you think the index in table1 would still be used.. :)
cmiiw
-leo-
- Original Message -
Well, that is correct although it would still need to iterate over all rows
in table2.
Given the nature of the original problem, we're dealing with a single table
in which case it would always need to iterate over all rows of the table.
Indeed another good clarification! A more accurate
what a front-end is? And what OO1.1.0 provides?
Marc [EMAIL PROTECTED] wrote:I'm using OpenOffice 1.1.0 as a front-end to MySQL
4.0.14 on Gentoo
Linux and can't compare a field to CURDATE(). The error is, The field
cannot be compared with a date. The column is formatted as a DATE, and
I can
Hello
Can somebody tell me the exact version of MySQL from
which the functionality of adding COMMENTS to columsn
was added.
Karam
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
MySQL General
Is there any definitive answer yet for the ability to compile a
working, 64bit Mysql?
The mysql documentation says that mysql performs far better for heavy
queries using 64bit. I assume, also, that the new memory limits also
help if you allow mysql to take advantage of them, as I have read in
Hi,
Does anybody know of HPVEE client code for connecting to a MySQL database?
Best regards,
Per
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
76 matches
Mail list logo