Does OLAP work with MySQL?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 1) For what I see on the MySQL manual you can have an Auto Increment not
> null Field as the primary key. Say that you have a table with only
> two columns the first being an Auto_Increment. How do I write an INSERT
> or REPLACE SQL statement to insert data on this table? Can
> I write it so that
>From http://dev.mysql.com/doc/mysql/en/union.html :
"Before MySQL 4.1.1, a limitation of UNION is that only the values
from the first SELECT are used to determine result column types and
lengths. This could result in value truncation if, for example, the
first SELECT retrieves shorter values than
Hello all,
I have two question on Auto Increment fields:
1) For what I see on the MySQL manual you can have an Auto Increment not
null Field as the primary key. Say that you have a table with only
two columns the first being an Auto_Increment. How do I write an INSERT
or REPLACE SQL statement
I have a UNION whose statements when interchanged gives a different result. I
can understand the change in the order of the rows, but how is it that
'picture' gets the correct value in (a) but not in (b)? Here are the two
queries and their results:
(a)
(SELECT u.lName last_name, u.picture FRO
Hello,
Can anyone tell me what to do in order to use transactions on a java
application? Is there any howto regarding this issu?
Thanks,
C.F.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm in need of a hotbackup solution that supports multiple instances on the
the same server. Currently, I'm dumping the databases nightly and would
like to know if anyone know of an alternative. I've tested innodb, but have
not had any success getting it to work with more than one group(mysqld[GN
Gleb Paharenko wrote:
Hello.
Are there any error messages and stack trace before 'Memory status'
line in the error log?
This is what it shows
Status information:
Current dir: /var/lib/mysql/
Running threads: 0 Stack size: 196608
Current locks:
key_cache status:
blocks used:
[EMAIL PROTECTED] wrote:
Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/05/2005 02:41:45 PM:
Following the "SELECT DISTINCT" topic, I have another question.
I tryed to UPDATE all the tables, replacing one column in every tables
with the contents of one specific row. I tried this, but the synta
On Fri, 5 Aug 2005, Joerg Bruehe wrote:
Hi Shawn, all!
Still, I would consider to replace
X > A AND X < B
by
X BETWEEN (A+1) AND (B-1)
for the reasons I gave in my original post (provided we talk about integral
values).
the field is a DOUBLE, so you can't could this also explain why
Hi Shawn, all!
[EMAIL PROTECTED] wrote:
Joerg Bruehe <[EMAIL PROTECTED]> wrote on 08/05/2005 02:08:35 PM:
[[...]]
Have you considered using BETWEEN?
[[...]]
Actually, no, he cannot substitute BETWEEN as BETWEEN is _inclusive_ of
the boundary conditions (a closed interval). In this case he
Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/05/2005 02:41:45 PM:
> Following the "SELECT DISTINCT" topic, I have another question.
>
> I tryed to UPDATE all the tables, replacing one column in every tables
> with the contents of one specific row. I tried this, but the syntax is
> incorrect:
>
Following the "SELECT DISTINCT" topic, I have another question.
I tryed to UPDATE all the tables, replacing one column in every tables
with the contents of one specific row. I tried this, but the syntax is
incorrect:
UPDATE int_contxtd_details SET params=(SELECT params FROM
int_contxtd_detai
Joerg Bruehe <[EMAIL PROTECTED]> wrote on 08/05/2005 02:08:35 PM:
> Hi David, all!
>
> David Sparks wrote:
> > I have a query that is taking days to complete (not good). If I
change
> > the query so that it selects less rows it runs fast.
>
> I fear I have no decisive hint for this (sorry), bu
Scott Noyes wrote:
Here's one (not very clean, but it works) way to do it:
SELECT id, params FROM table GROUP BY params;
The trouble is, how do you know which id should come with it? If you table is
id param
1 1
2 1
should the query return
1, 1
or
2, 1
?
This is not really what I wa
This is out of the MySQL class and is called the Max-Concat trick.
What is the biggest country in each continent?
"The Rows Holding the Group-wise Maximum of a Certain Field"
MySQL> Select Continent,
-> SUBSTRING(M
[EMAIL PROTECTED] wrote:
Depending on what version server you are running, the GROUP_CONCAT()
function may be an option for you:
SELECT params, GROUP_CONCAT(ID)
FROM table
GROUP BY params;
I'm using 4.1.10a-standard-log Server version, and this is just what I
wanted.
Thanks.
--
Nuno Perei
Now see, if I gave that away, I wouldn't have interested you, now would I?
As with all databases, you need to collect some kind of identifying
information. That's what the "save 1 or 2 tables" statement was about.
Take this simple system for example.
Table 1 ...
UserID UserNameF
Here's one (not very clean, but it works) way to do it:
SELECT id, params FROM table GROUP BY params;
The trouble is, how do you know which id should come with it? If you table is
id param
1 1
2 1
should the query return
1, 1
or
2, 1
?
--
MySQL General Mailing List
For list archives: ht
Hi David, all!
David Sparks wrote:
I have a query that is taking days to complete (not good). If I change
the query so that it selects less rows it runs fast.
I fear I have no decisive hint for this (sorry), but still ...
[[...]]
mysql> select count(*) from msgs where message_id > 112
Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/05/2005 02:04:35 PM:
> Hello list,
>
> I'm getting the distinct 'params' columns from a table with this query
>
> SELECT DISTINCT params FROM table;
>
> but this gets the rows with distinct 'params' cols, but I want to know
> from which row each par
Hello list,
I'm getting the distinct 'params' columns from a table with this query
SELECT DISTINCT params FROM table;
but this gets the rows with distinct 'params' cols, but I want to know
from which row each params correspond, like this (which is not correct)
SELECT id, DISTINCT params FROM
mysql> SELECT VERSION();
+---+
| VERSION() |
+---+
| 4.1.7-nt |
+---+
1 row in set (0.00 sec)
mysql> CREATE TABLE test (col1 INT, col2 INT, col3 INT);
Query OK, 0 rows affected (0.08 sec)
mysql> INSERT INTO test VALUES (1, 1, 1), (1, 2, 3);
Query OK, 2 rows affected (0.02
[snip]
> SELECT col1, MAX(col2), col3 FROM table GROUP BY col1;
Because col3 is not part of the GROUP BY clause, this query will not
guarantee that the col3 returned is associated with the col2 returned.
In other words, running this query on the table containing
col1 / col2 / col3
1 1
> SELECT col1, MAX(col2), col3 FROM table GROUP BY col1;
Because col3 is not part of the GROUP BY clause, this query will not
guarantee that the col3 returned is associated with the col2 returned.
In other words, running this query on the table containing
col1 / col2 / col3
1 11
1
Hi,
Is there any way to check value of of 'lower_case_table_names'? I need
to an equivalent of (MS Sql Server statement)
exec sp_server_info @attribute_id=16
Thank you,
Sunil Vishwas
[snip]
The same way you do it inother SQL's.
SELECT MAX(col2) FROM table GROUP BY col1;
[/snip]
Oops;
SELECT col1, MAX(col2), col3 FROM table GROUP BY col1;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Fri, Aug 05, 2005 at 01:29:19PM -0400, J.R. Bullington wrote:
> The way that data is stored is not at the issue. It's the way that data is
> collected that is at the heart of the RDBMS part of HIPAA.
I once interned for a major vendor of HIPAA-compliant hospital IT
solutions, doing software qua
[snip]
I have a simple table
col1 col2col3
A 2 3
A 100 70
A 100080
B20 90
B7080
To select the top one row for each unique value of col1
select distinct on (col1), col1, col2, col3
from table
order by col1, col2 desc, col3 desc;
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark Matthews wrote:
[snip]
> For example, besides containing regulations concerning techology for
> software that deals with artifacts that fall under HIPPA (but does not
> mandate _which_ technology to use), there are regulations about
> _physical_
You're looking for the rows containing the group-wise maximum.
There's an explanation in the manual, section 3.6.4,
http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html
On 8/5/05, Kemin Zhou <[EMAIL PROTECTED]> wrote:
> I have a simple table
>
> col1 col2col3
> A 2
I have a simple table
col1 col2col3
A 2 3
A 100 70
A 100080
B20 90
B7080
To select the top one row for each unique value of col1
select distinct on (col1), col1, col2, col3
from table
order by col1, col2 desc, col3 desc;
What
I just completed designing a site for a dentist that had to be HIPAA
compliant. To see how I structured it take a look at
www.brianwilliamsdds.com.
Keith D. Holler
Owner/Senior Network Engineer
AZCAPPY Network Services
www.azcappy.com
623-931-0809
623-321-8177 Fax
-Original Message-
From:
We have a relatively small web site running 4.0.20 on a Dell 2850
running RedHat.
We rarely see any SQL statements visible when we run SHOW PROCESSLIST
and typically use 30 - 40 concurrent connections.
The Number of SQL Queries graph in MySQL Administrator usually is in the
0 to 10 range wit
What a great discussion thread!
Gary,
I currently use MySQL as part of a HIPAA compliant system for the
integration of web-based apps with Patient Care information.
HIPAA (Health Information Portability and Accountability Act) is a set of
standards set by the US Government to protect people's pr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
> Hi,
>
> I'm taking a database class and we are given open ended discussion questions
> each week. The question this week is:
>
> "Will MySQL take away market share from popular DBMSs? Will your comments
> change if you a
Hello.
If documentation isn't clear, you may want to report a bug at:
http://bugs.mysql.com
Jerry Bonner <[EMAIL PROTECTED]> wrote:
> I realize that.
>
> The documentation states that username and timestamp,
> by default, are logged to "(update log, binary update log, and s
Hello.
See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
"Nguyen, Phong" <[EMAIL PROTECTED]> wrote:
>
> All,
>
> In a few minutes ago, I can connect to mysql. Log out and can not login with
> error "Mysql error Number 2003 can't connect to Mysql server.."
>
>
Hello.
The common solution for similar issues which appeared on the
list not recently was modifying the query to use UNIONs. For
example:
select field1, field2
from tblMerge
where
MATCH(field1)
AGAINST('food' IN BOOLEAN MODE)
Or
MATCH(field1)
AGAINST('locomotive' IN BOOLEAN MO
Hello.
I've never heard that big values of max_allowed_packed had produced
problems. So usually putting it to big enough values shouldn't break
anything in most cases. Please, next time send a copy of your message
to the list, more experienced users can give a good advice.
>we are repl
Hi,
I'm taking a database class and we are given open ended discussion questions
each week. The question this week is:
"Will MySQL take away market share from popular DBMSs? Will your comments
change if you are told that MySQL is not HIPPAA compliant?"
I have been using MySQL for well over 3
Hi all.
I have a question I was wondering if someone might be able to help with:
I have a small table containing a full text index on a title and
description fields. Everything was going great and the full text index
was performing well against 25 items (So farm, but set to rise). IE:
mysql>
Thanks for the two incredibly fast responses, they were perfect -
problem solved.
Russell.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Russell Horn wrote:
I'm having difficulty writing a query as follows. I'm unsure if I need a
subquery, a union or if this isn't actually possible without using
temporary tables.
I have two tables for members.
Table 1 (members) Table 2 (payments)
+--++ +-+--
What is this all about? McAfee caught this problem. It was in \data as
ofiqa.dll I couldn't delete it until I stopped the MySQL service.
8/5/2005 8:03:39 AM Deleted NT AUTHORITY\SYSTEM mysqld-nt.exe
D:\mysql\data\ofiqa.exe W32/Sdbot.worm.gen.by (Virus)
--
MySQL General Mailing List
For list ar
Is this what you're after?
SELECT
COUNT(*) AS members,
SUM(IF(payment_type = 'creditcard', 1, 0)) AS pay_by_card
FROM
members
JOIN payments USING (memno)
GROUP BY group;
On 8/5/05, Russell Horn <[EMAIL PROTECTED]> wrote:
> I'm having difficulty writing a query as follows. I'm unsure
I'm having difficulty writing a query as follows. I'm unsure if I need a
subquery, a union or if this isn't actually possible without using
temporary tables.
I have two tables for members.
Table 1 (members) Table 2 (payments)
+--++ +-+--+
| memno
That's exactly what I'm looking for, thanks Eugene. :)
On Aug 5, 2005, at 12:46 AM, Eugene Kosov wrote:
Brian Dunning wrote:
I'm searching a table of people who own properties, and I want to
also include the total count of related properties, and the count
of related properties whose
Nguyen, Phong wrote:
All,
In a few minutes ago, I can connect to mysql. Log out and can not login with
error "Mysql error Number 2003 can't connect to Mysql server.."
Check this: http://dev.mysql.com/doc/mysql/en/access-denied.html
It is a good idea, for now, to check the error logs, there sh
All,
In a few minutes ago, I can connect to mysql. Log out and can not login with
error "Mysql error Number 2003 can't connect to Mysql server.."
Any idea, please help!
Thank you..Nguyen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
"Suryya Ghosh" <[EMAIL PROTECTED]> wrote on 08/05/2005 09:50:27
AM:
> Hi,
>
> We have a table containing more than 15 million rows of data, can
> anybody please help in this problem of fulltext search described below.
>
> The following query is giving a good result in terms of query time.
>
>
Sebastian wrote:
> is it ok to add index after the tables and data are already built, or is
> it better to create the index before data gets inserted?
Michael Stassen wrote:
> It's probably better to create the indexes up front (assuming you know in
> advance which ones will be needed), but I t
I realize that.
The documentation states that username and timestamp,
by default, are logged to "(update log, binary update log, and slow queries
log, whatever log has been activated)". But apparently it isn't.
I was hoping that there was a way to get that information in the binary
log, but
Hi,
We have a table containing more than 15 million rows of data, can anybody
please help in this problem of fulltext search described below.
The following query is giving a good result in terms of query time.
select field1, field2
from tblMerge
where
MATCH(field1)
AGAINST('food' IN BOOLEAN M
On Thu, 4 Aug 2005 23:36:01 -0700 (PDT)
David Blomstrom <[EMAIL PROTECTED]> wrote:
> I wondered if anyone on this list has had experience
> with Plone and could explain how their system compares
> to PHP/MySQL. I'll be working with animal kingdom data
> - child-parent relationships and recursive a
Hello.
I was unable to find similar bug in bugs database, but there were
several problems with datetime. Some of them were solved by choosing
different versions of software. Check if your problem exists on MySQL
4.1.13. Maybe ODBC tracing help you to localize the problem. If you
have a repro
Hello.
I think these lines from sql/mysqld.cc from 4.1.13 distribution shows
that --log-long-format doesn't affect the behavior of MySQL:
{"log-long-format", '0',
"Log some extra information to update log. Please note that this
option is deprecated; see --log-short-format option.",
0, 0,
Hello.
Are you replicating BLOB or TEXT fields? I think the maximum packet
size is correlated with the size of data which is stored in that fields.
Sid Lane <[EMAIL PROTECTED]> wrote:
> all,
>
> I just finshed hosing down a minor (that could have been FAR worse)
> fire where replicati
Hello.
I'm using MySQL 5.0.10 and perl-DBD-mysql-2.90.06-alt1 (from ALT Linux).
I didn't find such weird behavior. Can you send the code of your
program. Here is the example of mine which works fine:
#!/usr/bin/perl
#
use strict;
use DBI;
use User::pwent;
use POSIX;
my ($dbh,$sth,
Hello.
Right, I agree with you for MyISAM tables, however, in my opinion,
for InnoDB indexes should be created before populating the table
(the link below related to LOAD DATA INFILE statement, but I think,
the same applies for INSERT as well):
http://lists.mysql.com/mysql/181445
S
Hello.
> I have a query that is taking days to complete (not good). If I change
Really, not good. What does SHOW PROCESSLIST report about the thread of
this query?
David Sparks <[EMAIL PROTECTED]> wrote:
> I have a query that is taking days to complete (not good). If I change
Hello.
What do you think about this:
SELECT a.name,
COUNT(p.property_id) AS totalcount,
SUM( IF(p.status = 'Active' AND p.approval = 'Active',
1, 0)) AS CCOUNT
FROM accounts a, properties p
WHERE a.account_id =
Hello.
Are there any error messages and stack trace before 'Memory status'
line in the error log?
Arek H <[EMAIL PROTECTED]> wrote:
> Hi
>
> Im running a stock install of Slackware 10.1 with the default setup of
> mysql. Whats happening is when I hit the reload button severa
Hello.
I think you should use the SHOW statements:
http://dev.mysql.com/doc/mysql/en/show-create-table.html
http://dev.mysql.com/doc/mysql/en/show-index.html
"Nguyen, Phong" <[EMAIL PROTECTED]> wrote:
> Good morning All,
>
> What Mysql command show us CONSTRAINT_TYPE val
Hello.
I think - yes. There are no plans to implement ALTER TRIGGER
command currently. See:
http://bugs.mysql.com/bug.php?id=10994
Karam Chand <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I was reading the docs on Triggers at:
>
> http://dev.mysql.com/doc/mysql/en/using-triggers.
Hello.
About deleting the InnoDB log files see:
http://dev.mysql.com/doc/mysql/en/adding-and-removing.html
> Now what about this my.cnf file? As I recall, this file lives in the top
Program options could be passed in different ways. You can add your
specific options (for example In
"Nguyen, Phong" <[EMAIL PROTECTED]> wrote on 08/05/2005 08:26:58 AM:
> Good morning All,
>
> What Mysql command show us CONSTRAINT_TYPE value as UNIQUE, PRIMARY KEY,
or
> FOREIGN KEY of and schema?
>
> Thanks.Nguyen.
>
I believe you are looking for the SHOW CREATE TABLE comma
Good morning All,
What Mysql command show us CONSTRAINT_TYPE value as UNIQUE, PRIMARY KEY, or
FOREIGN KEY of and schema?
Thanks.Nguyen.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 8/4/05, Scott Gifford <[EMAIL PROTECTED]> wrote:
>
> Pat Adams <[EMAIL PROTECTED]> writes:
>
> > On Thu, 2005-08-04 at 14:44 -0500, 2wsxdr5 wrote:
> >> There are also several places that you can get a reasonably random
> >> number for the seed from your machine. The amount of free disk space,
The message was not delivered due to the following reason(s):
Your message was not delivered because the destination server was
not reachable within the allowed queue period. The amount of time
a message is queued before it is returned depends on local configura-
tion parameters.
Most likely ther
Nuno Pereira wrote:
You don't have any MySQL process in this case. Try to
replicate the case when you got the defunct processes, and post the
output like this, in tree, so we can see how lost hist child.
Ok managed to capture it.
0 1 0 0 ? -1 S0 0:04 in
Arek H wrote:
Nuno Pereira wrote:
Post here the result of a ps ajxf, but it seems to me that you didn't
started properly mysql. You should start MySQL with mysqld_safe, not
with mysqld.
Here it is
PPID PID PGID SID TTY TPGID STAT UID TIME COMMAND
0 1 0 0 ?
Nuno Pereira wrote:
Post here the result of a ps ajxf, but it seems to me that you didn't
started properly mysql. You should start MySQL with mysqld_safe, not
with mysqld.
Here it is
PPID PID PGID SID TTY TPGID STAT UID TIME COMMAND
0 1 0 0 ? -1 S
Arek H wrote:
Hi
Im running a stock install of Slackware 10.1 with the default setup of
mysql. Whats happening is when I hit the reload button several times on
a page that uses php and accesses mysql I get defunct and
zombies start showing when viewing top. I also get this when I run a web
Hi,
> In the MySQL Docs at
> http://dev.mysql.com/doc/mysql/en/drop-view.html, it
> says:
>
> "RESTRICT and CASCADE, if given, are parsed and
> ignored."
>
> I am not sure if I understood this?
Easy, you can specify "restrict" or "cascade", but MySQL
does absolutely nothing with it.
With regards
In article <[EMAIL PROTECTED]>,
Scott Hamm <[EMAIL PROTECTED]> writes:
> Ok. Now that I got NorthWind into my MySQL 5.0.9 database and also am
> running M$ SQL database server at where I work, this might be a good
> opportunity for me to learn how to mirgate from M$ SQL database to MySQL
> usin
Afivi Andri S wrote:
need help...
what is the different between
mysql_query and mysql_real_query, is it about speed or stable?
header are
int mysql_query(MYSQL *mysql, const char *query)
int mysql_real_query(MYSQL *mysql, const char *query, unsigned long length)
and mysql_query is in fact :
Hello,
In the MySQL Docs at
http://dev.mysql.com/doc/mysql/en/drop-view.html, it
says:
"RESTRICT and CASCADE, if given, are parsed and
ignored."
I am not sure if I understood this?
Regards,
karam
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has
Brian Dunning wrote:
I'm searching a table of people who own properties, and I want to also
include the total count of related properties, and the count of related
properties whose (status is 'Active' and approval is 'Active'). I've got:
select accounts.name, count(properties.property_id) a
need help...
what is the different between
mysql_query and mysql_real_query, is it about speed or stable?
and how to use mysql_use_result ?
OK, I think that worked. I didn't get any error
messages at least. :)
Thanks.
--- Eugene Kosov <[EMAIL PROTECTED]> wrote:
> David Blomstrom wrote:
> > What's the easiest way to create a username and
> > password for a new database? It's been so long
> since I
> > created my original database, I
Thanks Dwi for the tip, but unfortunately this solution is possible only in
applications which connect only to MySQL and I am already using it in those
applications but now I need to connect to MySQL or to MS Access (or to other DB
engine) with one query using only different connection string (a
82 matches
Mail list logo
