Hello,
I was reading the docs on Triggers at:
http://dev.mysql.com/doc/mysql/en/using-triggers.html
Looks like there is no support for Alter Trigger. So
if I want to change a trigger, I have to first drop
the existing one and recreate another?
Am I correct?
Karam
I've been experimenting with databases, both Drupal
and Plone. Plone is a can of worms, but it's
intriguing, partly because it's so different. It
sounds like they replace LAMP with something
completely different, though it's a complete mystery
to me at present.
I wondered if anyone on this list
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
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 forgot
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 ?
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)
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
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
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
using
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,
Martijn
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 mysqld defunct and
zombies start showing when viewing top. I also get this when I run
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:
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:
You don't have any Defunct 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
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
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,
unless that
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]
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 command. If I
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
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.html
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 value as
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 several
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.
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.
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
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
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 replication
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, 0,
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
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
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
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
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
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.
select
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:
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
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
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
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
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
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)
+--++
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]
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
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
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
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
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..
Any idea,
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 slow
-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 are told
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
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
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-
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;
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
-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_
[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
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
[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]
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
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
[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
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
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
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 params
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
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:
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 UserName
[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
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,
-
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
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), but still
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
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:
UPDATE
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
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
[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 syntax
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
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
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 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
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
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
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 it
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]
84 matches
Mail list logo
