From: Nathan Mealey [EMAIL PROTECTED]
Has anyone out there had any trouble installing DBD::MySQL for MySQL
4.1.x on Mac OS X 10.3? I have tried it on several machines in my
company's office, but it fails on all that are running 4.1.x, and
installs fine on those running 4.0.x
Thoughts?
Try
- Original Message -
From: Wesley Furgiuele [EMAIL PROTECTED]
To: Alexander Newald [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 1:41 AM
Subject: Re: Get lines matching a select / group by query
Use COUNT():
SELECT COUNT( id ) FROM test WHERE LEFT( id, 5 ) =
Hi,
Here are the tables :
CREATE TABLE markets (
Id integer NOT NULL auto_increment,
ContractCode varchar(20),
PRIMARY KEY (Id),
) TYPE=InnoDB;
CREATE TABLE strategies (
Id integer NOT NULL auto_increment,
StrategyCode char(15) NOT NULL DEFAULT '',
Hello All,
The new version of DBACentral for MySQL has been released. Since now
DBACentral for MySQL works with all MySQL server versions, currently
released. Also a lot of new options are added in the new version, and
a bunch of bugs are fixed.
Download page:
Tim Johnson wrote:
Hello:
Installing MySQL-server-4.0.21-0.i386.rpm
on Red Hat 9.0
Getting the following:
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) MySQL-python-0.9.1-6
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3
Hi Philippe,
how about this:
SELECT strategyid, COUNT(marketid) cnt
FROMstrategies_markets
WHERE marketid in(selected markets here)
GROUP BY strategyid
ORDER BY cnt DESC;
The resultset should contain the best matches, in descending order. To
find strategies that contains all markets (but
Hello All,
First of all I would like to mention that I am newbie using mysql. So I am sorry if I posted it wrong but
is there any way by which I can secure my data files such that even if the data files are copied to other mysql server it cannot be accessed. Some form of password
I'm writing my first MySQL app in VB.net using myODBC. However I think this
question applies to all languages using MySQL. From what I understand, I
am unable to issue a batch statement of commands separated by commas to
mySQL. I receive an error whenever I try to do so from my app. For this
What version of MySQL are you using? I believe multiple delimited
statements are available in 4.1.x and later.
Jeff Burgoon wrote:
I'm writing my first MySQL app in VB.net using myODBC. However I think this
question applies to all languages using MySQL. From what I understand, I
am unable to
Josh Trutwin [EMAIL PROTECTED] wrote on 09/20/2004 10:41:46 PM:
On Mon, 20 Sep 2004 10:25:16 -0400
[EMAIL PROTECTED] wrote:
I think you missed my point. I think the 5.0.1 behavior was correct
and the others are wrong. There is a known bug (or two) about mixing
outer joins and inner
4.0.20a-max, just because I thought this was the most stable build.
Victor Pendleton [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
What version of MySQL are you using? I believe multiple delimited
statements are available in 4.1.x and later.
Jeff Burgoon wrote:
I'm writing my
or... for me this rpm was the solution:
MySQL-shared-compat-4.0.21-0.i386.rpm
from:
ftp://gd.tuwien.ac.at/db/mysql/Downloads/MySQL-4.0/MySQL-shared-compat-4.0.21-0.i386.rpm
Philippe Poelvoorde wrote:
Tim Johnson wrote:
Hello:
Installing MySQL-server-4.0.21-0.i386.rpm
on Red Hat 9.0
Getting the
Victor, I think I found what you're referring to:
http://dev.mysql.com/doc/mysql/en/C_API_multiple_queries.html ...
From version 4.1, MySQL supports the execution of multiple statements
specified in a single query string. To use this capability with a given
connection, you must specify the
For multiple statements in one submission, have you tried using a
semicolon ; not a comma , ?
(http://dev.mysql.com/doc/mysql/en/Entering_queries.html)
Each command may return a recordset of its own. Be prepared to either
cycle through the returned recordsets or ignore them as they arrive.
On Tue, 21 Sep 2004 08:57:21 -0400
[EMAIL PROTECTED] wrote:
snip
There are up to three layers of record filtering that happen during
any query. First is the JOIN filtering. That is where the ON
conditions are used with the table declarations to build a virtual
table that consists of all
On Tue, 21 Sep 2004, VijayKumar Dogra wrote:
is there any way by which I can secure my data files such that even if
the data files are copied to other mysql server it cannot be accessed.
Some form of password protection or similar ?
The short answer is: 'no'. You have to protect your server.
Hey. Thanks.
First off, I meant to say semicolon (;) in my first post but I mistyped and
said comma by accident. I am trying to use semicolon as my delimiter. This
method works if I issue statements from PHPMyAdmin, but not through my ODBC
app.
However, your pseudocode made me realize
MySQL 4.0.14
In a scenario:
Ref EmailAddr
1[EMAIL PROTECTED]
2[EMAIL PROTECTED]
3[EMAIL PROTECTED]
4[EMAIL PROTECTED]
how can I delete duplicate email entries (records 1,
2) leaving 4.
regards
Hello all,
Ok i know this may be a simple question but i need a little help.
I am writing a program in VB.net that uses MySQL as a backend. My net admin
wants the log on to be encrypted??
This is currently how i am connecting:
Public LocalSYS As New OdbcConnection(DRIVER={MySQL ODBC
- Original Message -
From: A Z [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 10:02 AM
Subject: Duplicate Rows
MySQL 4.0.14
In a scenario:
Ref EmailAddr
1[EMAIL PROTECTED]
2[EMAIL PROTECTED]
3[EMAIL PROTECTED]
4
Hi Roger,
I took the suggestion from Brad Eacker and use BETWEEN and now works without
problem. However, I decided to do a couple more tests and what I found was
that the problem occurs on MySQL version 4.0.18-standard using InnoDB on
Linux but does not occur on Mac OS X using the same MySQL
Josh Trutwin [EMAIL PROTECTED] wrote on 09/21/2004 09:40:03 AM:
On Tue, 21 Sep 2004 08:57:21 -0400
[EMAIL PROTECTED] wrote:
snip
snip again
Perhaps another example would help. I've been trying to re-write
another join query that's designed to produce an attendance record for
each
I did a little deeper reading and the MySQL C API (probably the same API
they wrote the ODBC driver with) does not support multiple statements
through most (if not all) of its querying interfaces:
http://dev.mysql.com/doc/mysql/en/mysql_query.html
On Tue, 21 Sep 2004 10:49:31 -0400
[EMAIL PROTECTED] wrote:
Hmmm. you want to see a student, all of the classes they are
enrolled in and how many times they attended? I understand the
relationships between the student, class, and class_attended tables
(that's all related to attendance and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.1.5, a new version of the popular Open Source/Free Software
Database Management System, has been released. It is now available in
source and binary form for a number of platforms from our download pages
at http://dev.mysql.com/downloads/
I have a table with 9 columns, one is an auto_increment for primary key.
Data set:
2004-09-21 10:35:50,2004-09-21
10:45:48,tcp,111.111.111.111,80,222.222.222.222,1555,4700
Currently I just dump everyting into one table and query it that way. I was hoping to
learn how to place the data into
Hi Everybody,
The following is my scenario:
mysql select mop_id, job_id, end_time, start_time,
end_time-start_time from bjs_stat where sol_id = '';
+++-+-+-+
| mop_id | job_id | end_time| start_time
Time is converted to numbers then subtracted.
--
With best regards, Gleb Kozyrev.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
InnoDB is a MySQL table type which provides ACID transactions, row-level
locking, consistent, non-locking SELECTs (MVCC concurrency control), FOREIGN
KEY constraints with CASCADE options, and a commercial hot backup tool.
Release 4.1.5 is mainly a bugfix release. InnoDB bug fixing is lagging
That seems to be vague to me.
I would like to know how the time is converted to numbers? is it upto
seconds or even beyond that?
happier if resolved,
Thanks in advance.
reg,
Eldo.
On Tue, 21 Sep 2004 21:46:02 +0300, Gleb Kozyrev [EMAIL PROTECTED] wrote:
Time is converted to numbers then
Hi folks:
I have an InnoDB database, the tables created using MySQL Control Center
0.9.4-beta (winXP pro platform).
Each table has some columns which I have checked as Nulls Allowed.
I am building a pure Java GUI to the database. Got the SQL statements
working fine, but have
discovered that I
I am trying to create a table (projects) with the following basic column structure:
id (primary key)
id_client
id_clientkey
The ideas is that I will fill it with data like this:
table: projects
id id_client id_clientkey
-
1 1 1
2
Thomas,
Are you sure that encrypting the connection string is what your network admin means?
When I hear someone say they want the logon encrypted I would think they mean store
the password of a user encrypted in the db. That is, the application requires the user
to logon and user info is
On Wed, 22 Sep 2004 00:20:32 +0530, Eldo Skaria [EMAIL PROTECTED] wrote:
That seems to be vague to me.
I would like to know how the time is converted to numbers? is it upto
seconds or even beyond that?
happier if resolved,
It is converted in such a way that looking at number we can easily
Read this: http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html
and post the SHOW CREATE TABLE for your projects table if that didn't
answer your question.
Thanks!
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Dan Tappin [EMAIL PROTECTED] wrote on 09/21/2004
You can connect securly using ssh and perform port forwarding through the
tunnel.
Paul
-Original Message-
From: Joe Audette [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 2:32 PM
To: [EMAIL PROTECTED]
Subject: Re: Secure logon from VB.net
Thomas,
Are you sure that
Thanks,
Actually it is the transmission connection string he is worried
about. I might have to go with an SSL connection and go from there.. The
problems being that I'm not sure what software i have available to me on
the server and what software i can add to the client machines..
this
Thomas,
http://dev.mysql.com/doc/mysql/search.php?q=ssllang=encharset=iso-8859-1
It looks like SSL/SSH are only available as of MySQL 4 or higher.
Is your Net Admin really worried about eaves dropping of packets on the local network.
It must be very sensitive data. If you already have a MySQL
Hi Shawn,
First off thanks for the tip. I had read that page once already but after reading
twice again after your post I realized that the
answer was right there. Wrapping that concept around my brain really hurt but I get
it now.
I had this:
CREATE TABLE projects
(
id int auto_increment,
Hi,
MySQL seems to be able to JOIN columns with different types, e.g., one
column type is int; the other type is varchar. My question is: how badly
does that affect the join performance even though both columns are indexed.
Thanks!
Qunfeng
--
MySQL General Mailing List
For list archives:
Hi Joe,
My understanding is, and please don't quite me on this one, is
that it is a shared server.. If i'm right the server that my db will be
running on also houses some large db's for our web services, here at
Cornell. The data I'm holding is actually very, very low security, its tick
If MySQL is running on a unix/Linux server you can use the native ssh that
is available on that system and then you don't need anything special in so
far as ssh or SSL is concerned with MySQL. You don't have to use MySQL 4.x.
The basic idea from VB.net is to create an SSH tunnel to the MySQL host
A data type conversion will have to take place and depending on the size
of the tables the performance could be quite miserable.
Qunfeng wrote:
Hi,
MySQL seems to be able to JOIN columns with different types, e.g., one
column type is int; the other type is varchar. My question is: how
badly
Thomas,
Because the db is lower than version 4 and doesn't support secure connections, unless
the db is on the same box as the web server, then connection strings are already being
passed between your web servers and the db accross the local network using clear text
and those connection
Thanks! Between the ERD and your descriptions I think I've got it. Most of
the others on this list who have designed a system like yours (gradebooks
or attendance taking) designed it so that it supported multiple
instructors for multiple courses each of which have their own class
schedules (at
Just to be a little more clear, when you're doing the
subtraction like so:
2004-09-01 07:38:00 - 2004-09-01 07:37:58
MySQL converts each to numeric representations thusly:
20040901073800 - 20040901073758
which, like most things in the universe, equals 42, /not/
the 2 I think you were expecting.
Just to be a little more clear, when you're doing the
subtraction like so:
2004-09-01 07:38:00 - 2004-09-01 07:37:58
MySQL converts each to numeric representations thusly:
20040901073800 - 20040901073758
which, like most things in the universe, equals 42, /not/
the 2 I think you were expecting.
Randy,
could it be that the word 'bird' appears in more than half of all rows in
your dataset? I strongly recommend to spend a few minutes reading the
manual about Fulltext Search.
Regards,
Thomas
On Mon, 20 Sep 2004, Randy Paries wrote:
Hello
I have a table
CREATE TABLE community_files (
Hello All,
I am porting from 4.0.0-alpha-nt to 4.0.1-alpha-nt. In which i have a
table with two primary key, my older mysql server insert all the records
except the duplicate fields(Primary Key). Whereas in the new mysql
server it exits whenever it sees a duplicate entry. How to resolve it ?
Hi Michael!
Talking about the query with group by issue...
I'll explain my reasoning below.
[...]
From the manual, section 7.2.8 How MySQL Optimizes LEFT
JOIN and RIGHT
JOIN http://dev.mysql.com/doc/mysql/en/LEFT_JOIN_optimization.html:
A LEFT JOIN B join_condition is
- Original Message -
From: Suresh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 6:43 PM
Subject: Duplicate Entries
Hello All,
I am porting from 4.0.0-alpha-nt to 4.0.1-alpha-nt. In which i have a
table with two primary key, my older mysql server insert
Hi
I have installed mysql some software on aix5.2 .
the edition is MySQL-3.23.58-2.aix5.1.ppc
but when I used phpmyadmin to manage the mysql
it told me
**
#1036 - Table 'gbook' is read only
What are the MySQL permissions for the phpmyadmin
user?
If you believe that you set the phpmyadmin user up
correctly in MySQL, Did you try a 'flush privileges'
in MySQL?
HTH,
James
--- ÀîÈñ [EMAIL PROTECTED] wrote:
Hi
I have installed mysql some software on aix5.2 .
the edition is
Hello,
I currently have a table with a completed DATETIME field. I am
trying to run a query that will return all rows *inclusive* of the
start and end dates. I have tried the following query:
SELECT `name`, `completed` FROM `table` WHERE `completed` BETWEEN
'2004-07-21' AND '2004-07-23';
Jeremy Brown [InfoSend] wrote:
Hello,
I currently have a table with a completed DATETIME field. I am trying
to run a query that will return all rows *inclusive* of the start and
end dates. I have tried the following query:
SELECT `name`, `completed` FROM `table` WHERE `completed` BETWEEN
Hi,
Giving a permission of '777' to mysql dir is not advisable.
More over that may not be the problem. It should be the privilege the
phpmyadmin user is having on your Db or the specified table.
Reg,
Eldo Skaria
On Wed, 22 Sep 2004 08:36:21 +0800, [EMAIL PROTECTED] wrote:
Hi
I have
Hi,
Suresh may be expressing that he has a primary key with two fields.
Eldo.
On Tue, 21 Sep 2004 19:32:17 -0400, Rhino [EMAIL PROTECTED] wrote:
- Original Message -
From: Suresh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 6:43 PM
Subject: Duplicate
HI Daly,
Thanks A lot.
Eldo Skaria.
On Tue, 21 Sep 2004 16:09:03 -0500, Eamon Daly [EMAIL PROTECTED] wrote:
Just to be a little more clear, when you're doing the
subtraction like so:
2004-09-01 07:38:00 - 2004-09-01 07:37:58
MySQL converts each to numeric representations thusly:
Hi,
I have a setup of 2-way replication of mysql. These two servers are linked with 512K
line and data being inserted on both side. Sometimes I observed that the network
connectivity is correct but the replication sync goes down and comes up after 30 min
autometically.
Is there any story
Hello All,
Is there any way by which I canstore data files of mysql in other partition of my system
Regards,
VijayKumar Dogra
60 matches
Mail list logo