Hi!
On Apr 07, Hirofumi Fujiwara wrote:
From: Sergei Golubchik [EMAIL PROTECTED]
Hi!
On Apr 06, Hirofumi Fujiwara wrote:
I am testing regular expression feature of MYSQL 4.1.1-alpha
(REGEXP) with UTF-8 characters (Japanese). So far it doesn't
seem to work.
LIKE
Hi,
Encounter an interesting here using VB.NET with ByteFx.mysql.mysqlclient to
connect to Mysql Database.
I have a sub-form (called from another main form) with 4 mysqlconnections
declared and new.
X1= new mysqlconnection
X1.connectionstring = a valid connection string
X1.open()
X2= new
Hi,
I have recently had a system crash that required the installation of a new hard drive.
I have access to the files on the old hard drive, on which is a database I need to
recover.
I am running MySql 3.23.37 and all the tables in the database to be recovered are
MyISAM.
How can I recover
Hi,
I have recently had a system crash that required the
installation of a new hard drive. I have access to the
files on the old hard drive, on which is a database I
need to recover.
I am running MySql 3.23.37 and all the tables in the
database to be recovered are MyISAM.
How can I
Andy Hall [EMAIL PROTECTED] wrote on 07/04/2004 09:50:19:
Hi,
I have recently had a system crash that required the installation of
a new hard drive. I have access to the files on the old hard drive,
on which is a database I need to recover.
I am running MySql 3.23.37 and all the
Hi,
I have recently had a system crash that required the
installation of a new hard drive. I have access to the
files on the old hard drive, on which is a database I
need to recover.
I am running MySql 3.23.37 and all the tables in the
database to be recovered are MyISAM.
Hi,
I have recently had a system crash that required the
installation of a new hard drive. I have access to the
files on the old hard drive, on which is a database I
need to recover.
I am running MySql 3.23.37 and all the tables in the
database to be recovered are
Victor Medina [EMAIL PROTECTED] wrote:
When compiling mysql(4.0, 4.1 or 5) can I use a external Berkeley db
source, and not the one provided with mysql source? I know that the
configure script provides a --with-berkeley-db-includes and -libs, but..
up to what version of bdb can i use? Can
That did it. I really do appreciate all of the help that I received from you
and the list.
Thanks again. :)
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 7:52 PM
To: Marvin Cummings
Cc: [EMAIL PROTECTED]
Subject: Re: Need help creating
TTBMK, there is no such thing as 'auto flush' in MySQL.
When you say Everytime I add some record on my local computer then upload
... are you saying you upload the raw database files (from your data
directory), or are you inserting/updating the data in your Linux databases
with a query?
If you
Afternoon all. I wonder if any experts on the join optimiser could help me
out. I have read the docs, including the material on how mysql optimises
joins, and have redesigned my schema somewhat to try and simplify the joins,
and that has worked to some extent. But I am still way off the
Francisco Ivan Anton Prieto [EMAIL PROTECTED] wrote:
Egor Egorov wrote:
Francisco Ivan Anton Prieto [EMAIL PROTECTED] wrote:
I am crazy with a problem.
I would like to know the best method to SELECT affected rows after an
UPDATE.
If you set column values to the new (different from current
Hi,
I am only a very occasional mySQL user and I need some help with a join.
Our internal helpdesk is done in mySQL and PHP. I have been asked to dump
some of the contents of the database into a file for loading into a data
warehouse.
The following query is getting the data from the workorders
More information to add :
Am using Bytefx 0.76 :
I simplify the testing by using frmA call frmB.
In frmB, I do the following :
Private Sub frmB_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Try
xx = New MySqlConnection
By the way, we're using Version 3.23.49 on linux
Ciaran.
CiarĂ¡n O'Neill
IT Department,
United Drug Plc,
Magna Business Park,
Citywest Road,
Dublin 24.
* +353 1 463 2535
Fax +353 1 463 2397
* www.united-drug.com
**
This
* O'Neill, Ciaran
[...]
I want to get everything from this table, even if there is no
corresponding record in the personnel table.
This is a typical task for a LEFT JOIN, try something like this:
select workorders.jcn AS WO Number,
workorders.seq
I think the problem is here:
and (workorders.closedby = personnel.id OR workorders.closedby IS NULL)
There is no way for a personnel record to be selected if the closedby value
is NULL, so no record gets selected. The simplest way to fix this is to add
a 'null' personnel record with
That worked perfectly. I've never had much luck with joins!
Thanks.
Ciaran.
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: 07 April 2004 12:52
To: [EMAIL PROTECTED]
Cc: O'Neill, Ciaran
Subject: Re: Joins
* O'Neill, Ciaran
[...]
I want to get everything from
I ran into the same issues on RH8, with a default implmentation. It can be
overcome, but the mysql failed to
write to the table after 2gb or so. It turned out to be a filesystem
limitation issue, which was fixable. I am
not sure, but given the size of files nowadays, RH9 defaults probably take
We have two tables
Table1:
-
ID |Name
1 |name1
2 |name2
3 |name3
4 |name4
Table2:
---
PL | PC
SELECT ta.Name,tb.Name,tc.Name,Description
FROM Table2,Table1 ta,Table1 tb,Table1 tc
WHERE ta.ID=PL AND tb.ID=PC AND tc.ID=PA;
Jim
(This email has been scanned for viruses by www.emf-systems.com)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Looks like I trod on original post - forgot to add RE: to subject. Sorry
about that!
Jim
(This email has been scanned for viruses by www.emf-systems.com)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SELECT ta.Name,tb.Name,tc.Name,Description
FROM Table2,Table1 ta,Table1 tb,Table1 tc
WHERE ta.ID=PL AND tb.ID=PC AND tc.ID=PA;
Should work
Jim
(This email has been scanned for viruses by www.emf-systems.com)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Jim Page - EMF Systems Ltd wrote:
SELECT ta.Name,tb.Name,tc.Name,Description
FROM Table2,Table1 ta,Table1 tb,Table1 tc
WHERE ta.ID=PL AND tb.ID=PC AND tc.ID=PA;
Should work
Jim
(This email has been scanned for viruses by www.emf-systems.com)
I t may work, but it may consume all ram and
Hello, MySQL gurus,
I have been trying to output the result of some large query to a temporary
table and then query from there. But all my trials ended up 'ERROR 2013 at
line 7: Lost connection to MySQL server during query' before creating the
temporary table. The version of MySQL is 3.23.54,
Hi,
I'm writing a database for an online candle store. Here's the situation. This store
sells all sorts of items including candles. Now the gist is that some of the candles
can be made in different types of waxes and some only have one wax. My question is
how do I resolve this when I write
What is your max packet size? Are you able to determine where the `error`
occurs in the process? During the load of the temporary table? During the query
of the temp table?
On Wed, 07 Apr 2004, Ginger Cheng wrote:
Hello, MySQL gurus,
I have been trying to output the result of some large
Well I guess it depends on what is meant by Default.
I was using RH8 and had no such issues, even with RH7...
I think it's important to note the filesystem chosen
can make a huge difference.
as of RH8 and onward I'd suggest EXT3, especially for Peter's
issue of possible corruption - because it
Thanks for the suggestion, but according to explain we are in worse shape
than before. In both cases the multi-column index is ignored. I am going to
try fiddling with the index col order to see if this helps.
Here is what it comes up with as you suggested:
Query1:
explain SELECT COUNT(*) as
JOHN MEYER [EMAIL PROTECTED] wrote on 07/04/2004 15:39:10:
Hi,
I'm writing a database for an online candle store. Here's the
situation. This store sells all sorts of items including candles.
Now the gist is that some of the candles can be made in different
types of waxes and some
Hi,
The max packet site is 1048576. But I don't think it is a problem cuz I
have successfully outputted the result of this query before. I checked
mysqld.log. This is the tail I think might related to the problem:
Number of processes running now: 0
040406 22:22:01 mysqld restarted
Cannot
Forgive me, but it would be a cartesian product if there were no where
condition, I agree? It would return (size Table1)x(size Table2)^3 rows,
definitely not what Tariq wants. The query I supplied will return (size
Table2)x(1)^3 rows won't it? Or am I missing the point?
Jim
SELECT
James McConnell wrote:
Hey all. I had asked a few days ago if anyone had experience installing 4.1
on the Mac and got no reply, but that's cool :-). Has anyone installed 5.0
on the Mac? Any problems? I'd like to try it, but I thought I'd ask and
see if there was anything I needed to know
I have the following in my /etc/my.cnf
[mysqld]
datadir=/usr/data/mysql
pid-file=/usr/data/mysql/mysql.pid
socket=/usr/data/mysql/mysql.sock
user=mysql
[mysql_safe]
log-error=/usr/data/mysql/mysql.err
[client]
socket=/usr/data/mysql/mysql.sock
I tried originally to put the log-error= in the
I think this is the problem (cited from mysqld.log)
Some pointers may be invalid and cause the dump to abort...
followed by my query to create the tmp table
But I am not sure how to fix it.
ginger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I'm not sure why this is happening, but the behavior you described in
the first email is correct pooling behavior. By default, connection
pooling is enabled which means connections are not killed when they are
closed but remain open and able to serve new connections if necessary.
Only when the
You are correct Jim..
This is certainly not Cartesian.
Jim Page - EMF Systems Ltd [EMAIL PROTECTED]
04/07/2004 10:09 AM
Please respond to Jim Page - EMF Systems Ltd
To: gerald_clark [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject:Re: stuck with
I would like to ask a question here, just for my own knowledge. What is actually the
difference between the statement below and this one?
SELECT Table1-1.Name AS 'PL', Table1-2.Name AS 'PC', Table1-3.Name AS 'PA'
FROM Table2
LEFT JOIN Table1 Table1-1 ON Table1.ID = Table1-1.PL
LEFT JOIN Table1
Wait, I see it now :)
-Original Message-
From: Luc Foisy
Sent: Wednesday, April 07, 2004 10:45 AM
To: [EMAIL PROTECTED]
Subject: RE: stuck with simple query. Plz have a look
I would like to ask a question here, just for my own knowledge. What is actually the
difference between
Not the 5.0!!!
Santino
At 10:02 -0400 7-04-2004, Victor Medina wrote:
James McConnell wrote:
Hey all. I had asked a few days ago if anyone had experience installing 4.1
on the Mac and got no reply, but that's cool :-). Has anyone installed 5.0
on the Mac? Any problems? I'd like to try it, but
At 10:10 -0400 4/7/04, Luc Foisy wrote:
I have the following in my /etc/my.cnf
[mysqld]
datadir=/usr/data/mysql
pid-file=/usr/data/mysql/mysql.pid
socket=/usr/data/mysql/mysql.sock
user=mysql
[mysql_safe]
log-error=/usr/data/mysql/mysql.err
[client]
socket=/usr/data/mysql/mysql.sock
I tried
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
NanFei Wang wrote:
Hi,
somebody can help me!
my database is: mysql-5.0.0a-alpha
the connection driver is:mysql-connector-java-3.1.1-alpha-bin.jar
I want to test stored procedure of the new feature in MySQL version
5.0. A
I can call the
To clarify:
Mac OS X does not come with mysql 5.0 bundled.
You can download a mysql 5.0 binary for Mac OS X from the mysql site
http://www.mysql.com/downloads/mysql-5.0.html.
Michael
Santino wrote:
Not the 5.0!!!
Santino
At 10:02 -0400 7-04-2004, Victor Medina wrote:
James McConnell wrote:
Hi,
I am using mysql and I need to store timestamp.
In input I got something like yyy-dddThh:mm:ss,
ddd beeing the day of the year!
I would like to make the minimun transformation before
loading data in database, so I would like to enter the timestamp
with a format handling decimal year yyy.ddd
At 17:34 +0200 4/7/04, Pierre Didelon wrote:
Hi,
I am using mysql and I need to store timestamp.
In input I got something like yyy-dddThh:mm:ss,
ddd beeing the day of the year!
I would like to make the minimun transformation before
loading data in database, so I would like to enter the timestamp
A couple days ago, I posted a careful message of my troubles, but no
reply to date. Remember, after I tried to assign a password for the
root user, it broke.
Since then, I discovered that Mac OS X refuses to let me create a user
account called 'mysql'. Apparently that account comes
i wouldn't say there is no pity, but there is probably a very low
concentration of mysql people running on macos.
Just my two cents...
dan
Kevin Jaques wrote:
A couple days ago, I posted a careful message of my troubles, but no
reply to date. Remember, after I tried to assign a password for
Dear users
IS there a list of tools that work with mysql 4.1 which includes the spatial
extension ?
Many Thanks
Saurabh Data
___
Saurabh Data
School of Computing
University of Leeds
Leeds LS2 9JT
U.K.
one who seeketh , will
Everything I've read about creating online stores is that you are
selling inventory items, not the items that makeup the inventory item.
So if you sell a red candle made from wax X, candle is the product and
red wax X are two attributes of the product.
Ideally your structure would work for any
I know nothing about Macs specifically. However under linux ...
My first question would be 'what's in the error log'? Often in
/var/lib/mysql/host.err
Next, have you run the mysql_install_db script to create default databases
and permissions?
Next, have you checked that use mysql has permission to
At 9:58 -0600 4/7/04, Kevin Jaques wrote:
A couple days ago, I posted a careful message of my troubles, but no
reply to date. Remember, after I tried to assign a password for the
root user, it broke.
Since then, I discovered that Mac OS X refuses to let me create a
user account called 'mysql'.
Jim Page - EMF Systems Ltd [EMAIL PROTECTED] wrote on 07/04/2004
17:14:57:
PS I am answering loads of questions in the hope that the power of my
Karma
will force someone to answer mine ... (join problem:indexed columns being
ignored)
My first reaction would be to turn your index
Many thanks Alec. I need to wait a couple of hours before I can block access
to the DB by messing with the indexes, but I will try out what you suggest.
What you say makes sense as probably over 99% of the values in that first
col will be 'y'. I will post my progress. I am also looking into
Hi there,
I've got a bizarre problem I can't seem to solve. I have a small MyISAM
table (6533 rows) with a small FULLTEXT index (3 columns per row, an
average of 1 word per column). When I do an INSERT on the table, many
times the thread gets stuck perpetually in Query | update. Future
I'm not sure if this is part of your problem or not Kevin,
seems you have a few issues, so I'll cover them one at at time...
getting the permissions and ownership correct, this is cut/paste from the
INSTALL docs, pretty much cut/pasteable to your sytem (errr):
groupadd mysql
useradd -g mysql
+--+
| isl_player |
+--+
| pla_id |
| pla_username |
+--+
+--+
| isl_login|
+--+
| pla_id |
| log_created |
+--+
+--+
| isl_transfer |
+--+
| pla_id |
| tra_amount |
I'm not 100% sure as to what you are trying to do, however, the relationship
you describe could, I believe, be modeled as:
Candles (candleid, description, price)
Waxes (waxid, name/description)
Candle_Waxes (candleid, waxid)
Thus one table holds the description and price of each candle, another
I'm in the process of trying to move some of our systems to MySQL from SQL Server and
Oracle. At this point I'm learning and testing MySQL.
One immediate question I have is regarding getting aggregate information. For
example, the SHOW DATABASES command would be an example of something I
If apple continues to bundle MySQL with panther and does not give any
kind of support for it's users, they should at least donate a few
machines to us, so we can play with it and give some kind of
support! YEAP I'll keep dreaming! =) jeje
--
Hi,
I am trying to install MYSQL on a Sun Solaris box and here are the details and the
error.
Here is the version of MYSQL I am trying to install:
mysql-max-4.0.17-unknown-freebsd5.1-sparc64
#uname -a
SunOS kittyhawk 5.8 Generic_108528-23 sun4u sparc SUNW,Ultra-1
#
yeah, there's a whole lot wrong with that.
1. you're using the wrong versions of mysql,
the freebsd sparc64 version wont work on solaris,
perhaps you should get the solaris package?
hrm, just a thought...
and 2, it actually has to be installed before you try to run it,
best option is to read the
Hello List:
I have run into stone wall in figuring out installation of Perl DBI modules
with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on
Unix,
it mentions that the easiest way to install Perl DBI is to use CPAN.
However when I go to the link provided in the
Did you run it from the directory from which you install mysql? EG:
Installed mysql at /usr/local/mysql-max-4.0.18-sun-solaris-etc
cd /usr/local/mysql-max-4.0.18-sun-whatever-the-rest-is
./bin/mysql_install_db --user=mysql
a.. If you installed MySQL using a binary distribution, use this
Just type in the empty search box at the top of the screen:
DBI returns:
http://search.cpan.org/~timb/DBI-1.42/DBI.pm
mysql returns:
http://search.cpan.org/~rudy/DBD-mysql-2.9003/
Hope that helps
Ken
- Original Message -
From: Kirti S. Bajwa [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
you can install Perl modules with
$ perl -MCPAN -e shell
cpan install [module::name]
- hcir
mysql
- hcir
On Apr 7, 2004, at 10:57 AM, Kirti S. Bajwa wrote:
Hello List:
I have run into stone wall in figuring out installation of Perl DBI
modules
with MySQL. When I review the MySQL
Short answer:
Type 'cpan'
Type 'install DBD::mysql'
More information is at:
http://search.cpan.org/~rudy/DBD-mysql-2.9003/lib/DBD/mysql/INSTALL.pod
General information about installing Perl modules:
http://www.cpan.org/misc/cpan-faq.html#How_install_Perl_modules
I'm not exactly sure whether this will work on UNIX but on Linux it's
just
type cpan in your console
than you should get the cpan console
there you can search with i /dbi::mysql/ for your module
and install #module name# gets you the module.
hope that helps
btw. h shows help text and there is a
it mentions that the easiest way to install Perl DBI is to use CPAN.
However when I go to the link provided in the documentation
http://search.cpan.org, I can't figure out how to find the Perl module.
Can someone show me the light.
I'm not sure about the light, but when I typed in DBI in the
Eamon Daly wrote:
Short answer:
Type 'cpan'
Type 'install DBD::mysql'
Contrary to intuition, you should install DBI first! DBD::mysql will look
for DBI too.
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Dear users
Can someone give me a brief description of version 4.0 , 4.1 and 5.0
The website says that 4.0 is a production release where as version 4.1 and
5.0 are alpha releases.
I mainly want to know the difference between 4.1 and 5.0 . Why dhould one
one 4.1 and not 5.0 and viceversa
At 22:46 + 4/7/04, Saurabh Data wrote:
Dear users
Can someone give me a brief description of version 4.0 , 4.1 and 5.0
The website says that 4.0 is a production release where as version
4.1 and 5.0 are alpha releases.
I mainly want to know the difference between 4.1 and 5.0 . Why
dhould
Hello List:
--
I left out the following information (sorry too much on mind):
RH 9
MySQL 0.9.3 (Installing both Server Clients
--
I have run into stone wall in figuring out installation of Perl DBI modules
with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on
Unix,
Thank you all for the responses. Looks like no one's had problems getting
5.0 running on the Mac. I'll be trying it after this weekend. If I have
any problems, you'll be hearing from me again! Thanks for all the info.
James
--
MySQL General Mailing List
For list archives:
Hello again,
How do you make a field unique, but not have it as part of the primary key?
For example, I have a 'computers' table that has a 'comp_id' field that's the
primary key. It's an int that's auto-incremented with each new entry. The
same table has a 'comp_serial' field. I want this
Brad Tilley wrote:
Hello again,
How do you make a field unique, but not have it as part of the primary key?
For example, I have a 'computers' table that has a 'comp_id' field that's the
primary key. It's an int that's auto-incremented with each new entry. The
same table has a 'comp_serial'
Thanks reggie, implement that and tested the scenario as per my first email,
it work the desired way as per you have expected and suggested.
My feeling about the second scenario is that it is a bug.
Try this link and search for the exception text:
Please read the attached file.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mike,
I see what you're saying `active` was the alias name not an actual
column. Ironically I was using a HAVING clause because I agree with
that last post.
Mike, why keep the `IF` statement? You're really saying give me all the
records where this expression is true. Why not just move the
BAO RuiXian wrote:
Mark wrote:
Eamon Daly wrote:
Short answer:
Type 'cpan'
Type 'install DBD::mysql'
Contrary to intuition, you should install DBI first! DBD::mysql will
look for DBI too.
DBI only needs to be installed once. After the installtion, you may
need to add as many as
What is the best way to diagnose the root cause of this error? What scripts
are doing the connecting and totalling them up?
Warning: mysql_connect(): User ultimated has already more than
'max_user_connections' active connections
I have a very active phpBB but I'm on a new server and its not
Run mysqladmin extended-status
Look for something like this:
| Max_used_connections | 138|
If it says, 512 is your max connections that you have used, then you need to
raise it. If your number is much lower and you are getting that problem,
it's a different problem, but that's just
81 matches
Mail list logo