From the MySQL documentation:
* A PRIMARY KEY is a unique KEY where all key columns must be defined
as NOT NULL.
KEY is a synonym for INDEX. So, specifying PRIMARY KEY implies UNIQUE and
INDEX.. You don't have to specify them yourself.
At 01:11 am 4/11/2004, you wrote:
I learned that there
Hi there,
I just installed the newest mysql 4.x server on a suse9.0 system with
apache 1.x and php4.x
The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application.
Now I am trying to configure the server for huge load. To stress test
it, I installed the
Microsoft stress test tool
As I discovered recently, thanks to another user on this list, there is at
least one situation where you WILL need to also create a KEY index on a
PRIMARY KEY column -
If you have a composite primary key such as (col1, col2) and you wish to
place a foreign key on col2, you will ALSO have to add a
Hi there,
I just installed the newest mysql 4.x server on a suse9.0 system with
apache 1.x and php4.x
The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application.
Now I am trying to configure the server for huge load. To stress test
it, I installed the
Microsoft stress test tool
Hi there,
I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and
php4.x
The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application.
Now I am trying to configure the server for huge load. To stress test it, I installed
the
Microsoft stress test tool
Yep. Theres no reason at all why this sort of thing won't work for MSSQL
too. Use SQL Enterprise Manager to generate a create script for all objects
in the database, and also tell it to script referential integrity (FKs,
etc).
Then add anything MySQL specific, such as Type=InnoDB (which you will
Hmm.
SELECT o.*
FROM orders o
INNER JOIN orderitems oi ON o.orderid = oi.orderid
INNER JOIN products p ON p.productid = oi.productid
AND p.productparentid 2
WHERE o.orderstatus =2
Not sure why you are checking for a NULL ordered in orderitems? That would
suggest you get back only items
Received: from 213.39.151.4 by freemailng1402.web.de with HTTP;
Sun, 11 Apr 2004 12:47:20 +0200
Date: Sun, 11 Apr 2004 12:47:20 +0200
Message-Id: [EMAIL PROTECTED]
--- END HEADERS ---
Hi there,
I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and
php4.x
David Carlos Brunstein [EMAIL PROTECTED] wrote:
Hi Egor.
Thanks for your answer. I'm relatively new to MySQL.
Isn't any way -like an environment variable or configuration file
setting or something like that- to change the date format at the MySQL
side, not at client side ?
No. You can
Hi folks.
I've just submitted the following as a 'bug' via the MySQL website, and was
wondering if anyone out there had experienced the same problem?
It only seems to cause a crash when a nested IF is put into a stored
procedure, so the work-around is obvious - don't nest 'em!
As posted to
Thanks Matt. But, what I am attempting to do with (oi.orderId IS
NULL) is to eliminate the orders that have at least one order item
with products of product parents not equal to 2. What you show finds
all orders that have orderitems that have a product parent greater
than 2, however, if that
Dear Users
Can anyone in your own words clarify the difference between open source
and free software.
Many Thanks
Saurabh Data
___
Saurabh Data
School of Computing
University of Leeds
Leeds LS2 9JT
U.K.
one who seeketh , will
On Sunday 11 April 2004 10:58 am, Saurabh Data wrote:
Dear Users
Can anyone in your own words clarify the difference between open source
and free software.
Many Thanks
Saurabh Data
This is off topic for this list, but I'll provide a quick answer.
Free software is software that's free to
Can anyone in your own words clarify the difference between open source
and free software.
Free Software:
You can make changes in the sourcecode for your own and you can redistribute
it again.
Open Source:
The sourcecode is only open...
Cheers
--
MySQL General Mailing List
For list
Cities (CityID, Name)
People (PersonID, Name)
Travel_Exp (ExpID, Date, PersonID, Per_Diem)
Travel_Exp_Cities (CityID, ExpID)
Based on the descriptions I'd tend to go with a normalized table set
of this nature:
Cities (CityID, Name)
People (PersonID, Name)
Travel_Exp (ExpID, Date, PersonID,
Can anyone in your own words clarify the difference between open source
and free software.
Interesting question, though you missed one other label 'public domain'.
These are all interesting elements of who controls the source and to what
extent.
MySQL as I understand it, allows the
Dear Peter
As you said that access to the source code for a free software may or may
not be give.
Looking at the FSF website and definition of free software, freedom 1 states
that access to the source code is given to study how the program works
So there is a small contradiction here . Please
Hi there,
I am trying to compile mysql 4.x with intel compiler for maximum performance. On my
research I have found that following line will squese more performance out of mysql:
CFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict CC=icc CXX=icc CXXFLAGS=-O3 -unroll2
-ip -mp -no-gcc -restrict
Walter Andreas wrote:
CFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict CC=icc CXX=icc CXXFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict ./configure --prefix=/usr/local/mysql--with-mysqld-user=mysqladm --without-debug --with-client-ldflags=-all-static--with-mysqld-ldflags=-all-static
Hi There:
I have a query where I get an average of weekly miles.
For example:
Average Weekly Miles:
3.4285714285714
How would I get this number into a more read format? Such as 3.42. I
have tried the truncate but I can't seem to get it to work. Does any
one have any suggestions?
SELECT
On Sun, 11 Apr 2004, Saurabh Data wrote:
Can anyone in your own words clarify the difference between open source
and free software.
Don't take our words for it, get it from the Gnu's mouth:
http://www.gnu.org/philosophy/free-software-for-freedom.html
-sam
--
MySQL General Mailing List
I think your looking for the ROUND(N,D) function, IE:
select round('3.4285714285714',2) as miles;
3.43 miles
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
that worked - Thanks a bunch!
CH
__
Craig Hoffman - eClimb Media
v: (847) 644 - 8914
f: (847) 866 - 1946
e: [EMAIL PROTECTED]
w: www.eclimb.net
_
On Apr 11, 2004, at 3:14 PM, Mike Blezien wrote:
I think your looking for the
I am trying to install MySql on MAC OS X. After the pkg is installed I am
not able to start the MySql server due to the Socket error.
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Now, when I check the /tmp folder I see that there is no file by that name
Hello all:
I understand that MySQL Replication can be configured
to replicate selected tables in a Database. Is there
anyway to further constrain the replicate, say based
on a query of these tables etc..?
Thank you
Gowtham.
__
Do you Yahoo!?
Yahoo! Tax Center -
MySQLers:
When I started porting an app from MSSQL to MySQL, I
got a flurry of error messages complaining of Illegal
mix of collations for operation ' IN '.
I want to set all encodings to utf8 and leave them
there.
I finally managed (despite help from
winmysqladmin.exe and the Services Control
I am trying to optimize a query using both BETWEEN and ORDER BY but
after months of reading and research I still can not get the hang of
this. Details are as follows:
2 Tables
CREATE TABLE `p_ad` (
`id` int(11) NOT NULL auto_increment,
`cat` mediumint(9) NOT NULL default '0',
`title`
Okay, I've been googling for about half an hour, found several useful links
but I'm still having a problem with the password for the initial mysql db
that is created when you follow the install instructions.
Here is the problem I'm having:
joseph-a-nagy-jr root # /usr/bin/mysqladmin -u root -h
Problem solved. ):
--
Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org
Political Activist Extraordinaire Peace, Life, Liberty
The only fallacy is the inaction on our part to stave off the worst of
horrors, the stripping of personal freedom. -- Joseph A. Nagy, Jr. January 2004
on 04/11/2004 03:00 PM, Mustafa Hakim at [EMAIL PROTECTED] wrote:
I am trying to install MySql on MAC OS X. After the pkg is installed I am
not able to start the MySql server due to the Socket error.
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Steven,
In your case, you query doesn't even use an index. And you are using an
order by DESC. Now what I would recommend is something like this, change
your query just to test this out.
SELECT p.* FROM p_cat c, p_ad p WHERE p.cat = c.id AND c.lft
BETWEEN 4 AND 5 ORDER BY p.date DESC LIMIT
On Sun, Apr 11, 2004 at 06:34:28PM -0500, Joseph A. Nagy, Jr. wrote the following:
Problem solved. ):
snip
Well, it wasn't a problem with mysql per sey but a problem with how I was
entering the command.
The man page says
/usr/bin/mysqladmin -u user -p somepassword
is correct as is
Hi,
I found some problematic queries which locks mysql server any further
processing. I'm using mysql-4.0.18
from FreeBSD ports collection. I'm using FreeBSD-5.2-CURRENT.
Some of the queries like :
select sum(total_amount) pbc from customers.payment where contract_id=0
and contract_id=4999 and
Don't use rsync. Try rdiff-backup, its much more reliable and offers
rolling restoration.
On Sat, 2004-04-10 at 02:08, Matt W wrote:
Hi Steve,
You might want to look at FLUSH TABLES WITH READ LOCK. That's a query
to run from mysql, but I'm sure you can get it to work in your shell
script
Hi Matt,
if Steve can accept the limitations, mysqlhotcopy might work for him:
http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html
If not, mysqldump with --add-locks could do it fairly easily, I should
think...
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Saturday, April 10, 2004, 5:08:43
I have been trying for months to set up mysql on my Mac (Panther) with
no success. I can't run mysqladmin as root. I get an access denied
error message. If I try to use SHELLmysqladmin -u root password
'password' I get access denied as either root or the regular user. I
can't run mysql as
36 matches
Mail list logo