### CHANGES ###
--- version 16.2 ---
- pages tabs now reflect, by their background color, the crossed
thresholds of highest importance in a page
- pages tabs now feature a widget tip (balloon) containing up to 3
summaries of the crossed thresholds in a page
- implemented colors sequencing
Hello list!
I'm having a bit of trouble getting foreign key constraints to work.
I'm running MySQL 2.23.50-Max.
Here's what I got:
mysql SHOW CREATE TABLE conn\G
*** 1. row ***
Table: conn
Create Table: CREATE TABLE `conn` (
`id`
First of all the referenced key must be on PRIMARY KEY.
But I've seen in your table definition a quite strange thing. You have a
UNIQUE and an ORDINARY key definition on the same field.
Here:
...
UNIQUE KEY `name_id` (`name_id`), - THIS IS THE FIRST DEFINITION
UNIQUE KEY `comp_name`
Heya!
You need an INDEX.
Try doing this first :
alter table ip_name_tbl add INDEX(name_id);
And add then your constraint.
EG
mysql SHOW CREATE TABLE ip_name_tbl\G
*** 1. row ***
Table: ip_name_tbl
Create Table: CREATE TABLE
On Monday 10 Jun 2002 11:17 am, you wrote:
First of all the referenced key must be on PRIMARY KEY.
...which means my 'id' -field can't be a primary key, right?
But I've seen in your table definition a quite strange thing. You have a
UNIQUE and an ORDINARY key definition on the same field.
On Monday 10 Jun 2002 11:44 am, Markus Lervik wrote:
mysql show create table ip_name_tbl\G
*** 1. row ***
Table: ip_name_tbl
Create Table: CREATE TABLE `ip_name_tbl` (
[snip]
`name_id` int(11) NOT NULL default '0',
[snip]
mysql show
Everyone,
Im just curious if possible, I had two MySQL server...one is the replica of
the master server. And to make the database in safe and intact even if
there's a hang-up. I use auto back-up using the MySQL dump program. But if
master server is downed. All I do is redirect my front-end
I don't quite understand the distinction you are drawing between an image
and an image_attrib. To what real-world concept does image_attrib
correspond?
I'd suggest that the entities in your system are:
Image: with fields such as title and [film type stuff]
Comment: with a field for the comment
Hi all,
I'm implementing a bridge between MySQL and Lotus Domino.
In our application we realy need stored procedures (triggers).
I saw that MySQL does not yet support stored procedures. (This will be
one of the features of version 4.1). Is it worth to wait for version 4.1
or should we switch
What I think, is that your syntax for creating the primary key is slightly
incorrect. I'm not sure if this is also true vor MySQL but I got teached at
school that a foreign key can only point to the primary key of a table.
Perhaps you can try to do the following:
Create Table: CREATE TABLE
Hello list,
I am running mysql-3.23.49 on Linux 2.4.18 for production purpose.
Now I want to define a proper max_connections value in mysql. The
document said,
The maximum number of connects MySQL is depending on how good the thread library is
on a
given platform. Linux or Solaris should be
Can you help!!
I have two databases on one MySql sever and I would like to transfer
certain information from one databases to another. I want to transfer,
record by record, from a particular table, after examining the record. How
can I open the two databases at the same time?
The only way I
tlack,
Saturday, June 08, 2002, 2:19:39 AM, you wrote:
Description:
t Change datadir in /etc/my.cnf or elsewhere. Start server (i.e.,
t /usr/local/share/mysql/mysql.server start) and then try to stop it
t (/usr/local/share/mysql/mysql.server stop)
All worked fine for me.
How-To-Repeat:
t #
Weaver,
Friday, June 07, 2002, 11:28:41 PM, you wrote:
W I believe the autoextend functionality won't be available until 4.0.2.
autoextend is only supported since 3.23.50
Anyway it's not available in 4.0.1
W --Walt Weaver
W Bozeman, Montana
W -Original Message-
W From: vlady
asong,
Sunday, June 09, 2002, 5:16:00 PM, you wrote:
a I change the max_connections to 200, and I am not sure it works, when I
a use mysqladmin to check the variables, I find the value is still displayed
a as 100, but trough checking the log file, I am sure the max_connections have
a changed
System,
Sunday, June 09, 2002, 10:24:27 PM, you wrote:
SAakaTRotP Since 020606 mysql has been crashing and then I have to manually
SAakaTRotP restart.
SAakaTRotP The error log is below:
SAakaTRotP 020607 00:46:27 mysqld started
SAakaTRotP /usr/contrib/libexec/mysqld: ready for connections
Hi all,
I'm implementing a bridge between MySQL and Lotus Domino.
In our application we realy need stored procedures (triggers).
I saw that MySQL does not yet support stored procedures. (This will be
one of the features of version 4.1). Is it worth to wait for version 4.1
or should we switch
Hi,
I got a table with standard userdata (email, address). I want
to be able to provide additional fields (like age, gender etc).
Generally I have about 8 standard fields and up to 30 optional
fields which may vary. Say something like this:
Customer A wants its users to provide email, address
What are the main api's available for Mysql?
And what is the meaning of API?
And can one use VB with mysql?
IS API are used for making connection?
plz reply
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
First of all, let me apologize for repeaditly sending my e-mail message
to the list.
Roger Baklund wrote:
I don't know. Not in the nearest future, they have just begun the coding.
Oka
I don't get it... does it work perfectly with mysql, or do you realy need
stored procedures? And how come
As usual, there are several different approaches, each with different
advantages and disadvantages.
The simplest approach is just to put all the optional fields in the main
table, and each user can decide how many of them they can be bothered to
fill in. The disadvantages here are that there is
It looks to me like 'a' is '127-30-127-1'
Notice the dashes.
I don't believe you are splitting the IP address into 4 separate numbers.
Chris Knipe wrote:
Hi again,
Not to long ago, I had a query regarding the best way to store IP addresses
in a DB, and make sure that they are unique.
It was
Hello,
I think that my problem boils down to the unimplemented getWarnings() method
in the mm. JDBC driver. If it was implemented, I could detect if the data
was e.g. truncated. Can anybody help me find an implementation for this
method?
Thank you again,
Charlie
Hi.
:I'd like to find out
Description:
i got wrong values from a select statement using a
case value when .. then .. else .. end instruction
i made a select statement from this two tables
corriere
| Field | Type| Null | Key | Default | Extra |
Hi! I am new to mysql and this is my problem.
The daemon runs well but I can start it only with --skip-grant-tables
option, otherwise nothing will work.
I set the password for the root user but when I exit the Mysql monitor and
try to get in again, no password is request.
When I set the password
Errata:
We could use MySQL and imlement stored procedures outselves. (Using some
scriptlanguages like perl or python).
A stored procedure is by definition a collection of SQL statement
stored and executed in the RDBMS, not an external script, etc.
//Anders - sql, query
hello,
can someone please explain why it is not possible to do the
replication between e.g. linux and bsd systems ?
why wouldnt it be possible to exchange data in system-independent
fashion ?
i have set up replication between mysql running on win2k, but am
unable to do that with
linuxw2k nor
I am replicating to NT Server system from Red Hat Linux
was not aware of any issues to win2k from linux with replication
Is there something I am not aware of?
-Original Message-
From: Bartomiej Dolata [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 9:44 AM
To: Mysql@Lists.
What happend when you ran scripts/mysql_install_db ?
Also when you run the databases with --skip-grant-tables as soon as you
grant a user acess and flush privileges it will then use the grant tables (I
think)..
Simon
-Original Message-
From: Simona D'Ambrosio [mailto:[EMAIL PROTECTED]]
Mehdi,
Saturday, June 08, 2002, 8:33:29 PM, you wrote:
MZ Egor,
MZ Could you let me know when 4.1 will be release ?
MZ I'm building a website and want to decide whether I can use mySQL
MZ instead of SQL Server or not?
MZ The most important factor is support of Unicode.
I don't know exactly the
Fred,
Monday, June 10, 2002, 2:22:25 PM, you wrote:
FK I have two databases on one MySql sever and I would like to transfer
FK certain information from one databases to another. I want to transfer,
FK record by record, from a particular table, after examining the record. How
FK can I open
Ritu,
Friday, June 07, 2002, 8:11:34 AM, you wrote:
RS Starting mysqld with --flush, flushes tables to database or disk
RS log??
If you start mysqld with --flush option all your changes will be
written on the disk immediately. So, --flush will make less probable
that data will lost on crashes,
Simona,
Monday, June 10, 2002, 4:31:33 PM, you wrote:
SDA Hi! I am new to mysql and this is my problem.
SDA The daemon runs well but I can start it only with --skip-grant-tables
SDA option, otherwise nothing will work.
SDA I set the password for the root user but when I exit the Mysql monitor
hello,
I am replicating to NT Server system from Red Hat Linux
was not aware of any issues to win2k from linux with replication
Is there something I am not aware of?
i dont know, but i am having major problems with it.
i keep getting Slave: Failed reading log event, reconnecting to retry,
i have a table and 51000 records in it.
it has got an index on HOST_NAME field.
next query lasts 45 seconds to execute...
is it normal ? server is PIII 500 double cpu
SELECT b.ip as ip, b.country , b.hostname , a.HOST_NAME as host, COUNT(a.HOST_NAME)
as number
FROM new_raw_log as a, dns as b
Hello,
I am using the now() function to insert the current timestamp in a mysql
table.
My problem is that the server is using EST while I would like the time to
reflect PST.
Can this be done?
Thanks.
--Kevin
[EMAIL PROTECTED]
I studied the MySQL and InnoDB manual, but I did not find anything about
the internal usage of foreign keys.
I mean that I would like to know if foreign keys are used for query
optimizations or functions like that.
Because I think foreign keys should be used not only for keeping the data
Thanks for your reply.
I am actually using PHP and I tried what you suggested.
$link1 = mysql_connect(server1.com, www, pass) or die(could ...);
$link2 = mysql_connect(server1.com, www, pass) or die(could ...);
there is no error but it is not working.
Please not that I am using the same
Hi All,
I have a RH-7.2 server running mysql 3.23.41-1. I need to rotate
the mysqld.log based on some size criteria. I have a config file
as follows :
mysqlrotparams.conf
***
/var/log/mysqld.log {
rotate 5
Are you positive that you are running compatible versions of MySql on both
platforms?
- Original Message -
From: Terry [EMAIL PROTECTED]
To: Luc Foisy [EMAIL PROTECTED]; MYSQL-List (E-mail)
[EMAIL PROTECTED]
Sent: Monday, June 10, 2002 9:59 AM
Subject: RE: replication question
|
Subject: Re: replication question
Are you positive that you are running compatible versions
of MySql on both
platforms?
linux: mysql rebuild from source rpm:
/usr/sbin/mysqld, Version: 3.23.49-log, started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
openbsd: mysql build from
Kiss Dániel wrote:
I studied the MySQL and InnoDB manual, but I did not find anything
about the internal usage of foreign keys.
MySQL does not support foreign keys at the moment. This will be
implemented in version 4.1.
For more info see:
Check that your fields are indexed.
This usually fixes it.
George
- Original Message -
From: Elsad YUSIFLI [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 3:10 PM
Subject: 45 seconds
i have a table and 51000 records in it.
it has got an index on HOST_NAME field.
If you create in index on your FK then it will be used to optimize the
query.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: Kiss Dániel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 9:19 AM
Subject: Foreign keys in query
Both of the connections shown below are for the same database server.
If both dbs are on the same server you only need one connection, but
then you need to use mysql_select_db($database_name,$link1) for each
database.
Andrew Hazen
-Original Message-
From: Fred Kamwaza [mailto:[EMAIL
You need to get logrotate to flush-logs otherwise mysql will still write to
the old file.
eg add after the create 0644 mysql mysql line:
postrotate
if test -n `ps acx | grep mysql`;then
/path/to/mysqladmin -u logflusher -ppassword flush-logs
fi
endscript
Assuming a mysql users called
InnoDB supports foreign keys. And, an index must be created on the foreign
key; this would help from an optimization point of view.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: harm de laat [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 8:43 AM
To: Kiss Dániel
Cc:
Now it works!!!
My problem was that I didn't know that if I set up passwords for users I had
to tell it to the web pages where I connect to the database (postgres
doesn't work like that).
I know this is stupid, but I began my message with I am new to mysql :-)
Anyway thank you for your replies.
- Original Message -
From: Charlie Thunderberg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 8:23 AM
Subject: RE: No Warnings after changed data
Hello,
I think that my problem boils down to the unimplemented getWarnings()
method
in the mm. JDBC driver. If it
Hello,
The reason that it takes so long is because you are using regexp on a
function to join the table. That means that MySQL can't use indexes for
that column. If you run an EXPLAIN on the query you will see that is
true.
To speed up the query some you could add an index on
Kiss,
Monday, June 10, 2002, 5:19:17 PM, you wrote:
KD I studied the MySQL and InnoDB manual, but I did not find anything about
KD the internal usage of foreign keys.
KD I mean that I would like to know if foreign keys are used for query
KD optimizations or functions like that.
KD Because I
Kevin,
Monday, June 10, 2002, 5:20:00 PM, you wrote:
K I am using the now() function to insert the current timestamp in a mysql
K table.
K My problem is that the server is using EST while I would like the time to
K reflect PST.
K Can this be done?
K Thanks.
It depends on what OS do you use. If
In the last episode (Jun 10), Kaan Oglakci said:
Hi,
For some reason when I try to set up grants for a database by typing this
GRANT ALL ON newstesting.* to clients@% IDENTIFIED BY 'pass';
I get this error
ERROR 1064: You have an error in your SQL syntax near '% IDENTIFIED BY
'pass'' a
E.g. the non-equivalence operator is the same. MySQL will use indexes
for foo0, but not foo0, which ask for the same result (presumed
foo is an unsigned column).
Perhaps I was a bit unclear... Using foo 0 does *NOT* use an index.
Using foo 0 AND foo somevalue *DOES* use an index.
As
I have multiple tables on a 166MMX with 64MB ram, all containing more than
250,000 records each Mine takes less than 5 seconds
I think there's something wrong at your side :-)
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
Try using LIKE instead of regexp and create index on HOST_NAME if not
present.
Nilesh
-Original Message-
From: Chris Knipe [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 1:24 PM
To: Elsad YUSIFLI; [EMAIL PROTECTED]
Subject: Re: 45 seconds
I have multiple tables on a 166MMX
Hi,
I have just installed and run my mysql server as the root user. I have
entered
the MYSQL minitor. WHen I typed 'use mysql', I got the message--
Error 1044: Access denied fro user: 'root@localhost' to database
mysql'.
Same error message appeared when I tried to grant all on mysql to root
user,
hello .
i use php 4.12 + mysql 3.23.49 on linux .
i've developed a online testing(quiz) -aplication that now is expected to
behave somehow different from what i've had in mind at the begining . More
exactly :
i have 3 tables (MyIsam):
1. tests (id,name,desc)
2. questions
I guess it's a question of semantics, but I would consider a stored
procedure, in general, any series of commands to be executed 'in' the
database engine. Postgres, for instance, allows stored procedures to be
written in a number of different languages. Commercial engines have similar
Hi All,
I wish to download MyCC from mysql official site and i try allmost all the
mirroring site.The message is the next:
You are downloading: mycc-0.8.3-src.tar.gz
There was an error with the mirror site you selected. Please choose another
mirror.
My question is:
from where i can download
I'm developing a program, that is not free software and i'm using mysql with
myodbc. The question is if i need a license or not...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
[snip]
I'm developing a program, that is not free software and i'm using mysql with
myodbc. The question is if i need a license or not...
[/snip]
According to this http://www.mysql.com/support/arrangements.html
yes..
HTH!
Jay
[snip]
But my program not use only mysql (able to oracle, paradox and MS Sql
Server), However, do i need license?
I'm developing a program, that is not free software and i'm using mysql
with
myodbc. The question is if i need a license or not...
According to this
Hi List,
I sure do appreciate this list.
I'm stumped on the following query:
SELECT
head.po
FROM
head
LEFT JOIN line ON (head.sn=line.snHead)
WHERE
head.po 1
AND line.dateETA='2002-06-10'
LIMIT 50
As is, this query is very fast (0.01 seconds when
Why not just use something like:
insert into questions (field1,field2,...) select...
You don't need to create temp tables for your data and all the other
complicated stuff.
hello .
i use php 4.12 + mysql 3.23.49 on linux .
i've developed a online testing(quiz) -aplication that now is
We are running mysql on a red hat box.
We replicate a single database twice, once on another red hat box(thank whatever is
holy), once on a winnt box.
The winnt box cares not for case sensitivity, so it created all our table names in
lower case ( our standard is to use CAPS for tablenames )
(
Sorry for the long reply:
At 02:57 PM 6/10/2002 -0500, you wrote:
[snip]
SELECT
head.po
FROM
head
LEFT JOIN line ON (head.sn=line.snHead)
WHERE
head.po 1
AND line.dateETA='2002-06-10'
LIMIT 50
As is, this query is very fast (0.01 seconds when there
Hi I am pretty new to linux and I was trying to setup and use mysql, I
followed the directions you provided about compiling it and installing it,
but when I try to start the server the mysql daemon fail right away : saying
mysqld ended. I looked at the error log and this is what it says :
Hi,
I'd like to do the following in mysql:
I have a table with field1 and field2. Both fields are not unique.
Field2 can have the value of 0 or 1.
I'd like to join the results of these two queries:
query 1: select field1, count(field2) as total from table1 group by field1
query 2: select
Mysql does not own the database and its tables;
chown -R mysql /usr/local/mysql/var
( or whatever the database location is. )
Kariuki, JohnX K wrote:
Hi I am pretty new to linux and I was trying to setup and use mysql, I
followed the directions you provided about compiling it and installing
What is the best way to connect with Delphi 5/6 to Mysql?
Johan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
ASTA at www.astatech.com
M:)
What is the best way to connect with Delphi 5/6 to Mysql?
Johan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
You may find the Access conversion easier to do using MysqlFront,
downloadable at www.mysqlfront.de.
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 8:08 AM
Subject: Re: FW: RE: support UTF-8
Mehdi,
Saturday, June 08, 2002,
Subject: MySQl price
From: Peder Hanghøj [EMAIL PROTECTED]
===
I will make a delphi-program that uses MySQL.
I want to sell the program, do I have to pay each time I sell a program?
Do I have to pay for MySQL?
Thanks Peder
Yes. MySQL attempts to get the current time zone from the OS, but this can
be overridden by setting the TZ variable. (The manual suggests doing this
in
the safe_mysqld script; there's already code in there for setting it from
a
command line argument.)
Valid settings of TZ are technically
MySQL AB staff:
1) The recent discussion on the subject Not using indexes??? brought to
light an opportunity for interpreting the documentation in contradictory
ways. The page http://www.mysql.com/doc/M/y/MySQL_indexes.html does not
mention the IS NOT NULL comparison operator, nor does it
what do you mean it doesn't do anything?
you should be able to set it on the command line as:
--set-variable=max_connections=200
or you could edit the my.cnf file that mysql is using when it
starts-up. if you can't find the my.cnf, then you should create one. here
is a link to the manpage
Does MySQL offer anything to take the place of Oracle's roles?
I'm especially interested in the ability, when adding a new table (or a new
view, in the future) to the database, to be able to grant the desired
access to everyone who ought to have access, without having to enumerate
those
Hi,
I got a table named patient_treatment_history
Below is some of the records inside the table.
patient_id,treatment_date,charges
1014,2002-01-28,20
1001,2002-02-02,100
1026,2002-04-08,74
1001,2002-04-15,85
1014,2002-05-05,50
1030,2002-05-16,125
1030,2002-06-18,180
1001,2002-06-25,125
I try
do a
select patient_id,treatment_date from patient_treatment_history order by
treatment_date desc limit 1;
I am not sure but max(treatmen_date) might work too as such:
select patient_id, max(treatment_date) from patient_treatment_history group
by treatment_date;
In your original query the group
Hi all. This is my first post here, so please be patient with me.
I dont know if theres a program already made that does what I need, so
I dont have to reinvent the wheel. Im using PHP MySQL to make most
of the web sites and web-based Corporate Intranets programs. What I
need now, is to
Hmmm...
If your just requiring two tier client server there are several.
This one is open source and free.
http://sourceforge.net/projects/zeoslib
- Original Message -
From: Proliant Business Solutions [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 2:07 PM
Looks okay to me except table teach_classes should have a
unique id for each record.
teach_clases (taught_id, class_id, teach_id)
Over the long term, the same class probably will be taught more than
once and the same teacher probably will teach more than one class
so neither class_id nor
In the last episode (Jun 10), Erv Young said:
MySQL AB staff:
And the thousands and thousands of regular people reading this list :)
1) The recent discussion on the subject Not using indexes???
brought to light an opportunity for interpreting the documentation in
contradictory ways. The
Well... thanks Cal Day. Your thoughts are brillant.
It makes me very proud that more experienced DB designers think I'm
doing great.
About the normalization rules, I have them inside the PHP and MySQL Web
Development book, written by Luke Welling and Laura Thomson, but since
my native language
Each time I post to the MySQL list I get two messages as follows.
- Original Message -
From: Mailer-Daemon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 9:10 PM
Subject: NDN: Re: Here's something
Sorry. Your message could not be delivered to:
mailing list
G'day César
I have a problem when posting. The thing is that every time I post to
the mailing list, I get an error saying that the message could not be
delivered but it does indeed.
It's getting delivered to the list OK but one of the subscribers to the list
is rejecting it. I've seen
In the last episode (Jun 10), Dan Nelson said:
In the last episode (Jun 11), César L. Aracena said:
I have a problem when posting. The thing is that every time I post to
the mailing list, I get an error saying that the message could not be
delivered but it does indeed.
I had the same
Hi,
I tried to flush the logs but still the rotation doesn't happen.
What else could be the problem ??
I get the same message again
My config file read like this
/var/log/mysqld.log {
rotate 5
size=100k
create
I'm writing some routines which generate SQL queries, and I'm trying to
keep things generic. As such, I have a routine to SQL Escape some text,
such that it can be used in a query without breaking anything. This
routine predominantly consisted of preceeding all single quotes (') with
a
90 matches
Mail list logo