### 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 (f
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` int(10
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 `ip_name_tbl
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.
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 to
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]
> mysq
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 applic
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 co
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 to
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 `conn`
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 a
Markus,
the problem is that name_id is UNSIGNED in the first table and SIGNED in the
second.
As stated in the manual, integer columns must have the same signedness and
size in a foreign key constraint.
Regards,
Heikki
Innobase Oy
- Original Message -
From: "Markus Lervik" <[EMAIL PROT
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 [ma
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> chan
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 connection
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 to
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 an
* harm de laat
> Subject: when will mysql 4.1 be released?
I don't know. Not in the nearest future, they have just begun the coding.
> 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 suppor
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
http://fifaworldcup.yaho
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 ho
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
First, you should ensure that your GRANT permissions get set correctly for each system.
Your connection handler will need to look after which database to connect to depending
on the type of query you ask for. So whatever you are using, java, php C, that is what
will have to organize such
> --
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.
>
>I
Hi Rob,
thanks for your reply.
> -Original Message-
> From: Rob [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 10, 2002 2:57 PM
> To: Peter Romianowski; [EMAIL PROTECTED]
> Subject: Re: "dynamic table width"
>
>
> As usual, there are several different approaches, each with different
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 I
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
linux<>w2k nor l
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]]
Se
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
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 ope
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 retr
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
integ
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
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 questio
> 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:
http://www.mysql.com/products/mysql-4.0/index.ht
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_NAM
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 quer
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 PRO
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 not "tim
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: [E
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.
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
new_raw_log(G
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
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 us
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
t line 1
But when I type in a host name it works fine
G
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
> 'pa
> E.g. the non-equivalence operator is the same. MySQL will use indexes
> for "foo>0", but not "foo<>0", 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
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 wi
On 10 Jun 2002, at 17:10, Elsad YUSIFLI wrote:
> WHERE (a.HOST_NAME regexp rtrim(b.ip)+'%')
What are you trying to accomplish there? '%' is not a special
character in regular expressions. Are you mixing up REGEXP and LIKE?
Even if that's what it is, I'd expect a column called ip to be a
com
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
use
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 (id,id_test_fk,
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
capabiliti
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
That is pretty ugly, but if I can't find anything else, then I may just
have to try this out. Thanks for the help!
--shak
Michael Bacarella wrote:
>On Thu, Jun 06, 2002 at 02:49:05PM -0700, Shakeel Sorathia wrote:
>
>
>>we start up mysql. Mysql binds to the port, then it takes about 15
>>
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)
http://lists
[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
-
But my program not use only mysql (able to oracle, paradox and MS Sql
Server), However, do i need license?
- Original Message -
From: Jay Blanchard <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 4:10 PM
Subject: RE: license...
> [snip]
> I'm developing a progra
[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 http://www.mysql.com/suppo
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 the
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 expe
[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 are 25,000 records
in 'head', and 50,000 records in 'line'). However,
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 second
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 :
/usr/loc
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 fiel
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, e
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/ (t
can't insert into questions( ) select from questions .
the error is : not unique table or alias .
tried with insert into ... select a.field1 , a.filed2 from questions as a .
not working ;)
- Original Message -
From: "Brent Baisley" <[EMAIL PROTECTED]>
To: "cristian ditoiu" <[EMAIL PROTEC
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, 2
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 techni
YES! As stated before JUST THIS VERY DAY. If you are selling a program and
DISTRIBUTING MYSQL then you have to pay.
1: Why would you consider NOT paying for it if you are making money off of
it? (It's a killer piece of work!)
2: Please check the archives or better yet, the web page. Everything
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
Hi all,
I am trying to set max_connections to 200 on my server. Currently it is 100.
My mysql version 3.22.32. My problem is I am not able to find my.cnf. And if
I set the variable on command line like this:
--set-variable = max_connections=200;
Then it does not do anything.
What am I doing wr
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 a
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 people
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 to
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 by
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
Wow,
for your first shot, you've got a very normalized database. GOOD JOB!
The only thing wrong is your payments table.
It needs to be more like:
payment
-
payment_id
=
class_id
user_id
date
amount
-
-
(The primary key is the combination of class_id and userID)
Then you cou
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
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 teach_i
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.
Hi all,
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 problem when posting at one of the php.net mailing lists,
and was solved after I announced it. Does it
1 - 100 of 111 matches
Mail list logo
